Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 65592 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / mkjmkumar
TRUNCATE
1. It is DDL.
2. Speed is faster
3. Do not Check Constraints.
4. Roll Back is not possible.
5. Can not use where clause
DELETE
1. It is not a DDL
2. Speed is slow
3. Check constraints, If Exists then shoe error.
4. We can rollback .
5. User Where Clause
| Is This Answer Correct ? | 78 Yes | 8 No |
Post New Answer View All Answers
what is the link between suppliers and banks in ap module in oracle apps? And also query?
Are These Dff's Flexible?
Difference between negative and positive adjustments : 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
please send me oracle pl/sql exp resume. and also faqs...
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
how to replace not in with not exist?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What is Tax Categories?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
what are the tools used for oracle 10g in real time.
key flexfield structure
Explain the process of recievables in oracle financials. : oracle accounts receivable
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
