what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / dheeraj
Delete is DML Command ,Whereas Trucate is DDL command
Delete can be Rolled Back,Truncate cannot be rolled back,
Truncate is much faster then Delete
Delete will not released the memory space ,Memories would
be same if we use delete command the structure of the
table is still there
Trncate can be free the space in the meomory
Delete , use check constraints if exits then show error
Truncate don't use check constraint
Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
Is there any link between pr form(purchse requisition)and po form(purchase order)
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
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?
difference of using cursor for loop and open,fetch,close.which one is better
as a technical developer in oracle applications which type errors feced in your experience sofar
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
what is the link between suppliers and banks in ap module in oracle apps? And also query?
What is the sql query to find the employee who has Nth maximum salary?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
How would you determine who has added a row to a table?
A scenario for amount correction & how to use amount correction functionality in AP invoices
What is the difference between oracle media recovery and crash recovery?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
What is mrc and what is its use? : oracle accounts receivable