Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22632 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / padma
delete comd is used to delete not a specific record rather
all records without affecting the structure of the records
truncate comd is used to delete all the records from
existing table,retaining the structure o that table.
by using delete comd v can rollback all the delete
records .it is record level cmd
wherease truncate cmd v cannot rollback. it is table
level cmd
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is meant by a deadlock situation?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to use subqueries with the exists operator in oracle?
Briefly explain what is literal? Give an example where it can be used?
What are dml statements in oracle?
What happens if the update subquery returns multiple rows?
What is the difference between a user and a schema in oracle?
How can we force the database to use the user specified rollback segment?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What is the difference between count (*), count (expression), count (distinct expression)?
How many data types are supported?
How to see the table columns used in an index?
What is the usage of control file in oracle?
What is a package ? What are the advantages of package ?
