diff between DELETE and TRUNCATE?.
- 14 Answers
- 19730 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / thirupathi.l
delete is a dml command using this we can getback the records.
it will not call inmplicit commit.
perfomance slow in case of delete no.of records.
truncate is a ddl commnd.itwillcall implicit commit
we can't get back the record
performance good in case of deleting no.of records
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How do you store pictures in a database?
What language does oracle use?
Explain what are the different type of segments?
How to start instance with a minimal initialization parameter file?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
what are bitmap indexes? How does they work?
What is oracle join syntax?
How can we delete duplicate rows in a table?
How to run create database statement again?
what is IDE,DMV in sql server?
Why do we need oracle client?
What is the purpose of save points in oracle database?
What is memory advisor in Oracle?
What is the difference between substr and instr?
What is the Tune Query
