diff between DELETE and TRUNCATE?.
- 14 Answers
- 18139 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / shree
Delete command always used with where clause.
but Truncate is not.
Delete command deletes only selected rows/records from table
which are defined in where clause.
But Truncate command deletes all records from the Table
without using where clause.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is an Oracle index?
What is a sub query and what are the different types of subqueries?
Explain compound trigger in oracle?
Differentiate between post-database commit and post-form commit?
How to define a procedure inside another procedure?
What are a query and state the different types of queries and their uses?
How many memory layers are in the oracle shared pool?
What are the oracle built-in data types?
Which is better Oracle or MS SQL? Why?
How to start instance with a minimal initialization parameter file?
What is oracle latest version?
master table and child table performances and comparisons in Oracle ?
What is a trigger and what are its types?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to define a record variable to store a table row?
