I've been writing some different migration scripts for an Oracle database and I'm hoping Oracle has something similar to MySQL's "IF EXISTS" construct. Whenever I need to drop a table in MySQL, here's what I use:
DROP TABLE IF EXISTS `table_name`;
So if the table doesn't exist, the DROP doesn't give an error and the script keeps going. Does Oracle have anything like this? Thank you for your help.