plik


Creating a PL/SQL Block - 2 The interactions in this eCourse require Javascript to be enabled.   Creating a PL/SQL Block: Part 2 previous|next A PL/SQL program comprises one or more blocks. These blocks can be entirely separate or nested within another. Block Types There are three types of blocks that make up a PL/SQL program: Anonymous blocks: These are the unnamed PL/SQL blocks that are embedded within an application or are issued interactively. Procedures: These are the named PL/SQL blocks. These blocks accept inbound parameters but won't explicitly return any value. Functions: These are the named PL/SQL blocks. These blocks accept inbound parameters and will always return a value. The difference between a procedure and a function is that a function must return a value to the calling program.          

Wyszukiwarka