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