Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22024 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 write an inner join with the where clause in oracle?
Explain a synonym?
Explain the use of full option in exp command.
What is the parameter mode that can be passed to a procedure?
what is the difference between restoring and recovering?
How many types of database triggers exist?
State and explain about oracle instance?
What do you mean by a tablespace?
How to enter a new row into a table interactively?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is not equal to in oracle?
How to turn on or off recycle bin for the instance?
What is the meaning of recursive hints in oracle?
How to sort the query output in oracle?
Difference between cartesian join and cross join?
