Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66329 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
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
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?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
Differentiate between transaction type and transaction source? : 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
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
How to clone the database using RMAN back
what is semphore explian it?
What is autocashrule set? : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
please send me oracle pl/sql exp resume. and also faqs...
Are These Dff's Flexible?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
Explain about party and customer in ar : oracle accounts receivable
