what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 58196 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / kotravel. b
TRUNCATE DELETE
1 cannot be 1 can ba RB
roll back
2 faster than 2 slower than truncate
delete
3 it releses the stroge 3 it does not releses the stroge
sp sp
spaces
| Is This Answer Correct ? | 75 Yes | 8 No |
Post New Answer View All Answers
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What is mrc and what is its use? : oracle accounts receivable
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.
Could you please let me know the interfaces in OM / FA??
what is semphore explian it?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What view would you use to determine free space in a tablespace?
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
How do you create a credit note against an invoice? : oracle accounts receivable
How to clone the database using RMAN back
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
