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
i want to know about the javaBean.what is its purpose and how it can use in Forms.
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
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
default triggers available for reports
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
What are different types of transactions in ar? : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
please send me oracle pl/sql exp resume. and also faqs...
what is semphore explian it?
as a technical developer in oracle applications which type errors feced in your experience sofar
How many segment are present in Oracle Manufacturing
Are These Dff's Flexible?