Hi,
I want to create a session level temporary tables..
declare
a varchar2(200);
begin
a := 'create global temporary table sam on commit preserve rows as select * from emp';
execute immediate a;
end;
How to create and drop the the sam table within the loop.
Thanxx
sam