Below are some examples of how to create tables in Oracle 12. PL\/SQL, for the most part PL\/SQL follows standard SQL conventions.<\/p>\n
<\/p>\n
Normal way to drop a table.<\/p>\n
DROP TABLE EventRequest;<\/pre>\nNothing too fancy here, just drop the table.<\/p>\n
Check before Dropping<\/h5>\n
While if you issue the DROP TABLE command and the table doesn’t exist, you will get an error message, however it isn’t too severe and can be ignored. Although in completeness I will show how to suppress or receive error messages when dropping a table.<\/p>\n
BEGIN\r\n EXECUTE IMMEDIATE 'DROP TABLE EventRequest';\r\n -- Other option is to use PURGE option\r\n -- EXECUTE IMMEDIATE 'DROP TABLE EventRequest PURGE';\r\n WHEN OTHERS\r\n THEN\r\n -- show the error message\r\n DBMS_OUTPUT.put_line(SQLERRM);\r\n -- suppress the error message\r\n -- NULL\r\nEND;<\/pre>\nIn the above example there are a couple of options that you can use. Remove the comment indicator “–” from the beginning of the line, and add the comment indicator, “–” to the other line.<\/p>\n
The first one is if you want to immediately PURGE the table, and not send it to the recycle bin, you can use the PURGE option at the end of the DROP TABLE statement.<\/p>\n
The next option would be to show or suppress the error messages.\u00a0 You can either send the error message about the table not existing when trying to drop the table to NULL; and therefore never see the error message.\u00a0 Or you may want to see error messages related to trying to drop the table.<\/p>\n
I hope you found the above informative, let me know in the comments below.<\/p>\n