What is the diff between Truncate table / delete <table
name> purge
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is normalization in a database?
What is the maximum database size for sql express?
What is the starting oracle error number? What is meant by forward declaration in functions?
why use cursors?
How much does sql certification cost?
What does “select count(1) from tab” result?
How many types of cursors are available in pl/sql?
Can I learn sql in a week?
what are the advantages of using stored procedures? : Sql dba
what is isam? : Sql dba
What does partition by mean in sql?
what is data control language? : Sql dba