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