what is the difference between TRUNCATE and DELETE command
in SQL

Answer Posted / praveena

Truncate is the ddl command we can't get back, the delete
command we can delete the table not the fields.
In the turncate we can not get fields also these the main
differance.,
i think so

Is This Answer Correct ?    13 Yes 43 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to write customizations in po

1201


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

1960


default triggers available for reports

1761


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

1850


can we use lexical perameter in oracle plsql if yes how

1827






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

1551


what are the API of GL,PO,AP

1779


Difference between transaction type and transaction sources. : oracle accounts receivable

583


What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3345


How many segment are present in Oracle Manufacturing

1812


3. Steps in UAT?

1951


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

1911


hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

1778


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

1913


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

644