diff between DELETE and TRUNCATE?.
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 a database is related to tablespaces?
what is normalisation?what are its uses?
What is an external table?
How to define a variable of a specific record type?
Explain the use of inctype option in exp command.
What are the set operators union, union all, minus & intersect meant to do?
How can we find out the duplicate values in an oracle table?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Explain integrity constraint?
Explain the difference between a procedure and a function?
Explain the difference between sql and oracle?
How to write an inner join with the where clause in oracle?
How to retrieve values from data fields in record variables?
how to clone 9i Database on to 10g Database.
Explain cascading triggers.