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
3. Steps in UAT?
Explain how to close periods in ar. : oracle accounts receivable
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
Differentiate between transaction type and transaction source? : oracle accounts receivable
What is chargeback invoice? How do we create it? : oracle accounts receivable
What is Restricted Mode of Instance Startup in Oracle?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
which one is currently in used software cmpanies.
where the dff data will be stored
Explain the payment term in ar. : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What are different types of transactions in ar? : oracle accounts receivable
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable