what is the difference between TRUNCATE and DELETE command
in SQL

Answer Posted / rams

TRUNCATE:
1. it is a DML command.
2. by using truncate we can remove data in a table
permanantly.
3. we cant roll back the data.
4. it is faster than delete command.

DELETE:
1. it is a DDL command
2. by using delete command we can remove data in a table,
but we can rollback the data.
4. it is slower than the truncate command.

Is This Answer Correct ?    13 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

1626


as a technical developer in oracle applications which type errors feced in your experience sofar

1777


How do you create a credit note against an invoice? : oracle accounts receivable

650


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

1920


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

1993






What view would you use to determine free space in a tablespace?

1783


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

731


What is db_recovery_file_dest in oracle? When do you need to set this value?

653


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1654


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1835


1. What is PO rate variance gain and loss?

2316


Are These Dff's Flexible?

739


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

644


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1618


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1501