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>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货