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
  • 4293
Do you know the answer for this question? Post it below.
Posted by Sapna Malik on Mar 18, 2011
  • 0

<font size="2"><font face="Verdana" size="2"><b>Delete:</b> The delete command means delete the value of the table. We can delete one or more rows of the table.<br><br></font></font><font size="2"><font face="Verdana" size="2"><b>Truncate: </b>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.</font></font><br><br><font size="2"><font face="Verdana" size="2"><b>Drop:</b> 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. </font></font><a href="">More....</a><br>