Firebird 4.0 Language Reference Dmitry Filippov, Alexander Karpeykin, Alexey Kovyazin, Dmitry Kuzmenko, Denis Simonov, Paul Vinkenoog, Dmitry Yemanov, Mark Rotteveel Version 2.10, 15 December 2023 The source of much copied reference material: Paul Vinkenoog Copyright © 2017-2023 Firebird Project and all contributing authors, under the Public Documentation License Version 1.0. Please refer to request with the necessary changes. Preface 1 Table of Contents 1. About the Firebird 4.0 Language Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Firebird 2.5 Language Reference Dmitry Filippov, Alexander Karpeykin, Alexey Kovyazin, Dmitry Kuzmenko, Denis Simonov, Paul Vinkenoog, Dmitry Yemanov Version 1.16, 15 December 2023 The source of much much copied reference material: Paul Vinkenoog Copyright © 2017-2023 Firebird Project and all contributing authors, under the Public Documentation License Version 1.0. Please refer to the License Notice topics concerning Firebird’s SQL language written by members of the Russian-speaking community of Firebird developers and users. In 2014, it culminated in a language reference manual, in Russian. At the instigation

Drawing UML with PlantUML PlantUML Language Reference Guide (Version 1.2021.2) PlantUML is a component that allows to quickly write : • Sequence diagram • Usecase diagram • Class diagram • Object (nwdiag) • Wireframe graphical interface • Archimate diagram • Specification and Description Language (SDL) • Ditaa diagram • Gantt diagram • MindMap diagram • Work Breakdown Structure diagram JLaTeXMath notation • Entity Relationship diagram Diagrams are defined using a simple and intuitive language. 1 SEQUENCE DIAGRAM 1 Sequence Diagram 1.1 Basic examples The sequence -> is used to draw a

Drawing UML with PlantUML PlantUML Language Reference Guide (Version 1.2019.6) PlantUML is a component that allows to quickly write : • Sequence diagram • Usecase diagram • Class diagram • Activity supported: • Wireframe graphical interface • Archimate diagram • Specification and Description Language (SDL) • Ditaa diagram • Gantt diagram • MindMap diagram • Work Breakdown Structure diagram Mathematic with AsciiMath or JLaTeXMath notation Diagrams are defined using a simple and intuitive language. 1 SEQUENCE DIAGRAM 1 Sequence Diagram 1.1 Basic examples The sequence -> is used to draw a

Drawing UML with PlantUML PlantUML Language Reference Guide (Version 1.2019.1) PlantUML is a component that allows to quickly write : • Sequence diagram • Usecase diagram • Class diagram • Activity Specification and Description Language (SDL) • Ditaa diagram • Gantt diagram • Mathematic with AsciiMath or JLaTeXMath notation Diagrams are defined using a simple and intuitive language. 1 SEQUENCE DIAGRAM Foo4 : To entity Foo1 -> Foo5 : To database Foo1 -> Foo6 : To collections @enduml PlantUML Language Reference Guide (1.2019.1) 1 / 147 1.2 Declaring participant 1 SEQUENCE DIAGRAM You can rename a participant

Drawing UML with PlantUML PlantUML Language Reference Guide (Version 1.2021.1) PlantUML is a component that allows to quickly write : • Sequence diagram • Usecase diagram • Class diagram • Object (nwdiag) • Wireframe graphical interface • Archimate diagram • Specification and Description Language (SDL) • Ditaa diagram • Gantt diagram • MindMap diagram • Work Breakdown Structure diagram JLaTeXMath notation • Entity Relationship diagram Diagrams are defined using a simple and intuitive language. 1 SEQUENCE DIAGRAM 1 Sequence Diagram 1.1 Basic examples The sequence -> is used to draw a

Drawing UML with PlantUML PlantUML Language Reference Guide (Version 1.2020.22) PlantUML is a component that allows to quickly write : • Sequence diagram • Usecase diagram • Class diagram • Activity JSON Data • Wireframe graphical interface • Archimate diagram • Specification and Description Language (SDL) • Ditaa diagram • Gantt diagram • MindMap diagram • Work Breakdown Structure diagram Mathematic with AsciiMath or JLaTeXMath notation Diagrams are defined using a simple and intuitive language. 1 SEQUENCE DIAGRAM 1 Sequence Diagram 1.1 Basic examples The sequence -> is used to draw a

Drawing UML with PlantUML PlantUML Language Reference Guide (Version 1.2019.2) PlantUML is a component that allows to quickly write : • Sequence diagram • Usecase diagram • Class diagram • Activity Specification and Description Language (SDL) • Ditaa diagram • Gantt diagram • Mathematic with AsciiMath or JLaTeXMath notation Diagrams are defined using a simple and intuitive language. 1 SEQUENCE DIAGRAM Foo4 : To entity Foo1 -> Foo5 : To database Foo1 -> Foo6 : To collections @enduml PlantUML Language Reference Guide (1.2019.2) 1 / 159 1.2 Declaring participant 1 SEQUENCE DIAGRAM You can rename a participant

Drawing UML with PlantUML PlantUML Language Reference Guide (Version 1.2021.2) PlantUML is a component that allows to quickly write : • Sequence diagram • Usecase diagram • Class diagram • Object (nwdiag) • Wireframe graphical interface • Archimate diagram • Specification and Description Language (SDL) • Ditaa diagram • Gantt diagram • MindMap diagram • Work Breakdown Structure diagram JLaTeXMath notation • Entity Relationship diagram Diagrams are defined using a simple and intuitive language. 1 SEQUENCE DIAGRAM 1 Sequence Diagram 1.1 Basic examples The sequence -> is used to draw a

слова; • Типы и подтипы данных; • Операторы DDL (Data Definition Language — язык создания данных); • Операторы DML (Data Manipulation Language — язык обращения с данными); • Операторы управления транзакциями; org документ доступен по адресу https://www.firebirdsql.org/ file/documentation/reference_manuals/firebird-language-reference-30-rus.pdf Кроме того, данный документ выложен в различных форматах на сайте (I <= 5) DO BEGIN SELECT LANGUAGE_REQ[:I] FROM JOB WHERE (JOB_CODE = :CODE) AND (JOB_GRADE = :GRADE) AND (JOB_COUNTRY = :CTY) AND (LANGUAGE_REQ IS NOT NULL)) INTO :LANGUAGES;