Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.

Answer Posted / karunakar remala

Procedure and functions contains scope with in package
only..but coming to it contains scope out side of the
package also.i.e we can access package elements from out
side of the package also.

Is This Answer Correct ?    11 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where the dff data will be stored

2030


Explain prerequisites and post activities of oracle database installation

1914


What is the mandatory setup in cyclecount ?

2460


difference of using cursor for loop and open,fetch,close.which one is better

1508


TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3229


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1026


how to write customizations in po

1402


Differentiate between transaction type and transaction source? : oracle accounts receivable

889


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

2050


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

878


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1858


types of receipts and detail desription about recipts and tables effected by receipts?

1864


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

1787


1. What is PO rate variance gain and loss?

2552


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7210