Interested to Buy Any Domain ? << Click Here >> for more details...
what is exact difference between drop and truncate table.
- 3 Answers
- 7164 Views
- I also Faced
- E-Mail Answers
Answer Posted / sowjanya
Drop Statement deletes the Table structure from the database.
Truncate statement will delete the entire data from Table
and keeps the Table structure as it is in the DB.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is difference between truncate and delete?
What is sharded cluster?
Can we write dml statement in function in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How do I connect to oracle?
Where is the export dump file located?
What is the difference between count (*), count (expression), count (distinct expression)?
What are the different oracle database objects?
What is memory advisor in Oracle?
How to convert a string to a date in oracle database?
Difference between oracle's plus (+) notation and ansi join notation?
How translate command is different from replace?
Is oracle a language?
What is open database communication (odbc) in oracle?
What are the arithmetic operations?
