Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22633 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
Can we write insert statement in function in oracle?
How to loop through a cursor variable?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is an oracle tablespace?
What is the scope of a local variable?
Write a syntax for update query in oracle?
Briefly explain what is literal? Give an example where it can be used?
What is concurrency in oracle?
Difference between the “verify” and “feedback” command?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to recover a dropped table in oracle?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is the sid in oracle?
What is open database communication (odbc) in oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
