Truncate Vs Delete

What is the difference between truncate and delete?


  1.  Truncate deletes all records at once unconditionally, whereas delete can delete the records conditionally or unconditionally.
  2. Deleted data by truncate command can not be rolled back, whereas deleted data by delete command can be rolled back.
  3. Memory will be released after deletion of record by truncate command whereas memory will not be released after deletion of record by deleted command.
  4. Truncate is a DDL command, whereas delete is DML command.
  5. Trigger does not get fired in case of  TRUNCATE whereas triggers get fired in case of a DELETE command.
  6. We can not TRUNCATE a table if table have any foreign key constraint. We need to remove the constraint  then truncate the table and recreate the constraint.
at
Labels:

DBMS_XPLAN

One more way we can see the Explain Plan by using DBMS_XPLAN package. DBMS_XPLAN automatically queries the last plan in PLAN_TABLE. It u...

  • Difference Between Collection and Record
    What is the difference between Collection and Records? Collection Record The internal components always have the same data type, ...
  • DBMS_XPLAN.DISPLAY_CURSOR
    DBMS_XPLAN.DISPLAY_CURSOR show actual execution plan from dynamic performance views. DBMS_XPLAN:   The DBMS_XPLAN package provides an eas...
  • Question For Collections
    PL/SQL Interview Question  for Collections. What is Collection? How many type of collection? Why or when we will use collection? What i...