diff between DELETE and TRUNCATE?.
- 14 Answers
- 18117 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / p.baskar
DELETE is DML Command, TRUNCATE is DLL Command.
DElete used to particular record or, all records from table.
But TRUNCATE only relete the all records.
Ee can rollback the DELETE Command, But we cant rollback the
TRUNCATE
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to select some columns from a table in oracle?
How to select an oracle system id (sid)?
How to create a new view in oracle?
List the various oracle database objects?
How do I uninstall oracle client from windows?
What are the numeric comparison operations?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What are the logical operations?
What is hash cluster in oracle?
How to define an external table with a text file?
What are the uses of synonyms?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
how the indexes are stored in the Oracle Database?
What are triggers in oracle?
What is data file?
