what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 58288 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / anup.wilson
hii every one ... i want to say that delite is --dml and
truncate is ddl ..nxt thing about roll back ..through
delete we roll back untill unless we are not COMMIT IT..
IF WE COMMIT AFTER DELETE ..WE CANT ROLL BACK IT
...
| Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
what are basic modules required to implement oracle application in any oraganisation?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
Differentiate between transaction type and transaction source? : oracle accounts receivable
What is db_recovery_file_dest in oracle? When do you need to set this value?
as a technical developer in oracle applications which type errors feced in your experience sofar
Explain the use of table functions.
How would you go about increasing the buffer cache hit ratio?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
HOW TO SPOT AHIERARCHY?
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 are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
Explain the payment term in ar. : oracle accounts receivable
