DELETE
· It’s a DML command
· It can be used to delete all or specifed number of records
· We can use WHERE clause with DELETE
· We can do ROLLBACK
· Oracle server do not free the allocated memory after DELETE operation
TRUNCATE
· It’s a DDL command
· It can be used to delete all records
· We can not use WHERE clause with TRUNCATE
· We can not do ROLLBACK, since it is a DDL command
· Oracle server free the allocated memory after TRUNCATE operation
DROP
· It’s a DDL command
· It can be used to delete all records along with table structure
· We can not use WHERE clause with DROP
· We can not do ROLLBACK, since it is a DDL command
· Oracle server free the allocated memory after DROP operation
