diff between DELETE and TRUNCATE?.
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 privilege is needed for a user to create views in oracle?
Difference between hot backup vs. Cold backup?
What is a database schema in oracle?
Give the constructs of a package, function or a procedure.
What is the difference between I and G in Oracle?
Is oracle an operator?
How to use regular expression in pattern match conditions in oracle?
How to work with data objects interactively?
Why is oracle database so popular?
What is a sub query? Describe its types?
What is a named program unit?
Explain the use of rows option in exp command.
What is query image?
What is a package ? What are the advantages of package ?
How to convert dates to characters in oracle?