What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 20482 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / raam
Delete command will remove the data values ( all the
records of table) and space and table structure will be
ramain. We cannot free the space and remove the table
structure using Delete command.
Truncate command will free the memory and removes table
structure from data dictionary.
ramumcato@yahoo.com
| Is This Answer Correct ? | 9 Yes | 11 No |
Post New Answer View All Answers
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Does oracle use sql?
How do you go back in sql?
What are the 3 types of behavioral triggers?
how to use 'mysql' to run sql statements? : Sql dba
what is the difference between delete and truncate statement in sql? : Sql dba
What are the different types of triggers?
How do I run sql?
Explain sql data types?
what are the different type of normalization? : Sql dba
Is sql a programming?
What are sql queries used for?
Are there any features that are decommissioned in 11g that are not present in 11g?
How to change the order of columns in Oracle SQL Plus ?
What is a natural join sql?
