Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66315 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / padmapriya
1) Delete create log files when it is deleted and occupy
more space of memory
Whereas Truncate will not create any log files and hence
much faster than delete.
2) Delete can be roll back whereas Truncate is autocommit.
3) When there is foreign key constraint even though there
is no data in child table Truncate cannot be done. only
when the constraint is dropped truncate can be executed.
Whereas though we have foreign key constraints if the child
table is deleted, then parent table can be deleted.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
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 is Restricted Mode of Instance Startup in Oracle?
What is the difference between oracle media recovery and crash recovery?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
1. What is PO rate variance gain and loss?
what are basic modules required to implement oracle application in any oraganisation?
what are the API of GL,PO,AP
Give two methods you could use to determine what DDL changes have been made.
What is auto invoicing? Explain : oracle accounts receivable
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
