drop all tables oracle code example

Example: oracle sql drop table

DROP TABLE my_table;
-- To 'really' free space
DROP TABLE my_table PURGE;