Database Administrator (DBA) Question:

Download Job Interview Questions and Answers PDF

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

Answer:

A function and procedure are the same in that they are intended to be a collection of PL/SQL code that carries a single task. While a procedure does not have to return any values to the calling application, a function will return a single value. A package on the other hand is a collection of functions and procedures that are grouped together based on their commonality to a business function or application.

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
What command would you use to encrypt a PL/SQL application?Explain the use of table functions.