what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 58175 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / pavan_1981
truncate is ddl command.its faster than delete as it doesnt
have go through the rollbacks etc.truncate being a ddl is
auto commit.we can only truncate the whole table(cant use
where clause).once table is truncated we cant rollback the
changes.when a table is truncated the memory occupied is
released.that id the water mark is adjusted.
delete is a dml command and can be rolled back.is slower
than truncate as it is dml has to go through rollback
segments etc.we can use where clause with delete.when a
table is deleted memory occupied is not released ans also
the water mark is not adjusted.
| Is This Answer Correct ? | 153 Yes | 11 No |
Post New Answer View All Answers
How would you determine what sessions are connected and what resources they are waiting for?
What do you mean by hz_ in customer tables? : oracle accounts receivable
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What view would you use to determine free space in a tablespace?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
8. Supporting AP, AR and GL?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
Explain prerequisites and post activities of oracle database installation
What is the difference between conversions and interfaces? : oracle accounts receivable
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
Explain about party and customer in ar : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable
