can we use lexical perameter in oracle plsql if yes how
No Answer is Posted For this Question
Be the First to Post Answer
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
which one is currently in used software cmpanies.
What is the sql query to find the employee who has Nth maximum salary?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
what is semphore explian it?
What command would you use to encrypt a PL/SQL application?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
What is the difference between the SQL*Loader and IMPORT utilities?
Differentiate between standard remittance and bills receivable remittance : 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 view would you use to look at the size of a data file?