1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
|
CREATE GLOBAL TEMPORARY TABLE tst
(
OWNER VARCHAR2(30),
OBJECT_NAME VARCHAR2(128),
SUBOBJECT_NAME VARCHAR2(30),
OBJECT_ID NUMBER,
DATA_OBJECT_ID NUMBER,
OBJECT_TYPE VARCHAR2(19),
CREATED DATE,
LAST_DDL_TIME DATE,
TIMESTAMP VARCHAR2(19),
STATUS VARCHAR2(7),
TEMPORARY VARCHAR2(1),
GENERATED VARCHAR2(1),
SECONDARY VARCHAR2(1),
NAMESPACE NUMBER,
EDITION_NAME VARCHAR2(30)
) ON COMMIT PRESERVE ROWS;
create or replace procedure testload as
begin
insert into tst select * from dba_objects;
commit;
end;
/
Select count (*) from tst;
SQL> select count (*) from tst;
COUNT(*)
----------
0
SQL> exec testload;
PL/SQL procedure successfully completed.
SQL> select count (*) from tst;
COUNT(*)
----------
75214 |
Partager