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
Could you please let me know the interfaces in OM / FA??
which one is currently in used software cmpanies.
What is supporting issues GL AP and AR?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
can u give guidance abt packages of plsql
What is Tax Categories?
what are basic modules required to implement oracle application in any oraganisation?
What is auto invoicing? Explain : oracle accounts receivable
types of receipts and detail desription about recipts and tables effected by receipts?
please send me oracle pl/sql exp resume. and also faqs...
What do you mean by Oracle MEDIA RECOVERY?
What are different types of transactions in ar? : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?