1
Reply

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

Sapna Malik

Sapna Malik
14y
5.7k
0
Reply
    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....
    Sapna Malik
    14y
    0
Message