Truncate 1.Truncate Can be DDL Command. 2.it cannot be rollback. 3.we ca

what is the difference between TRUNCATE and DELETE command
in SQL

Question Posted / pravesh kumar

23 Answers
66316 Views
ICICI, Saama Tech, SkyTech, TCS, I also Faced
E-Mail Answers

Answer Posted / pravesh kumar

Truncate
1.Truncate Can be DDL Command.
2.it cannot be rollback.
3.we cann't use Where clause.
4.truncate=delete+commit so we cann't rollback.
5.truncate delete all record from the table.
6.truncate is a DDL command and cannot be rollbackand all
memory space is released back to server.
7.speed faster.
8.do not chcek constraint.
Delete
1.Delete Can be DML Command.
2.it can be rollback.
3.we can use Where clause.
4.delete=delete-- so we can be rollback.
5.delete delete record from the table.
6.truncate is a DDL command and can be rollback and all
memory space is not released back to server.
7.speed slow.
8. chcek constraint.

Is This Answer Correct ?

14 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1327

Could you please let me know the interfaces in OM / FA??

2249

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1190

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

2263

Can we modify approve purchase order?if yes what is navigation?

2002

What do you mean by hz_ in customer tables? : oracle accounts receivable

1204

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2465

Explain how to close periods in ar. : oracle accounts receivable

1303

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1036

Explain the process of recievables in oracle financials. : oracle accounts receivable

1151

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?

2403

what are basic modules required to implement oracle application in any oraganisation?

2197

What is an Oracle database Full Backup?

1125

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2491

types of receipts and detail desription about recipts and tables effected by receipts?

2068