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

Built-in Scalar Functions

Context Functions

RDB$GET_CONTEXT()

The

The

Examples

RDB$SET_CONTEXT()

Mathematical Functions

ABS()

ACOS()

ACOSH()

ASIN()

ASINH()

ATAN()

ATAN2()

ATANH()

CEIL()

COS()

COSH()

COT()

EXP()

FLOOR()

LN()

LOG()

LOG10()

MOD()

PI()

POWER()

RAND()

ROUND()

ROUND

SIGN()

SIN()

SINH()

SQRT()

TAN()

TANH()

TRUNC()

String and Binary Functions

ASCII_CHAR()

ASCII_VAL()

BASE64_DECODE()

Example of

BASE64_ENCODE()

Example of

BIT_LENGTH()

BIT_LENGTH

BLOB_APPEND()

BLOB_APPEND

CHAR_LENGTH()

CHAR_LENGTH

CRYPT_HASH()

Examples of

HASH()

Examples of

HEX_DECODE()

Example of

HEX_ENCODE()

Example of

LEFT()

LOWER()

LOWER

LPAD()

LPAD

OCTET_LENGTH()

OCTET_LENGTH

OVERLAY()

OVERLAY

POSITION()

POSITION

REPLACE()

REPLACE

REVERSE()

REVERSE

RIGHT()

RPAD()

RPAD

SUBSTRING()

Positional

Regular Expression

TRIM()

TRIM

UNICODE_CHAR()

UNICODE_VAL()

UPPER()

UPPER

Date and Time Functions

DATEADD()

Examples of

DATEDIFF()

DATEDIFF

EXTRACT()

Returned Data Types and Ranges

MILLISECOND

WEEK

WEEK

FIRST_DAY()

Examples of

LAST_DAY()

Examples of

Type Casting Functions

CAST()

“Shorthand” Syntax

Allowed Type Conversions

Casting Parameters

Casting to a Domain or its Type

Casting to a Column's Type

Cast Examples

Bitwise Functions

BIN_AND()

BIN_NOT()

BIN_OR()

BIN_SHL()

BIN_SHR()

BIN_XOR()

UUID Functions

CHAR_TO_UUID()

CHAR_TO_UUID

GEN_UUID()

GEN_UUID

UUID_TO_CHAR()

UUID_TO_CHAR

Functions for Sequences (Generators)

GEN_ID()

GEN_ID

Conditional Functions

COALESCE()

COALESCE

DECODE()

DECODE

IIF()

IIF

MAXVALUE()

MAXVALUE

MINVALUE()

MINVALUE

NULLIF()

NULLIF

Special Functions for

COMPARE_DECFLOAT()

NORMALIZE_DECFLOAT()

Examples of

QUANTIZE()

Examples of

TOTALORDER()

Cryptographic Functions

DECRYPT()

DECRYPT

ENCRYPT()

ENCRYPT

RSA_DECRYPT()

RSA_DECRYPT

RSA_ENCRYPT()

RSA_ENCRYPT

RSA_PRIVATE()

RSA_PRIVATE

RSA_PUBLIC()

RSA_PUBLIC

RSA_SIGN_HASH()

RSA_SIGN_HASH

RSA_VERIFY_HASH()

RSA_VERIFY_HASH

Other Functions

MAKE_DBKEY()

Examples of

RDB$ERROR()

Example of RDB$ERROR

RDB$GET_TRANSACTION_CN()

RDB$GET_TRANSACTION_CN

RDB$ROLE_IN_USE()

RDB$ROLE_IN_USE

RDB$SYSTEM_PRIVILEGE()

RDB$SYSTEM_PRIVILEGE

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