oracle delete table query code example Example: oracle sql drop table DROP TABLE my_table; -- To 'really' free space DROP TABLE my_table PURGE;