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
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
Explain prerequisites and post activities of oracle database installation
Differentiate between transaction type and transaction source? : oracle accounts receivable
What is the disk migration? what is the steps involved in oracle disk migration?
Difference between negative and positive adjustments : oracle accounts receivable
where the dff data will be stored
what is the link between suppliers and banks in ap module in oracle apps? And also query?
what are basic modules required to implement oracle application in any oraganisation?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
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.