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.
- 1 Answers
- 2302 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / Vishakha Dutt
To handle this requirement, you can create a custom API using Oracle's REST Data Services (ORS) or SQL Developer Data Provider (SDDP). The API should accept the flat file as input and process each record to update the database. If you are using SDDP, you can use its data manipulation language (DML) capabilities to perform database operations. A sample API name could be 'UpdateEmployeeStatusAPI'. You would need to implement the necessary logic to read the flat file, validate the records, and execute the SQL update statement using your chosen development environment.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is diff between pre insert,on insert,post insert triggers?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
whats the difference between join command and Cartesian product using example?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
Explain the payment term in ar. : oracle accounts receivable
What is Restricted Mode of Instance Startup in Oracle?
what is sql*loader parameters and where we will use it.
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
Oracle General 
