what is the difference between TRUNCATE and DELETE command
in SQL

Answer Posted / guest

Truncate command cannot be rolled back while Delete can be

Is This Answer Correct ?    178 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1524


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

1818


i want to know about the javaBean.what is its purpose and how it can use in Forms.

1810


can u give guidance abt packages of plsql

1624


What are different types of transactions in ar? : oracle accounts receivable

712






Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

718


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

694


What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

725


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1674


How would you go about increasing the buffer cache hit ratio?

1923


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

1673


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1467


what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

624


i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

1824


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

1608