Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22546 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / sahaja mallarapu
Delete is a DML command.
Truncate is a DDL command.
Using delete we can delete specific rows by applying some
condition.
using truncate all rows are deleted. we cant apply any
condition here.
deleted rows can be rollbacked.
truncated rows cant be rollbacked.
memory occupied by deleted rows cant be reused.
memory occupied by truncated rows can be reused.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the relation of a user account and a schema?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is an oracle database?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
what is reindexing?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
State some uses of redo log files?
How to define a procedure inside another procedure?
What is the difference between postgresql and oracle?
What are the restrictions in a oracle read only transaction?
How to drop an index?
How can we force the database to use the user specified rollback segment?
