Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22006 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 PL/SQL ?
Can multiple columns be used in group by in oracle?
Explain about integrity constraint?
What is memory advisor in Oracle?
What are the parameters that we can pass through a stored procedure?
Can we protect our pl/sql source code?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to calculate date and time differences in oracle?
How to recover a dropped table in oracle?
What is an oracle cursor variable?
Oracle
Explain an extent?
master table and child table performances and comparisons in Oracle ?
What are the original export and import utilities?
What is the data pump import utility?
