Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22031 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
What is an oracle transaction?
Explain the use of record length option in exp command.
Is the After report trigger fired if the report execution fails ?
Is primary key indexed by default in oracle?
Explain the use of indexes option in exp command.
How to invoke the data pump export utility?
Where is the export dump file located?
What are temporal data types in oracle?
How to define an explicit cursor in oracle?
What happens to the data files if a tablespace is dropped?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What is define in oracle?
WHAT IS ecc 6.0
what are the default admin accounts in Oracle 10g ?
