what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / amit
In Truncate only data are remove from table
where as in delete structure of table are delete.
| Is This Answer Correct ? | 3 Yes | 9 No |
Post New Answer View All Answers
A scenario for amount correction & how to use amount correction functionality in AP invoices
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
How would you determine what sessions are connected and what resources they are waiting for?
Can we modify approve purchase order?if yes what is navigation?
1. What is PO rate variance gain and loss?
Could you please let me know the interfaces in OM / FA??
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
Explain prerequisites and post activities of oracle database installation
Explain how to close periods in ar. : oracle accounts receivable
Explain the process of recievables in oracle financials. : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable