diff between DELETE and TRUNCATE?.
- 14 Answers
- 18184 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
How to recover a dropped table in oracle?
How to retrieve the count of updated rows?
What is the database name in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Explain a private synonyms?
How to start a specific oracle instance?
Explain database link?
What is bind variable in oracle 11g?
What is the recommended interval at which to run statspack snapshots, and why?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How to drop a tablespace?
Which is better Oracle or MS SQL? Why?
How to list all indexes in your schema?
How will you write a query to get a 5th rank student from a table student_report?
