Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 23048 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
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
In which language oracle has been developed?
why dont we assign not null constraint as table level constraint.
What is SQL access advisor in Oracle?
Can the query output be sorted by multiple columns in oracle?
How to drop an index in oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What are the execution control statements?
How to check your oracle database 10g xe installation?
How to join two tables in a single query using oracle?
Explain view?
How to grant create session privilege to a user in oracle?
Explain do view contain data?
What are the roles of dba?
How to download oracle database 10g xe?
What is ASM (Automatic Storage Management) in Oracle?
