Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 65410 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / vasanth
Truncate
1.Truncate Can be DDL Command.
2.it can be rollback.
3.we cann't use Where clause.
4.truncate=delete+commit so we cann't rollback.
5.truncate delete all record from the table.
6.truncate is a DDL command and cannot be rollbackand all
memory space is released back to server.
7.speed faster.
8.do not chcek constraint.
Delete
1.Delete Can be DML Command.
2.it can be rollback.
3.we can use Where clause.
4.delete=delete-- so we can be rollback.
5.delete delete record from the table.
6.truncate is a DDL command and can be rollback and all
memory space is not released back to server.
7.speed slow.
8. chcek constraint.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is chargeback invoice? How do we create it? : oracle accounts receivable
can we use lexical perameter in oracle plsql if yes how
Are These Dff's Flexible?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is Restricted Mode of Instance Startup in Oracle?
what is difference between inner join & nested query or subqueries
what are the tools used for oracle 10g in real time.
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
What is the use of lockboxes? : oracle accounts receivable
Where in the Oracle directory tree structure are audit traces placed?
What is auto invoicing? Explain : oracle accounts receivable
What are different types of receipt reversals ? Explain them : oracle accounts receivable
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
what are basic modules required to implement oracle application in any oraganisation?
How would you determine what sessions are connected and what resources they are waiting for?
