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
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
A scenario for amount correction & how to use amount correction functionality in AP invoices
default triggers available for reports
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
as a technical developer in oracle applications which type errors feced in your experience sofar
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
where the dff data will be stored
What is auto invoicing? : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
Why more redos are generated when the oracle database is in begin backup mode?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What is mrc and what is its use? : oracle accounts receivable
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
types of receipts and detail desription about recipts and tables effected by receipts?