Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66557 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 Cross Validation & Adi?
Explain about party and customer in ar : oracle accounts receivable
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
1. What is PO rate variance gain and loss?
Where in the Oracle directory tree structure are audit traces placed?
8. Supporting AP, AR and GL?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
What is an Oracle database Partial Backup?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
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.
types of receipts and detail desription about recipts and tables effected by receipts?
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 use of lockboxes? Steps for lock box : oracle accounts receivable
