Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22130 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 is port in oracle? how is it related to database application.
What is sequence?
How to speed up webrick?
What is oracle sid?
How do you tell what your machine name is and what is its IP address?
How to create a server parameter file?
What is the recommended interval at which to run statspack snapshots, and why?
Why does Oracle not permit the use of PCTUSED with indexes?
What is program global area (pga) in oracle?
What is a lookup table in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
Is a rollback possible to any savepoint?
How to change user password in oracle?
What is the implicit cursor in oracle?
Explain what are clusters?
