Stored Procedures and Functions

The focus of this lesson is to describe the basic creation and maintenance of subprograms. All of the PL/SQL you have learned up to this point can be used in the context of such programs, but the examples will be simple demonstration programs that focus on the distinctive characteristics of Oracle functions and stored procedures.

Subprograms serve as independent programming units but can be coupled together to produce complex applications. In order for subprograms to be useful and to interact with people and programs they need to be able to receive data, process it and send back results.

Contact Us or call 1-877-932-8228