Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
- 10 Answers
- 50718 Views
- TCS, I also Faced
- E-Mail Answers
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
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
What is auto invoicing? : oracle accounts receivable
Give two methods you could use to determine what DDL changes have been made.
Explain the process of recievables in oracle financials. : oracle accounts receivable
How do you create a credit note against an invoice? : 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.
HOW TO SPOT AHIERARCHY?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
Are These Dff's Flexible?
A scenario for amount correction & how to use amount correction functionality in AP invoices
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
8. Supporting AP, AR and GL?
where the dff data will be stored
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
Is there any link between pr form(purchse requisition)and po form(purchase order)
