1. 首页
  2. IT资讯

PL/SQL表—table()函数用法

http://www.itpub.net/thread-617298-1-1.html[@more@]/*PL/SQL表—table()函数用法:利用table()函数,我们可以将PL/SQL返回的结果集代替table。simple example:1、table()结合数组:*/create or replace type t_test as object(id integer,rq date,mc varchar2(60));create or replace type t_test_table as table of t_test;create or replace function f_test_array(n in number default null) return t_test_tableas v_test t_test_table := t_test_table();begin for i in 1 .. nvl(n,100) loop v_test.extend(); v_test(v_test.count) := t_test(i,sysdate,’mc’||i); end loop; return v_test;end f_test_array;/select * from table(f_test_array(10));/*2、table()结合PIPELINED函数:*/create or replace function f_test_pipe(n in number default null) return t_test_table PIPELINED as v_test t_test_table := t_test_table();begin for i in 1 .. nvl(n,100) loop pipe row(t_test(i,sysdate,’mc’||i)); end loop; return; end f_test_pipe; /select * from table(f_test_pipe(20));/*3、table()结合系统包:*/create table test (id varchar2(20));insert into test values(‘1’);commit;explain plan for select * from test;select * from table(dbms_xplan.display);

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/450962/viewspace-1028687/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/194642.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code