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.