I’m writing some migration scripts for an Oracle database, and was hoping Oracle had something similar to MySQL’s IF EXISTS construct.
Specifically, whenever I want to drop a table in MySQL, I do something like
DROP TABLE IF EXISTS `table_name`;
This way, if the table doesn’t exist, the DROP doesn’t produce an error, and the script can continue.
Does Oracle have a similar mechanism? I realize I could use the following query to check if a table exists or not
SELECT * FROM dba_tables where table_name="table_name";
but the syntax for tying that together with a DROP is escaping me.