Data Manipulation (DML) Statements | CTE Notes Example

Home
Paragraphs
Français
Search

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

External Function

Data Manipulation (DML) Statements

Characteristics of

Examples of FIRST/SKIP

Example using a derived table A more useful example

Example using a derived table A more useful example

Inner vs. Outer Joins

Qualified joins

Explicit-condition joins

Named columns joins

Named columns joins

Mixing Explicit and Implicit Joins

Mixing Explicit and Implicit Joins

A Note on Equality

Ambiguous field names in joins

Composite Plans

Sorting Direction

Collation Order

FOR UPDATE [OF]

How the engine deals with

Examples using explicit locking

Common Table Expressions (“

CTE Notes Example

INSERT … VALUES

INSERT … SELECT

INSERT … DEFAULT VALUES

RETURNING Example (DSQL)

UPDATE OR INSERT

EXECUTE PROCEDURE

“Executable” Stored Procedure Examples of

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

User Authentication

Sql Statements For User Management

Statements For Granting Privileges

Statements For Revoking Privileges

Mapping Of Users To Objects

Database Encryption

Management Statements

Supplementary Information

Exception Codes And Messages

Reserved Words And Keywords

Monitoring Tables

Security Tables

Character Sets And Collations

Document History

CommentsProcedural SQL (PSQL) Statements