What is the diff between Truncate table / delete <table name> purge

What is the diff between Truncate table / delete <table
name> purge

Question Posted / pradeeptma

3 Answers
15005 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the diff between Truncate table / delete <table name> purge..

Answer / murthy

TRUNCATE:-IT WILL DELETE ALL THE EXISTING RECORDS IN A TABLE

SYNTAX:-TRUNCATE TABLE <TABLE NAME>

DELETE:-IT WILL DELETE THE RECORDS IN A TABLE DEPENDINFG ON
THE GIVEN CONDITION.

SYNTAX:-DELETE FROM <TABLE NAME> WHERE <CONDITON>

PURGE:-AFTER PERFOMING DROP OPERATION THE TABLES WILL STORE
AT UNDO LOGS SO TO DELETE THE DATA COMPLETELY FROM TAHE
DATA BASE WE WILL PURGE THE RECYCLEBIN.

SYNTAX:-PURGE RECYCLEBIN.

Is This Answer Correct ?

10 Yes

4 No

What is the diff between Truncate table / delete <table name> purge..

Answer / d.elumalai

DELETE:

1.DML Command.
2. Can be used with WHERE clause.
3. Can be rolled back.
4. Deletes table contents row by row when executed.
5. Delete is slow
6.Doesn't frees-up the Storage Space
7.Creates the log file
8.Returns the no. of rows deleted when queried.
9. Trigger gets fired incase of Delete.
10. Date gets copied into the Rollback tablespace after
Delete is executed.

TRUNCATE:

1.A DDL Command,
2.Can't be used with WHERE clause.
3.Can't be Rolled back.
4.Drops the entire table contents when executed but not the
table. [Note:DROP commnad deletes the entire contents along
with the table]
5.Truncate is faster.
6.Frees-up the Stroage Space
7. Doesn't create a log file
8.Doesn't return the no. of rows deleted when queried.
9.Trigger doesn't get fired incase of Truncate.
10.Data gets romoved directly without copying it into the
Rollback tablespace when truncate is executed.

Is This Answer Correct ?

6 Yes

0 No

What is the diff between Truncate table / delete <table name> purge..

Answer / papia

Truncate table removes all rows from the table and alos
releases the storage space and as it is a DDL statement so
no Rollback information is available
Delete statement also removes the row but does not release
the storage space
Truncate is faster than delete.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer