Sapna Malik
What is the difference between Delete, Truncate and Drop in Oracle?
Posted by Sapna Malik in SQL Server on Mar 18, 2011
  • 0
  • 1
  • 4058
Do you know the answer for this question? Post it below.
Guest
Posted by Sapna Malik on Mar 18, 2011
  • 0

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


Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS