Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66511 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / pravesh kumar
Truncate
1.Truncate Can be DDL Command.
2.it cannot 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 ? | 14 Yes | 7 No |
Post New Answer View All Answers
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
What is autocashrule set? : oracle accounts receivable
what are basic modules required to implement oracle application in any oraganisation?
What is chargeback invoice? How do we create it? : oracle accounts receivable
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?
can u give guidance abt packages of plsql
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
Explain the use of table functions.
