Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22029 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / sahaja mallarapu
Delete is a DML command.
Truncate is a DDL command.
Using delete we can delete specific rows by applying some
condition.
using truncate all rows are deleted. we cant apply any
condition here.
deleted rows can be rollbacked.
truncated rows cant be rollbacked.
memory occupied by deleted rows cant be reused.
memory occupied by truncated rows can be reused.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between pre-select and pre-query?
What is enter substitution variable in oracle?
What is format trigger?
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.
How to declare a local variable?
Explain the types of exception?
How to install oracle odbc drivers?
What is the usage of save points in oracle database?
please explain.. DB architecture ...
What is bulk collect in oracle?
Explain the use of constraints option in exp command.
What are set operators?
What is the data pump import utility?
Why cursor variables are easier to use than cursors?
How to get a list of all background sessions in the database?
