diff between DELETE and TRUNCATE?.
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 experiment a data lock in oracle?
What is private procedure oracle?
What is hash cluster in oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Compare and contrast between sql and sql server and explain its various functions?
Why is oracle database so popular?
What is the difference between postgresql and oracle?
Explain an extent?
What privilege is needed for a user to delete rows from tables in another schema?
why dont we assign not null constraint as table level constraint.
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?
What happens if the update subquery returns multiple rows?
How do I know if oracle is installed on windows?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Explain compound trigger in oracle?