Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
- 1 Answers
- 2443 Views
- I also Faced
- E-Mail Answers
Answer Posted / Atendra Singh
FUNCTION and PROCEDURE are both database objects used for executing sets of SQL statements. However, they differ in a few key aspects:nn- A FUNCTION always returns a value, whereas a PROCEDURE does not return any value.n- Functions can be used as an expression within an SQL statement, while procedures cannot.nPACKAGE is a library containing one or more related functions and procedures. It allows for the grouping of multiple database objects into a single unit, improving organization and reusability.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
