diff between DELETE and TRUNCATE?.
- 14 Answers
- 19811 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
Please explain joins in oracle?
What is materialized view in Oracle?
What are the common oracle dba tasks?
Why does oracle 9i treat an empty string as null?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is the difference between alert log file and tarce file ?
What are the different types of modules in oracle forms?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to loop through data rows in the implicit cursor?
What are the parameters that we can pass through a stored procedure?
What is query image?
What is an oracle tablespace?
Give the advantages and disadvantages of clusters.
Where are the settings stored for each instance in oracle?
