Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
Answer Posted / esakkiraja
One more diff between function and procedure
Functions can be used in sql query but procedure we can't
used in sql query
For eg:
tax is a function we can use like
select ename,tax(sal) from emp where ename='saki';
In this we can use.....
| Is This Answer Correct ? | 64 Yes | 6 No |
Post New Answer View All Answers
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
as a technical developer in oracle applications which type errors feced in your experience sofar
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.
A scenario for amount correction & how to use amount correction functionality in AP invoices
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Differentiate between transaction type and transaction source? : oracle accounts receivable
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
Give two methods you could use to determine what DDL changes have been made.
3. Steps in UAT?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
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?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
What is Tax Categories?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What is the mandatory setup in cyclecount ?