Interested to Buy Any Domain ? << Click Here >> for more details...
what is exact difference between drop and truncate table.
- 3 Answers
- 7162 Views
- I also Faced
- E-Mail Answers
Answer Posted / samad
ya its correct sowjanya
DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all
spaces allocated for the records are removed in this
rollback is not possible
DELETE - deletes all records from a table, the space for the
records remain rollback is possible
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
what happened to the global index when I truncate the data in one of the partition?
Can we write dml statement in function in oracle?
what is the dual table in oracle?
What are joins, explain all types of joins?
what are archived logs?
How remove data files before opening a database?
Explain how you would restore a database using RMAN to Point in Time?
Can I create users through internet explorer in oracle 10g?
What is the database name in oracle?
What is the quickest way to export a table to a flat file?
How to use subqueries with the in operator using oracle?
How to use "for" statements in oracle?
How to convert characters to times in oracle?
What is the difference between online and offline backups?
What is a table index?
