diff between DELETE and TRUNCATE?.
Answer Posted / padma
delete comd is used to delete not a specific record rather
all records without affecting the structure of the records
truncate comd is used to delete all the records from
existing table,retaining the structure o that table.
by using delete comd v can rollback all the delete
records .it is record level cmd
wherease truncate cmd v cannot rollback. it is table
level cmd
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is a relational database management system?
How to do clean up if create database failed?
What is the difference between 10g OEM and 11g OEM?
Explain parameter file in oracle.
Give the constructs of a package, function or a procedure.
What does sharding mean?
How to load data from external tables to regular tables?
What are the differences between primary key and unique key?
Explain the use of Merge statement in oracle 11g
What would you do with an in-doubt distributed transaction?
Explain what are the type of synonyms?
Which environment variables are absolutely critical in order to run the OUI?
How to connect ms access to oracle servers?
What is the fastest query method to fetch data from the table?
Difference between the “verify” and “feedback” command?