A quick clever way to avoid Table Does not Exist Error when you have to drop the table in a pl/sql routine. This method saves you searching the data dictionary user_table:
Begin
execute immediate 'Drop table PRODUCT';
Exception
when others then null;
End;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment