Tuesday, 30 May 2017

Difference between delete and truncate in Oracle SQL

Difference between delete and truncate:-


1) Delete is a DML Command while as Truncate is a DDL Command

2) Delete locks  table row while as Truncate locks entire table

3) We can use "where condition" with delete while as we can't user "where
condition" with Truncate

4) DML Trigger fired during the delete while as DML Trigger doesn't fire during the Truncate

5) We can rollback delete operation while as we can't rollback Truncate operation



Related Topics :-

1 comment:

  1. Thanks for the given information you are providing content very usefull to users.
    Learn How to Work With Ref Cursor in ORACLE 12C For Beginner Actual cost of this course is 9,999/- But now Kuncham Software Solutions Pvt ltd is giving you Free access. Limited period offer Hurry-up Enroll Now at Udemy.


    Hurry-Up Enroll Now and get Free Access to the Entire Course


    ReplyDelete

Cloning database with RMAN

Below are the steps to clone production database(primedb) to UAT database(clonedb)   STEP1 :- Check the both servers are able to connect ...