Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22544 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / manoj.oracle
Delete command is a dml command
truncate command is a ddl command
Delete command has a where clause.
truncate hasn't where clause.
Delete doesn't release memory space(means we can rollback
the deleted rows)
truncate releases memory space(means we can't rollback)
By using synonym we can delete a rows(Delete command).
By using synonym we can't delete a rows(Truncate command).
| Is This Answer Correct ? | 29 Yes | 0 No |
Post New Answer View All Answers
what is the scenario where you take the database to NoArchivelog mode?
Why use resource manager in Oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to connect ms access to oracle servers?
Why oracle is used?
What do you mean by merge in oracle and how can we merge two tables?
How to execute the package in oracle?
How do you bind variables in oracle?
Why packages are used in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to recover a dropped table in oracle?
How to rename an existing table?
How to define an external table with a text file?
Please explain drop constraint oracle?
What is index in Oracle?
