Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 23069 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
Why is oracle database so popular?
What is tns entry?
How to view all columns in an existing table?
What is coalesce function?
How will you write a query to get a 5th rank student from a table student_report?
Can we call procedure inside function in oracle?
Please explain joins in oracle?
How to create tables for odbc connection testing?
What is a read only transaction in oracle?
What is a server parameter file in oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How to store only time; not date and time?
What is a named program unit?
How do we create privileges in oracle?
