Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22644 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
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is recycle bin in Oracle?
What is a package in oracle?
how to make an oracle object
When do we use group by clause in a sql query?
Why is oracle so popular?
How to get maxsal , minsal, ename department wise in single query
Give the constructs of a package, function or a procedure.
What is oracle datasource?
Why do you use stored procedures and state some of its disadvantages?
What is the parameter mode that can be passed to a procedure?
What are the limitations of check constraint?
How to update a table row with a record?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is open database communication (odbc) in oracle?
