what is exact difference between drop and truncate table.
- 3 Answers
- 5839 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 the difference between restoring and recovering?
What are the attributes that are found in a cursor?
What are the differences between blob and clob in oracle?
Is oracle an open source?
Why do we need oracle client?
Is oracle the best database?
What is pragma autonomous transaction in oracle?
How to check the oracle tns settings?
What is the minimum client footprint required to connect c# to an oracle database?
How to bring a tablespace offline?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Can we call procedure inside function in oracle?
What is oracle instant client?
Can we create database in oracle using command line ?
Explain compound trigger in oracle?
