declare tbl_exist number;
   BEGIN
        select
count(*) into tbl_exist from user_tables where
Upper(table_name)=Upper('test1');
       
DBMS_OUTPUT.put_line(tbl_exist);
        if tbl_exist =
1 then 
           EXECUTE
IMMEDIATE 'drop table test1';
        end if;
   end;
 
 
 
No comments :
Post a Comment