Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22659 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 a static data dictionary in oracle?
Explain the use of rows option in imp command.
What is merge in oracle?
What do you mean by merge in oracle and how can we merge two tables?
How many types of tables supported by oracle?
Calculate difference between 2 date / times in oracle sql?
What are a query and state the different types of queries and their uses?
Differentiate between function and procedure in oracle.
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
How to create a stored program unit?
What is the meaning of recursive hints in oracle?
What happens to the data files if a tablespace is dropped?
How to retrieve values from data fields in record variables?
How to run create database statement?
How to divide query output into groups in oracle?
