Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22547 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / shree
Delete command always used with where clause.
but Truncate is not.
Delete command deletes only selected rows/records from table
which are defined in where clause.
But Truncate command deletes all records from the Table
without using where clause.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to define an oracle sub procedure?
How to rename an index?
Explain about the analyze command in oracle?
How to add a new column to an existing table with a default value?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is Virtual Private Database in Oracle?
What are the various types of snapshots ?
How to select all columns of all rows from a table in oracle?
Write a trigger example in oracle?
What happens to the indexes if a table is recovered?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is the difference between post-database commit and post-form commit?
What are the different types of failures that occur in Oracle database?
How to create tables for odbc connection testing?
What are the differences between char and nchar in oracle?
