PL/SQL Unit 1: Intro to PL/SQL

Functions

A program that computes and returns a value.

Procedure

A program that performs an action and does not have to return a value.

Exceptions

An error that occurs in the database or in a user's program during runtime.

Subprograms

Named PL/SQL blocks that are stored in the database and can be declared as procedures or functions.

PL/SQL

Oracle Corporations standard procedural language for relational databases which allows basic program logic and control flow to be combined with SQL statements.

Complier

Software that checks and translates programs written in high-level programming languages into binary code to execute.

Portability

The ability for PL/SQL programs to run anywhere an Oracle server runs.

Blocks

The basic unit of PL/SQL programs- also known as modules.

Anonymous PL/SQL Block

Unnamed blocks of code not stored in the database and do not exist after they are executed.