Interested to Buy Any Domain ? << Click Here >> for more details...
what is exact difference between drop and truncate table.
- 3 Answers
- 7056 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 do you mean by merge in oracle and how can you merge two tables?
What are a query and state the different types of queries and their uses?
Why is oracle so popular?
What are the various oracle database objects?
What is oracle datasource?
How to use regular expression in pattern match conditions in oracle?
What is a sub query and what are the different types of subqueries?
What is the max number of columns in an oracle table?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Can group functions be used in the order by clause in oracle?
How to work with data objects interactively?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
Explain the use of record length option in exp command.
What are the advantages of oracle?
How to sort the query output in oracle?
