oracle 建立测试表
以下语句可实现建立大表的功能：create table test_objects nologging as select rownum> declare
l_cnt number;
l_rows number:=&1;
begin
insert /*+ append */ into test_objects select rownum,a.* from dba_objects a;
l_cnt:=sql%rowcount;
commit;
while(l_cnt
页:
[1]