Sunday, January 9, 2011

Code : Create Global temporary tables

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;

No comments:

Post a Comment

 

Travel with my styels. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com