diff between DELETE and TRUNCATE?.
- 14 Answers
- 19712 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
Why is oracle so popular?
How would you go about verifying the network name that the local_listener is currently using?
Explain do view contain data?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
what happened to the global index when I truncate the data in one of the partition?
What is a snapshot log?
What is oracle update statement with inner join ?
Explain the truncate in oracle?
How do I escape a reserved word in oracle?
Is there a function to split a string in plsql?
11. Display the client number and name and the client number and name of the person who referred that client.
Define oracle database
How can we delete duplicate rows in a table?
What are the different types of record groups in oracle? Explain each of them
What is system global area (sga) in oracle?
