how can we drop all tabels from user at one time?

					 set pages 0
spool droptables.sql
select 'drop table || tname ||  ' cascade constraints;'
from tab;

spool off
@droptables.sql

أو

begin
 for rec in 'select tname from tab' loop
execute immediate 'drop table '|| rec.tname ||' cascade constraints';
 end loop;
end;

تحياتي

					 set pages 0
spool droptables.sql
select 'drop table || tname ||  ' cascade constraints;'
from tab;

spool off
@droptables.sql

أو

begin
 for rec in 'select tname from tab' loop
execute immediate 'drop table '|| rec.tname ||' cascade constraints';
 end loop;
end;

تحياتي

thank s 4 u
greeting