Firebird 5.0 Language Reference

About The Firebird 5.0 Language Reference

Sql Language Structure

Data Types And Subtypes

Common Language Elements

Expressions

Literals (Constants)

String Literals

String Literals in Hexadecimal Notation

Alternative String Literals

Introducer Syntax for String Literals

Alternative String Literals

Introducer Syntax for String Literals

Introducer Syntax for String Literals

Number Literals

Hexadecimal Notation for Numbers

Boolean Literals

Datetime Literals

SQL Operators

Operator Precedence

Concatenation Operator

Arithmetic Operators

Comparison Operators

Logical Operators

Arithmetic Operators

Comparison Operators

Logical Operators

Comparison Operators

Logical Operators

Logical Operators

NEXT VALUE FOR

AT

Conditional Expressions

CASE

Simple

Searched

Searched

NULL

Expressions Returning

NULL

Subqueries

Correlated Subqueries

Scalar Results

Predicates

Conditions

Comparison Predicates

Other Comparison Predicates

BETWEEN

LIKE

Wildcards

Using the Examples using

STARTING WITH

CONTAINING

SIMILAR TO

Syntax: SQL Regular Expressions

Building Regular Expressions

Characters

Wildcards

Character Classes

Predefined Character Classes

Quantifiers

OR-ing Terms

Subexpressions

Escaping Special Characters

IS [NOT] DISTINCT FROM

Boolean

IS [NOT] NULL

LIKE

STARTING WITH

CONTAINING

SIMILAR TO

Syntax: SQL Regular Expressions

Building Regular Expressions

Characters

Wildcards

Character Classes

Predefined Character Classes

Quantifiers

OR-ing Terms

Subexpressions

Escaping Special Characters

IS [NOT] DISTINCT FROM

Boolean

IS [NOT] NULL

STARTING WITH

CONTAINING

SIMILAR TO

Syntax: SQL Regular Expressions

Building Regular Expressions

Characters

Wildcards

Character Classes

Predefined Character Classes

Quantifiers

OR-ing Terms

Subexpressions

Escaping Special Characters

IS [NOT] DISTINCT FROM

Boolean

IS [NOT] NULL

CONTAINING

SIMILAR TO

Syntax: SQL Regular Expressions

Building Regular Expressions

Characters

Wildcards

Character Classes

Predefined Character Classes

Quantifiers

OR-ing Terms

Subexpressions

Escaping Special Characters

IS [NOT] DISTINCT FROM

Boolean

IS [NOT] NULL

SIMILAR TO

IS [NOT] DISTINCT FROM

Boolean

IS [NOT] NULL

IS [NOT] DISTINCT FROM

Boolean

IS [NOT] NULL

Boolean

IS [NOT] NULL

IS [NOT] NULL

Existential Predicates

EXISTS

IN

SINGULAR

Quantified Subquery Predicates

ALL

ANY

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

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