delete query and table lock oracle code example Example: oracle sql drop table purge DROP TABLE customers PURGE;