diff between DELETE and TRUNCATE?.
- 14 Answers
- 18088 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
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Why do we need oracle client?
Why cursor variables are easier to use than cursors?
what are the advantages of running a database in archive log mode?
Give the various exception types.
Explain an index segment?
How to install oracle odbc drivers?
How many anonymous blocks can be defined?
Explain an index?
How to insert a record into a table?
Why should I use oracle database?
Explain compound trigger in oracle?
How many categories of data types?
How view is different from a table?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
