废话少说~直接看代码
输出单行
- declare
- tn varchar2(100);
- begin
- select tname into tn from tab where tname='TEST4';
- dbms_output.put_line(tn);
- end;
输出多行(内嵌表)
- declare
- type tbl_tabs_name is table of varchar2(32676) index by binary_integer;
- v_table_name tbl_tabs_name;
- begin
- select a.sql_text bulk collect into v_table_name from v$sqltext a,v$session b,v$process c
- where c.spid=22468
- and b.PADDR=c.ADDR
- and b.SQL_ADDRESS=a.ADDRESS;
- for i in 1 .. v_table_name.count loop
- dbms_output.put_line(v_table_name(i));
- end loop;
- end;
- /
转载于:https://blog.51cto.com/omygreen/949002