15:35:22 SQL> SPOOL C:\P_A.SQL
15:35:35 SQL> SELECT TEXT FROM USER_SOURCE WHERE TYPE='PROCEDURE' AND NAME='P_A';TEXT
--------------------------------------------------------------------------------
procedure p_a as
begin
insert into t select * from tt where rownum<6;
dbms_output.put_line(sql%rowcount);
end p_a;已用时间: 00: 00: 00.31
15:35:38 SQL> SPOOL OFF;
15:35:43 SQL>
15:35:35 SQL> SELECT TEXT FROM USER_SOURCE WHERE TYPE='PROCEDURE' AND NAME='P_A';TEXT
--------------------------------------------------------------------------------
procedure p_a as
begin
insert into t select * from tt where rownum<6;
dbms_output.put_line(sql%rowcount);
end p_a;已用时间: 00: 00: 00.31
15:35:38 SQL> SPOOL OFF;
15:35:43 SQL>
谢谢
bzszp(www.bzszp.533.net)