Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24519 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / debi
1.when we use delete command then the records from the
table is not deleted permanently so that when we further
use rollback command the records are again available in the
table but in case of truncate the data is permenently
deleted from the table.
2.in case of truncate data deletion is faster as compared
to delete
3.
we can't use ant where condition in case if truncate
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Does inner join remove duplicates?
What is case function?
How can you load microsoft excel data into oracle? : aql loader
Which join condition can be specified using on clause?
How do I remove duplicates in two columns?
What do you mean by dbms? What are its different types?
what are the different functions in sorting an array? : Sql dba
How can I change database name in sql?
How is data stored on a disk?
What is database sql?
What is 19 null in sql?
What are different types of functions in sql?
What is the life of an sql statement?
How to order siblings in oracle hierarchy queries?
