Answer Posted / shivaindu
Differentiate between TRUNCATE and DELETE:
-----------------------------------------
TRUNCATE deletes much faster than DELETE
TRUNCATE HAS NO CONDITION CLAUSE. WHERE AS DELETE HAS CONDITION.
Delete
~~~~~~
1> Executes triggers
2> DML statement
3> Roll back possible
4> Flash query can get the data
5> cannot free the table free space
Truncate
~~~~~~~~
1>No trigger Execution
2>DDL statement
3>No roll back possible
4>can’t get data from flash queries
5>Option to free table space
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you skip header records while loading? : aql loader
How does stored procedure reduce network traffic?
Is left join inner or outer?
Define implicit and explicit cursors.
Is record in pl sql?
what is recursive stored procedure? : Sql dba
What do you mean by stored procedures?
What are the advantages of indexing?
what is the difference between delete and truncate commands? : Sql dba
what is a constraint? : Sql dba
What is the difference between function and procedure in pl/sql?
How much does sql cost?
Is pl sql better than sql?
What is sql in java?
What are keys in sql?
