Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 65432 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
QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
Explain prerequisites and post activities of oracle database installation
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
What are different types of receipt reversals ? Explain them : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What is an Oracle database Full Backup?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
