Reggae From Around The World. Catch the Vibes!
Introduction to PL/SQL Packages and Package Bodies. A PL/SQL package stores related items as a single logical entity. A package is composed of two distinct pieces: The package specification defines what is contained in the package; it is analogous to a header file in a language such as C++. The specification defines all public items. The specification is the published interface to a package. We can divide the PL/SQL procedure into two sections: header and body. PL/SQL Procedure Header The section before IS keyword is called procedure header or procedure signature. The elements in the procedure's header are described as follows: schema: the optional name of the schema that the procedure belongs to. The default is the current user. Create stored procedures and functions. Use PL/SQL packages to group and contain related constructs. Create triggers to solve business challenges. Use some of the Oracle supplied PL/SQL packages to generate screen output and file output. Create custom packages for applications. Write Dynamic SQL code for applications. •A stored procedureis a PL/SQL block that Oracle stores in the database and can be called by name from an application. May or may not return a value. •Functionsalways return a single valueto the caller; procedures do not returnvalues to the caller. •Packagesare groups of procedures and functions. PL/SQL Blocks You can also execute a procedure from the Oracle SQL Developer using the following steps: 1) Right-click the procedure name and choose Run… menu item 2) Enter a value for the in_customer_id parameter and click OK button. 3) The following shows the result Connecting to the database Local. Elisha Lloyd
Check out the Reggae Nation playlist on Surf Roots TV! Featuring the hottest music videos from Jamaica and worldwide. Download the Surf Roots TV App on Roku, Amazon Fire, Apple TV, iPhone & Android
© 2024 Created by Reggae Nation. Powered by
You need to be a member of Reggae Nation to add comments!
Join Reggae Nation