Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
- 10 Answers
- 50658 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / deepak
Note:- procedure may or may not return value.function must
return value
Procedure return one or more value & function return only
single value.
Pakages are groups of functions,procedures,sql blocks
goruped together in a single unit.
Package & packagebody are two different thngs. Variable
defined in packages are global & they can use in anywhere
in packagebody. Variable defined in packagebody have
limited scope. & they can used in defined limit only.
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
What is the disk migration? what is the steps involved in oracle disk migration?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
How would you go about increasing the buffer cache hit ratio?
what are basic modules required to implement oracle application in any oraganisation?
How would you determine what sessions are connected and what resources they are waiting for?
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
What do you mean by Oracle MEDIA RECOVERY?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What is Restricted Mode of Instance Startup in Oracle?
3. Steps in UAT?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
What is db_recovery_file_dest in oracle? When do you need to set this value?
can u give guidance abt packages of plsql
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
