diff between DELETE and TRUNCATE?.
- 14 Answers
- 18183 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
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Is primary key indexed by default in oracle?
What are the uses of Database Trigger ?
How do I uninstall oracle 11g?
What is the data pump export utility?
How many types of segments in Oracle?
How to get last row id?
How to create a stored program unit?
Why do you use stored procedures and state some of its disadvantages?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
various types of hints and their usage
How to connect to oracle using service name instead of sid?
What is control file used for?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How do I manually create a database in oracle?
