Interested to Buy Any Domain ? << Click Here >> for more details...
what is exact difference between drop and truncate table.
- 3 Answers
- 7225 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / chandana
Drop :
1.Deletes the entire table records as well as the table
structure.
2.It is a DDL Command.
3. Logs are not maintained.
4. Auto Commited.
5.Where clause cannot be used in the Drop statement.Synatx:
Drop table <Table_Name>
Trunctae:
1. Deletes the entire table records ,retains the table
structure.
2. Its a DDL Command.
3. Logs are not maintained. So faster in performace than
Delete.
4. Auto Commited.
Cannot be Rolled Back.
5.Where clause cannot be used with truncate statement.
Truncate Table <Table_Name>;
Delete:
1. Deletes the table records based on condtions ,retains
the table structure.
2. Its a DML Command.
3. Logs are maintained.So slower than trucate.
4. No Auto Commited.So can be Rolled Back.
5.Where clause can be used with truncate statement.
Syantx:
Delete from <Table_Name> where <Condition>;
| Is This Answer Correct ? | 5 Yes | 0 No |
how to use sequence and what use of sequence cache
How to create an oracle database?
How to view existing locks on the database?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
what is analyze command ? what kind of statistics does it generate?
State the difference between a primary key and foreign key?
Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?
What is a data dictionary and how can it be created?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
Without giving condition how to retrieve the unmatched records from table.
How to use "in" parameter properly?
What are the different types of trigger and explain its various uses and functions?
Oracle General 
