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

SELECT

FIRST

Characteristics of

Examples of FIRST/SKIP

The

Examples of

The

Selecting

Examples

Selecting

Selecting

LATERAL

Example using a derived table A more useful example

Example using a derived table A more useful example

Selecting

Joins

Inner vs. Outer Joins

Qualified joins

Explicit-condition joins

Named columns joins

Named columns joins

Natural joins

Cross joins

Implicit Joins

Mixing Explicit and Implicit Joins

Mixing Explicit and Implicit Joins

A Note on Equality

Ambiguous field names in joins

Joins with

The

Examples

The

HAVING

The

The

Simple Plans

Composite Plans

UNION

ORDER BY

Sorting Direction

Collation Order

NULLs Position

Ordering

Examples of

ROWS

Replacing of

Mixing

ROWS

Examples of

OFFSET

Examples of

FOR UPDATE [OF]

WITH LOCK

Usage with a

How the engine deals with

Caveats using

Examples using explicit locking

OPTIMIZE FOR

INTO

Common Table Expressions (“

Recursive CTEs

CTE Notes Example

Recursive CTEs

Full

INSERT

INSERT …​ VALUES

INSERT …​ SELECT

INSERT …​ DEFAULT VALUES

OVERRIDING

The

Inserting into

UPDATE

Using an alias

The

The

The

The

The

The

RETURNING Example (DSQL)

Updating

UPDATE OR INSERT

The

The

Example of

DELETE

Aliases

WHERE

PLAN

ORDER BY

SKIP LOCKED

RETURNING

MERGE

The

The

Examples of

EXECUTE PROCEDURE

“Executable” Stored Procedure Examples of

EXECUTE BLOCK

Examples

Input and output parameters

Statement Terminators

Procedural Sql (Psql) Statements

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