Lexical Elements of the SQL Language

Text in the SQL language is composed from lexical elements of various types: identifiers, reserved words, separators, literals and comments.

Literals are used for entering a fixed value into the SQL statement text. There are several types of literals:

literal ::= number | character_string | binary_string | date_and_time_notation

Characters that are present in SQL statements are interpreted according to the defined system language and charset for the database.

List of topics: