what is difference between inner join & nested query or
subqueries
What is store procedure?and how do u take the values from database and run in scripts?
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
How do you add a data file to a tablespace?
What is auto invoicing? Explain : oracle accounts receivable
Explain the difference between a data block, an extent and a segment.
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
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.
Explain the use of table functions.
Can we modify approve purchase order?if yes what is navigation?
8. Supporting AP, AR and GL?
What is $FLEX$ and $PROFILES$?
Give two examples of how you might determine the structure of the table DEPT.