Firebird 5.0 Language Reference

About The Firebird 5.0 Language Reference

Sql Language Structure

Data Types And Subtypes

Common Language Elements

Data Definition (Ddl) Statements

Database

Shadow

Domain

Table

Index

View

Trigger

Procedure

Function

External Function

Package

Package Body

Filter

Sequence

Exception

Collation

Character Set

Comments

Data Manipulation (Dml) Statements

Procedural SQL (PSQL) Statements

Elements of PSQL

DML Statements with Parameters

Transactions

Module Structure

The Module Header

The Module Body

The PSQL Module Body

isql Command

The External Module Body

Stored Procedures

Benefits of Stored Procedures

Types of Stored Procedures

Executable Procedures

Selectable Procedures

Creating a Stored Procedure

Modifying a Stored Procedure

Dropping a Stored Procedure

Stored Functions

Creating a Stored Function

Modifying a Stored Function

Dropping a Stored Function

PSQL Blocks

Packages

Benefits of Packages

Creating a Package

Modifying a Package

Dropping a Package

Triggers

Firing Order (Order of Execution)

DML Triggers

Trigger Options

OLD

Database Triggers

DDL Triggers

Semantics

The

Creating Triggers

Modifying Triggers

Dropping a Trigger

Writing the Body Code

Assignment Statements

Example using assignment statements

Management Statements in PSQL

Example of Management Statements in PSQL

DECLARE VARIABLE

Data Type for Variables

NOT NULL

CHARACTER SET

Initializing a Variable

Examples of various ways to declare local variables

DECLARE .. CURSOR

Cursor Idiosyncrasies

Examples Using Named Cursors

DECLARE FUNCTION

Examples of Sub-Functions

DECLARE PROCEDURE

Examples of Sub-Procedures

BEGIN …​ END

BEGIN …​ END

IF …​ THEN …​ ELSE

IF

WHILE …​ DO

WHILE …​ DO

BREAK

LEAVE

LEAVE

CONTINUE

CONTINUE

EXIT

SUSPEND

SUSPEND

EXECUTE STATEMENT

Parameterized Statements

Special Rules for Parameterized Statements

Examples of

Examples of

WITH {AUTONOMOUS | COMMON} TRANSACTION

WITH CALLER PRIVILEGES

ON EXTERNAL [DATA SOURCE]

Connection Pooling

Transaction Pooling

Exception Handling

Miscellaneous Notes

Transaction Pooling

Exception Handling

Miscellaneous Notes

Exception Handling

Miscellaneous Notes

Miscellaneous Notes

AS USER

Caveats with

FOR SELECT

The Undeclared Cursor

Examples using

FOR EXECUTE STATEMENT

FOR EXECUTE STATEMENT

OPEN

OPEN

FETCH

FETCH

CLOSE

CLOSE

IN AUTONOMOUS TRANSACTION

IN AUTONOMOUS TRANSACTION

POST_EVENT

POST_EVENT

RETURN

RETURN

Trapping and Handling Errors

System Exceptions

Custom Exceptions

EXCEPTION

WHEN …​ DO

Scope of a

Examples using

Built-In Scalar Functions

Aggregate Functions

Window (Analytical) Functions

System Packages

Context Variables

Transaction Control

Security

User Authentication

Sql Statements For User Management

Sql Privileges

Role

Statements For Granting Privileges

Statements For Revoking Privileges

Mapping Of Users To Objects

Database Encryption

Sql Security

Management Statements

Supplementary Information

Exception Codes And Messages

Reserved Words And Keywords

System Tables

Monitoring Tables

Security Tables

Plugin Tables

Character Sets And Collations

License Notice

Document History