Determine whether the table exists before Oracle deletes the table

Determine whether the table exists before Oracle deletes the table

If you delete a non-existing TABLE in Oracle, such as "drop table tableName", the following message is displayed:

ORA-00942: Table or view does not exist

If you execute this statement in the program, an exception is reported. Therefore, you need to determine whether the table exists before deleting the table. If yes, delete the table.

DECLARE num NUMBER; begin select count (1) INTO num FROM USER_TABLES WHERE TABLE_NAME = UPPER ('tablename'); IF num> 0 then execute immediate 'drop TABLE tablename'; end if; END;