1
Reply

What is the difference between Delete, Truncate and Drop in Oracle?

Sapna Malik

Sapna Malik

13y
4.8k
0
Reply

    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....