Interested to Buy Any Domain ? << Click Here >> for more details...
what is exact difference between drop and truncate table.
- 3 Answers
- 7220 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
How to check your oracle database 10g xe installation?
Explain the use of log option in exp command.
What is oracle in java?
Why do we need integrity constraints in a database?
Who developed oracle & when?
How to pass parameters to procedures?
What is the difference between pre-select and pre-query?
How to drop a stored procedure in oracle?
Describe varray?
what are the default admin accounts in Oracle 10g ?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is the difference between postgresql and oracle?
How can we find out the current date and time in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What do you know about normalization? Explain in detail?
