You have just compiled a PL/SQL package but got errors, how would you view the errors?
SQL> SHOW ERRORS
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
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.
What command would you use to encrypt a PLSQL application?
WRAP
SQL> SHOW ERRORS
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
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.
What command would you use to encrypt a PLSQL application?
WRAP
No comments:
Post a Comment