<i id='26NgR'><tr id='26NgR'><dt id='26NgR'><q id='26NgR'><span id='26NgR'><b id='26NgR'><form id='26NgR'><ins id='26NgR'></ins><ul id='26NgR'></ul><sub id='26NgR'></sub></form><legend id='26NgR'></legend><bdo id='26NgR'><pre id='26NgR'><center id='26NgR'></center></pre></bdo></b><th id='26NgR'></th></span></q></dt></tr></i><div id='26NgR'><tfoot id='26NgR'></tfoot><dl id='26NgR'><fieldset id='26NgR'></fieldset></dl></div>

        <bdo id='26NgR'></bdo><ul id='26NgR'></ul>

        <small id='26NgR'></small><noframes id='26NgR'>

      1. <tfoot id='26NgR'></tfoot>

        <legend id='26NgR'><style id='26NgR'><dir id='26NgR'><q id='26NgR'></q></dir></style></legend>
      2. 选择到Oracle中的临时表

        Select into a temporary table in Oracle(选择到Oracle中的临时表)

        <tfoot id='Twbz3'></tfoot>
          <tbody id='Twbz3'></tbody>

        <i id='Twbz3'><tr id='Twbz3'><dt id='Twbz3'><q id='Twbz3'><span id='Twbz3'><b id='Twbz3'><form id='Twbz3'><ins id='Twbz3'></ins><ul id='Twbz3'></ul><sub id='Twbz3'></sub></form><legend id='Twbz3'></legend><bdo id='Twbz3'><pre id='Twbz3'><center id='Twbz3'></center></pre></bdo></b><th id='Twbz3'></th></span></q></dt></tr></i><div id='Twbz3'><tfoot id='Twbz3'></tfoot><dl id='Twbz3'><fieldset id='Twbz3'></fieldset></dl></div>

          <small id='Twbz3'></small><noframes id='Twbz3'>

            <bdo id='Twbz3'></bdo><ul id='Twbz3'></ul>
            <legend id='Twbz3'><style id='Twbz3'><dir id='Twbz3'><q id='Twbz3'></q></dir></style></legend>

                • 本文介绍了选择到Oracle中的临时表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我正在尝试执行以下操作,

                  I am trying to do something like the following,

                  select * into temp from (select * from student);
                  

                  它给了我以下错误,

                  ERROR at line 1:
                  ORA-00905: missing keyword
                  

                  在我的真实示例中,子查询(select * from student)更复杂.

                  In my real example the subquery (select * from student) is more complex.

                  我想在存储过程中使用它,所以我不想创建表本身.我只想通过使用临时表使我的代码更具可读性.

                  I want to use this in a stored procedure, so I don't want to create the table itself. I just want to make my code more readable by using a temp table.

                  推荐答案

                  那么也许你需要做这样的事情:

                  Then perhaps you need to do something like this:

                  declare
                     type t_temp_storage is table of student%rowtype;
                     my_temp_storage t_temp_storage;
                  begin
                     select * bulk collect into my_temp_storage from student;
                     for i in 1..my_temp_storage.count
                      loop
                      dbms_output.put_line('here I am '||my_temp_storage(i).stuid);
                     end loop; 
                   end;
                  

                  这篇关于选择到Oracle中的临时表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                  相关文档推荐

                  How to call Oracle function or stored procedure using spring persistence framework?(如何使用 Spring 持久化框架调用 Oracle 函数或存储过程?)
                  What can cause intermittent ORA-12519 (TNS: no appropriate handler found) errors(什么会导致间歇性 ORA-12519(TNS:找不到合适的处理程序)错误)
                  SQL to return the number of working days between 2 passed in dates(SQL 返回两个传入日期之间的工作日数)
                  Oracle Date Subtraction(Oracle 日期减法)
                  Is using quot;select *quot; for a cursor in PL/SQL considered bad programming?(正在使用“选择 *PL/SQL 中的游标被认为是糟糕的编程?)
                  Using sql/plsql, how do you find out which character set a text uses?(使用 sql/plsql,你如何找出文本使用的字符集?)
                      <tbody id='mCf6q'></tbody>

                  • <small id='mCf6q'></small><noframes id='mCf6q'>

                    <legend id='mCf6q'><style id='mCf6q'><dir id='mCf6q'><q id='mCf6q'></q></dir></style></legend>

                      <tfoot id='mCf6q'></tfoot>

                        • <bdo id='mCf6q'></bdo><ul id='mCf6q'></ul>
                        • <i id='mCf6q'><tr id='mCf6q'><dt id='mCf6q'><q id='mCf6q'><span id='mCf6q'><b id='mCf6q'><form id='mCf6q'><ins id='mCf6q'></ins><ul id='mCf6q'></ul><sub id='mCf6q'></sub></form><legend id='mCf6q'></legend><bdo id='mCf6q'><pre id='mCf6q'><center id='mCf6q'></center></pre></bdo></b><th id='mCf6q'></th></span></q></dt></tr></i><div id='mCf6q'><tfoot id='mCf6q'></tfoot><dl id='mCf6q'><fieldset id='mCf6q'></fieldset></dl></div>