Interested to Buy Any Domain ? << Click Here >> for more details...
what is exact difference between drop and truncate table.
- 3 Answers
- 7348 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
Why packages are used in oracle?
How to pass a cursor variable to a procedure?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How many types of database triggers exist?
How to create an oracle database?
Can we create database in oracle using command line ?
What is enter substitution variable in oracle?
What is the parameter mode that can be passed to a procedure?
What are nested tables?
How to use values from other tables in update statements using oracle?
What are the original export and import utilities?
Explain the use of owner option in exp command.
Use of an integrity constraint is better to validate data. Explain
What is sequence?
What is define in oracle?
