create global temporary table gtt_ ( x_ varchar2(100) ) on commit delete rows; create table t_ ( x_ varchar2(100) ); exec redo_diff.diff_it; declare i number; begin for i in 1 .. 1000 loop insert into gtt_ values(dbms_random.string('a',99)); end loop; end; / exec redo_diff.diff_it; declare i number; begin for i in 1 .. 1000 loop insert into t_ values(dbms_random.string('a',99)); end loop; end; / exec redo_diff.diff_it;
Sunday, January 9, 2011
Code : Create Global temporary tables
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment