diff between DELETE and TRUNCATE?.
- 14 Answers
- 17963 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
Difference between pre-select and pre-query
What is the purpose of save points in oracle database?
How to use existing values in update statements using oracle?
How to rename an index in oracle?
What are the parameters that we can pass through a stored procedure?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
how to join query for one source type is oracle another source type is sql server ?
How to login to the server without an instance?
Why do you use stored procedures and state some of its disadvantages?
How to do clean up if create database failed?
How to convert raw data type into text in oracle? Explain
What is key preserved table?
Design database draw er diagram for a certain scenario ?
Can we commit inside a function in oracle?
What is a subquery in oracle?
