Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
Answer Posted / subhasish dutta
If no write (i.e. insert,delete,update,merge) operation is
made in a function then that function can be used sql
query. if only read operation (i.e. Select) is used in a
function, that can be called from sql query.
| Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
What is autocashrule set? : oracle accounts receivable
which one is currently in used software cmpanies.
key flexfield structure
Could you please let me know the interfaces in OM / FA??
Can we modify approve purchase order?if yes what is navigation?
what is difference between inner join & nested query or subqueries
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
Explain prerequisites and post activities of oracle database installation
How to clone the database using RMAN back
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What is Restricted Mode of Instance Startup in Oracle?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
A scenario for amount correction & how to use amount correction functionality in AP invoices