What is the difference between Delete, Truncate and Drop in Oracle?
Sapna Malik
Delete: The delete command means delete the value of the table. We can delete one or more rows of the table.Truncate: The truncate command means delete all rows of the table. The truncate is a data definition language (DDL) command and this command delete the all rows of the table.Drop: The drop command means delete the table from the database. The drop command is a data definition language (DDL) command and this is a table oriented command. More....