What is store procedure?and how do u take the values from
database and run in scripts?
Answer Posted / hari
it is a stored pl/sql block that is used to perform an
action.And it may or may not return values .
parameters are in,out,in out.
we will take the values from parameters.
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What is supporting issues GL AP and AR?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Explain how to close periods in ar. : oracle accounts receivable
Explain the process of recievables in oracle financials. : 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.
which one is currently in used software cmpanies.
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
where the dff data will be stored
Explain the use of table functions.
HOW TO SPOT AHIERARCHY?
Give two methods you could use to determine what DDL changes have been made.
3. Steps in UAT?