Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 65478 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
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
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
A scenario for amount correction & how to use amount correction functionality in AP invoices
What is the difference between conversions and interfaces? : oracle accounts receivable
3. Steps in UAT?
as a technical developer in oracle applications which type errors feced in your experience sofar
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.
What is the disk migration? what is the steps involved in oracle disk migration?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What is the sql query to find the employee who has Nth maximum salary?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
Where in the Oracle directory tree structure are audit traces placed?
What is the use of lockboxes? : oracle accounts receivable
Differentiate between transaction type and transaction source? : oracle accounts receivable
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.
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
