Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
Answer Posted / suresh
Function must return one value
Procedure may or may not return one or more values.
Can call functions in Sql statements
we can't call a procedure in sql statements
Functions can not return images
procedure returns images
| Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
What is an Oracle database Full Backup?
Why more redos are generated when the oracle database is in begin backup mode?
Explain about party and customer in ar : oracle accounts receivable
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
1. What is PO rate variance gain and loss?
Explain the use of table functions.
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?
which one is currently in used software cmpanies.