Entries categorized as Procedure
Difference between a FUNCTION, PROCEDURE and PACKAGE
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. Read More...
Procedure
What is a Procedure ? Â A Procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve a specific problem or perform a set of related tasks. Read More...
Procedure,functions and Packages
What are Procedure,functions and Packages? Â Procedures and functions consist of set of PL/SQL statements that are grouped together as a unit to solve a specific problem or perform set of related tasks. Procedures do not Return values while Functions return one One Value Packages :: Packages Provide a method of encapsulating and storing related Read More...