Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22641 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
What are the tools for Oracle ?
What is the difference between truncate & delete command?
What is bulk copy or bcp in oracle?
When do you get a .pll extension in oracle? Explain its importance
What happens to the current transaction if a ddl statement is executed?
WHAT IS ecc 6.0
How many types of database triggers exist?
How to enter a new row into a table interactively?
How many categories of data types?
Give the different types of rollback segments.
What is bulk collect in oracle?
What is null value in oracle?
What are the uses of linked server and explain it in detail?
How to create an oracle testing table?
What to do if dba lost the system password?
