direct_SQL_statement:

::= directly_executable_statement ';'

no referencesdirectly_executable_statement:

directly_executable_statement

::= direct_SQL_data_statement

| SQL_schema_statement

| SQL_transaction_statement

| SQL_connection_statement

| SQL_session_statement

| '!! See the Syntax Rules.'

referenced by: direct_SQL_statement direct_SQL_data_statement:

direct_SQL_data_statement

::= delete_statement__searched

| direct_select_statement__multiple_rows

| insert_statement

| update_statement__searched

| truncate_table_statement

| merge_statement

| temporary_table_declaration

referenced by: directly_executable_statement SQL_terminal_character:

SQL_terminal_character

::= SQL_language_character

no referencesSQL_language_character:

SQL_language_character

::= simple_Latin_letter

| digit

| SQL_special_character

referenced by: SQL_terminal_character simple_Latin_letter:

simple_Latin_letter

::= simple_Latin_upper_case_letter

| simple_Latin_lower_case_letter

referenced by: SQL_language_character SQL_language_identifier_part SQL_language_identifier_start simple_Latin_upper_case_letter:

simple_Latin_upper_case_letter

::= 'A'

| 'B'

| 'C'

| 'D'

| 'E'

| 'F'

| 'G'

| 'H'

| 'I'

| 'J'

| 'K'

| 'L'

| 'M'

| 'N'

| 'O'

| 'P'

| 'Q'

| 'R'

| 'S'

| 'T'

| 'U'

| 'V'

| 'W'

| 'X'

| 'Y'

| 'Z'

referenced by: SQLSTATE_char simple_Latin_letter simple_Latin_lower_case_letter:

simple_Latin_lower_case_letter

::= 'a'

| 'b'

| 'c'

| 'd'

| 'e'

| 'f'

| 'g'

| 'h'

| 'i'

| 'j'

| 'k'

| 'l'

| 'm'

| 'n'

| 'o'

| 'p'

| 'q'

| 'r'

| 's'

| 't'

| 'u'

| 'v'

| 'w'

| 'x'

| 'y'

| 'z'

referenced by: simple_Latin_letter digit:

digit ::= '0'

| '1'

| '2'

| '3'

| '4'

| '5'

| '6'

| '7'

| '8'

| '9'

referenced by: SQLSTATE_char SQL_language_character SQL_language_identifier_part hexit large_object_length_token unsigned_integer SQL_special_character:

SQL_special_character

::= '!! See the Syntax Rules.'

| '"'

| '%'

| '&'

| "'"

| '('

| ')'

| '*'

| '+'

| ','

| '-'

| '.'

| '/'

| ':'

| ';'

| '<'

| '='

| '>'

| '?'

| '['

| ']'

| '^'

| '_'

| '|'

| '{'

| '}'

| '$'

referenced by: SQL_language_character delimiter_token left_bracket_or_trigraph:

left_bracket_or_trigraph

::= '['

| '??('

referenced by: array_element_reference array_type array_value_constructor_by_enumeration empty_specification multiset_value_constructor_by_enumeration target_array_element_specification update_target right_bracket_or_trigraph:

right_bracket_or_trigraph

::= ']'

| '??)'

token ::= nondelimiter_token

| delimiter_token

no referencesnondelimiter_token:

nondelimiter_token

::= regular_identifier

| key_word

| unsigned_numeric_literal

| national_character_string_literal

| binary_string_literal

| large_object_length_token

| Unicode_delimited_identifier

| Unicode_character_string_literal

| SQL_language_identifier

referenced by: token regular_identifier:

regular_identifier

::= identifier_body

referenced by: actual_identifier nondelimiter_token identifier_body:

identifier_body

::= identifier_start identifier_part*

referenced by: regular_identifier identifier_part:

identifier_part

::= identifier_start

| identifier_extend

referenced by: identifier_body large_object_length_token:

large_object_length_token

::= digit+ multiplier

referenced by: large_object_length nondelimiter_token multiplier:

multiplier

::= 'K'

| 'M'

| 'G'

| 'T'

| 'P'

referenced by: large_object_length large_object_length_token delimited_identifier:

delimited_identifier

::= '"' delimited_identifier_body '"'

referenced by: actual_identifier delimiter_token delimited_identifier_body:

delimited_identifier_body

::= delimited_identifier_part+

referenced by: delimited_identifier delimited_identifier_part:

delimited_identifier_part

::= '!! See the Syntax Rules.'

| '""'

referenced by: Unicode_identifier_part delimited_identifier_body Unicode_delimited_identifier:

Unicode_delimited_identifier

::= U '&' '"' Unicode_delimiter_body '"' Unicode_escape_specifier

referenced by: actual_identifier nondelimiter_token Unicode_escape_specifier:

Unicode_escape_specifier

::= ( 'UESCAPE' "'" '!! See the Syntax Rules.' "'" )?

referenced by: Unicode_character_string_literal Unicode_delimited_identifier Unicode_delimiter_body:

Unicode_delimiter_body

::= Unicode_identifier_part+

referenced by: Unicode_delimited_identifier Unicode_identifier_part:

Unicode_identifier_part

::= delimited_identifier_part

| Unicode_escape_value

referenced by: Unicode_delimiter_body Unicode_escape_value:

Unicode_escape_value

::= Unicode_4_digit_escape_value

| Unicode_6_digit_escape_value

| Unicode_character_escape_value

referenced by: Unicode_identifier_part Unicode_representation Unicode_4_digit_escape_value:

Unicode_4_digit_escape_value

::= '!! See the Syntax Rules.' hexit hexit hexit hexit

referenced by: Unicode_escape_value Unicode_6_digit_escape_value:

Unicode_6_digit_escape_value

::= '!! See the Syntax Rules.' '+' hexit hexit hexit hexit hexit hexit

referenced by: Unicode_escape_value Unicode_character_escape_value:

Unicode_character_escape_value

::= '!! See the Syntax Rules.' '!! See the Syntax Rules.'

referenced by: Unicode_escape_value delimiter_token:

delimiter_token

::= character_string_literal

| date_string

| time_string

| timestamp_string

| interval_string

| delimited_identifier

| SQL_special_character

| '<>'

| '>='

| '<='

| '||'

| '->'

| '??('

| '??)'

| '::'

| '..'

| '=>'

| '{-'

| '-}'

referenced by: token separator:

separator

::= ( comment | white_space )+

referenced by: Unicode_character_string_literal binary_string_literal bracketed_comment_contents character_string_literal national_character_string_literal comment:

comment ::= simple_comment

| bracketed_comment

referenced by: separator simple_comment:

simple_comment

::= simple_comment_introducer comment_character* newline

referenced by: comment simple_comment_introducer:

simple_comment_introducer

::= '-' '-'

referenced by: simple_comment bracketed_comment:

bracketed_comment

::= bracketed_comment_introducer bracketed_comment_contents bracketed_comment_terminator

referenced by: comment bracketed_comment_introducer:

bracketed_comment_introducer

::=

referenced by: bracketed_comment bracketed_comment_contents:

bracketed_comment_contents

::= ( comment_character | separator )+ '!! See the Syntax Rules.'

referenced by: bracketed_comment comment_character:

comment_character

::= nonquote_character

| "'"

referenced by: bracketed_comment_contents simple_comment key_word:

key_word ::= reserved_word

| non_reserved_word

referenced by: nondelimiter_token non_reserved_word:

non_reserved_word

::= 'A*'

| 'ABSOLUTE*'

| 'ACTION*'

| 'ADA*'

| 'ADD*'

| 'ADMIN*'

| 'AFTER*'

| 'ALWAYS*'

| 'ASC*'

| 'ASSERTION*'

| 'ASSIGNMENT*'

| 'ATTRIBUTE*'

| 'ATTRIBUTES*'

| 'BEFORE*'

| 'BERNOULLI*'

| 'BREADTH*'

| 'C*'

| 'CASCADE*'

| 'CATALOG*'

| 'CATALOG_NAME*'

| 'CHAIN*'

| 'CHAINING*'

| 'CHARACTER_SET_CATALOG*'

| 'CHARACTER_SET_NAME*'

| 'CHARACTER_SET_SCHEMA*'

| 'CHARACTERISTICS*'

| 'CHARACTERS*'

| 'CLASS_ORIGIN*'

| 'COBOL*'

| 'COLLATION*'

| 'COLLATION_CATALOG*'

| 'COLLATION_NAME*'

| 'COLLATION_SCHEMA*'

| 'COLUMNS*'

| 'COLUMN_NAME*'

| 'COMMAND_FUNCTION*'

| 'COMMAND_FUNCTION_CODE*'

| 'COMMITTED*'

| 'CONDITIONAL*'

| 'CONDITION_NUMBER*'

| 'CONNECTION*'

| 'CONNECTION_NAME*'

| 'CONSTRAINT_CATALOG*'

| 'CONSTRAINT_NAME*'

| 'CONSTRAINT_SCHEMA*'

| 'CONSTRAINTS*'

| 'CONSTRUCTOR*'

| 'CONTINUE*'

| 'CURSOR_NAME*'

| 'DATA*'

| 'DATETIME_INTERVAL_CODE*'

| 'DATETIME_INTERVAL_PRECISION*'

| 'DEFAULTS*'

| 'DEFERRABLE*'

| 'DEFERRED*'

| 'DEFINED*'

| 'DEFINER*'

| 'DEGREE*'

| 'DEPTH*'

| 'DERIVED*'

| 'DESC*'

| 'DESCRIBE_CATALOG*'

| 'DESCRIBE_NAME*'

| 'DESCRIBE_PROCEDURE_SPECIFIC_CATALOG*'

| 'DESCRIBE_PROCEDURE_SPECIFIC_NAME*'

| 'DESCRIBE_PROCEDURE_SPECIFIC_SCHEMA*'

| 'DESCRIBE_SCHEMA*'

| 'DESCRIPTOR*'

| 'DIAGNOSTICS*'

| 'DISPATCH*'

| 'DOMAIN*'

| 'DYNAMIC_FUNCTION*'

| 'DYNAMIC_FUNCTION_CODE*'

| 'ENCODING*'

| 'ENFORCED*'

| 'ERROR*'

| 'EXCLUDE*'

| 'EXCLUDING*'

| 'EXPRESSION*'

| 'FINAL*'

| 'FINISH*'

| 'FINISH_CATALOG*'

| 'FINISH_NAME*'

| 'FINISH_PROCEDURE_SPECIFIC_CATALOG*'

| 'FINISH_PROCEDURE_SPECIFIC_NAME*'

| 'FINISH_PROCEDURE_SPECIFIC_SCHEMA*'

| 'FINISH_SCHEMA*'

| 'FIRST*'

| 'FLAG*'

| 'FOLLOWING*'

| 'FORMAT*'

| 'FORTRAN*'

| 'FOUND*'

| 'FULFILL*'

| 'FULFILL_CATALOG*'

| 'FULFILL_NAME*'

| 'FULFILL_PROCEDURE_SPECIFIC_CATALOG*'

| 'FULFILL_PROCEDURE_SPECIFIC_NAME*'

| 'FULFILL_PROCEDURE_SPECIFIC_SCHEMA*'

| 'FULFILL_SCHEMA*'

| 'G*'

| 'GENERAL*'

| 'GENERATED*'

| 'GO*'

| 'GOTO*'

| 'GRANTED*'

| 'HAS_PASS_THROUGH_COLUMNS*'

| 'HAS_PASS_THRU_COLS*'

| 'HIERARCHY*'

| 'IGNORE*'

| 'IMMEDIATE*'

| 'IMMEDIATELY*'

| 'IMPLEMENTATION*'

| 'INCLUDING*'

| 'INCREMENT*'

| 'INITIALLY*'

| 'INPUT*'

| 'INSTANCE*'

| 'INSTANTIABLE*'

| 'INSTEAD*'

| 'INVOKER*'

| 'ISOLATION*'

| 'IS_PRUNABLE*'

| 'JSON*'

| 'K*'

| 'KEEP*'

| 'KEY*'

| 'KEYS*'

| 'KEY_MEMBER*'

| 'KEY_TYPE*'

| 'LAST*'

| 'LENGTH*'

| 'LEVEL*'

| 'LOCATOR*'

| 'M*'

| 'MAP*'

| 'MATCHED*'

| 'MAXVALUE*'

| 'MESSAGE_LENGTH*'

| 'MESSAGE_OCTET_LENGTH*'

| 'MESSAGE_TEXT*'

| 'MINVALUE*'

| 'MORE*'

| 'MUMPS*'

| 'NAME*'

| 'NAMES*'

| 'NESTED*'

| 'NESTING*'

| 'NEXT*'

| 'NFC*'

| 'NFD*'

| 'NFKC*'

| 'NFKD*'

| 'NORMALIZED*'

| 'NULLABLE*'

| 'NULLS*'

| 'NUMBER*'

| 'OBJECT*'

| 'OCTETS*'

| 'OPTION*'

| 'OPTIONS*'

| 'ORDERING*'

| 'ORDINALITY*'

| 'OTHERS*'

| 'OUTPUT*'

| 'OVERFLOW*'

| 'OVERRIDING*'

| 'P*'

| 'PAD*'

| 'PARAMETER_MODE*'

| 'PARAMETER_NAME*'

| 'PARAMETER_ORDINAL_POSITION*'

| 'PARAMETER_SPECIFIC_CATALOG*'

| 'PARAMETER_SPECIFIC_NAME*'

| 'PARAMETER_SPECIFIC_SCHEMA*'

| 'PARTIAL*'

| 'PASCAL*'

| 'PASS*'

| 'PASSING*'

| 'PAST*'

| 'PATH*'

| 'PLACING*'

| 'PLAN*'

| 'PLI*'

| 'PRECEDING*'

| 'PRESERVE*'

| 'PRIOR*'

| 'PRIVATE*'

| 'PRIVATE_PARAMETERS*'

| 'PRIVATE_PARAMS_S*'

| 'PRIVILEGES*'

| 'PRUNE*'

| 'PUBLIC*'

| 'QUOTES*'

| 'READ*'

| 'RELATIVE*'

| 'REPEATABLE*'

| 'RESPECT*'

| 'RESTART*'

| 'RESTRICT*'

| 'RETURNED_CARDINALITY*'

| 'RETURNED_LENGTH*'

| 'RETURNED_OCTET_LENGTH*'

| 'RETURNED_SQLSTATE*'

| 'RETURNING*'

| 'RETURNS_ONLY_PASS_THROUGH*'

| 'RET_ONLY_PASS_THRU*'

| 'ROLE*'

| 'ROUTINE*'

| 'ROUTINE_CATALOG*'

| 'ROUTINE_NAME*'

| 'ROUTINE_SCHEMA*'

| 'ROW_COUNT*'

| 'SCALAR*'

| 'SCALE*'

| 'SCHEMA*'

| 'SCHEMA_NAME*'

| 'SCOPE_CATALOG*'

| 'SCOPE_NAME*'

| 'SCOPE_SCHEMA*'

| 'SECTION*'

| 'SECURITY*'

| 'SELF*'

| 'SEQUENCE*'

| 'SERIALIZABLE*'

| 'SERVER_NAME*'

| 'SESSION*'

| 'SETS*'

| 'SIMPLE*'

| 'SIZE*'

| 'SOURCE*'

| 'SPACE*'

| 'SPECIFIC_NAME*'

| 'START_CATALOG*'

| 'START_NAME*'

| 'START_PROCEDURE_SPECIFIC_CATALOG*'

| 'START_PROCEDURE_SPECIFIC_NAME*'

| 'START_PROCEDURE_SPECIFIC_SCHEMA*'

| 'START_SCHEMA*'

| 'STATE*'

| 'STATEMENT*'

| 'STRING*'

| 'STRUCTURE*'

| 'STYLE*'

| 'SUBCLASS_ORIGIN*'

| 'T*'

| 'TABLE_NAME*'

| 'TABLE_SEMANTICS*'

| 'TEMPORARY*'

| 'THROUGH*'

| 'TIES*'

| 'TOP_LEVEL_COUNT*'

| 'TRANSACTION*'

| 'TRANSACTION_ACTIVE*'

| 'TRANSACTIONS_COMMITTED*'

| 'TRANSACTIONS_ROLLED_BACK*'

| 'TRANSFORM*'

| 'TRANSFORMS*'

| 'TRIGGER_CATALOG*'

| 'TRIGGER_NAME*'

| 'TRIGGER_SCHEMA*'

| 'TYPE*'

| 'UNBOUNDED*'

| 'UNCOMMITTED*'

| 'UNCONDITIONAL*'

| 'UNDER*'

| 'UNNAMED*'

| 'USAGE*'

| 'USER_DEFINED_TYPE_CATALOG*'

| 'USER_DEFINED_TYPE_CODE*'

| 'USER_DEFINED_TYPE_NAME*'

| 'USER_DEFINED_TYPE_SCHEMA*'

| 'UTF16*'

| 'UTF32*'

| 'UTF8*'

| 'VIEW*'

| 'WORK*'

| 'WRAPPER*'

| 'WRITE*'

| 'ZONE*'

referenced by: key_word reserved_word:

reserved_word

::= 'ABS'

| 'ACOS'

| 'ALL'

| 'ALLOCATE'

| 'ALTER'

| 'AND'

| 'ANY'

| 'ARE'

| 'ARRAY'

| 'ARRAY_AGG'

| 'ARRAY_MAX_CARDINALITY'

| 'AS'

| 'ASENSITIVE'

| 'ASIN'

| 'ASYMMETRIC'

| 'AT'

| 'ATAN'

| 'ATOMIC'

| 'AUTHORIZATION'

| 'AVG'

| 'BEGIN'

| 'BEGIN_FRAME'

| 'BEGIN_PARTITION'

| 'BETWEEN'

| 'BIGINT'

| 'BINARY'

| 'BLOB'

| 'BOOLEAN'

| 'BOTH'

| 'BY'

| 'CALL'

| 'CALLED'

| 'CARDINALITY'

| 'CASCADED'

| 'CASE'

| 'CAST'

| 'CEIL'

| 'CEILING'

| 'CHAR'

| 'CHAR_LENGTH'

| 'CHARACTER'

| 'CHARACTER_LENGTH'

| 'CHECK'

| 'CLASSIFIER'

| 'CLOB'

| 'CLOSE'

| 'COALESCE'

| 'COLLATE'

| 'COLLECT'

| 'COLUMN'

| 'COMMIT'

| 'CONDITION'

| 'CONNECT'

| 'CONSTRAINT'

| 'CONTAINS'

| 'CONVERT'

| 'COPY'

| 'CORR'

| 'CORRESPONDING'

| 'COS'

| 'COSH'

| 'COUNT'

| 'COVAR_POP'

| 'COVAR_SAMP'

| 'CREATE'

| 'CROSS'

| 'CUBE'

| 'CUME_DIST'

| 'CURRENT'

| 'CURRENT_CATALOG'

| 'CURRENT_DATE'

| 'CURRENT_DEFAULT_TRANSFORM_GROUP'

| CURRENT_PATH

| CURRENT_ROLE

| 'CURRENT_ROW'

| 'CURRENT_SCHEMA'

| 'CURRENT_TIME'

| 'CURRENT_TIMESTAMP'

| CURRENT_PATH

| CURRENT_ROLE

| 'CURRENT_TRANSFORM_GROUP_FOR_TYPE'

| 'CURRENT_USER'

| 'CURSOR'

| 'CYCLE'

| 'DATE'

| 'DAY'

| 'DEALLOCATE'

| 'DEC'

| 'DECIMAL'

| 'DECFLOAT'

| 'DECLARE'

| 'DEFAULT'

| 'DEFINE'

| 'DELETE'

| 'DENSE_RANK'

| 'DEREF'

| 'DESCRIBE'

| 'DETERMINISTIC'

| 'DISCONNECT'

| 'DISTINCT'

| 'DOUBLE'

| 'DROP'

| 'DYNAMIC'

| 'EACH'

| 'ELEMENT'

| 'ELSE'

| 'EMPTY'

| 'END'

| 'END_FRAME'

| 'END_PARTITION'

| 'END-EXEC'

| 'EQUALS'

| 'ESCAPE'

| 'EVERY'

| 'EXCEPT'

| 'EXEC'

| 'EXECUTE'

| 'EXISTS'

| 'EXP'

| 'EXTERNAL'

| 'EXTRACT'

| 'FALSE'

| 'FETCH'

| 'FILTER'

| 'FIRST_VALUE'

| 'FLOAT'

| 'FLOOR'

| 'FOR'

| 'FOREIGN'

| 'FRAME_ROW'

| 'FREE'

| 'FROM'

| 'FULL'

| 'FUNCTION'

| 'FUSION'

| 'GET'

| 'GLOBAL'

| 'GRANT'

| 'GROUP'

| 'GROUPING'

| 'GROUPS'

| 'HAVING'

| 'HOLD'

| 'HOUR'

| 'IDENTITY'

| 'IN'

| 'INDICATOR'

| 'INITIAL'

| 'INNER'

| 'INOUT'

| 'INSENSITIVE'

| 'INSERT'

| 'INT'

| 'INTEGER'

| 'INTERSECT'

| 'INTERSECTION'

| 'INTERVAL'

| 'INTO'

| 'IS'

| 'JOIN'

| 'JSON_ARRAY'

| 'JSON_ARRAYAGG'

| 'JSON_EXISTS'

| 'JSON_OBJECT'

| 'JSON_OBJECTAGG'

| 'JSON_QUERY'

| 'JSON_TABLE'

| 'JSON_TABLE_PRIMITIVE'

| 'JSON_VALUE'

| 'LAG'

| 'LANGUAGE'

| 'LARGE'

| 'LAST_VALUE'

| 'LATERAL'

| 'LEAD'

| 'LEADING'

| 'LEFT'

| 'LIKE'

| 'LIKE_REGEX'

| 'LISTAGG'

| 'LN'

| 'LOCAL'

| 'LOCALTIME'

| 'LOCALTIMESTAMP'

| 'LOG'

| 'LOG10'

| 'LOWER'

| 'MATCH'

| 'MATCH_NUMBER'

| 'MATCH_RECOGNIZE'

| 'MATCHES'

| 'MAX'

| 'MEMBER'

| 'MERGE'

| 'METHOD'

| 'MIN'

| 'MINUTE'

| 'MOD'

| 'MODIFIES'

| 'MODULE'

| 'MONTH'

| 'MULTISET'

| 'NATIONAL'

| 'NATURAL'

| 'NCHAR'

| 'NCLOB'

| 'NEW'

| 'NO'

| 'NONE'

| 'NORMALIZE'

| 'NOT'

| 'NTH_VALUE'

| 'NTILE'

| 'NULL'

| 'NULLIF'

| 'NUMERIC'

| 'OCTET_LENGTH'

| 'OCCURRENCES_REGEX'

| 'OF'

| 'OFFSET'

| 'OLD'

| 'OMIT'

| 'ON'

| 'ONE'

| 'ONLY'

| 'OPEN'

| 'OR'

| 'ORDER'

| 'OUT'

| 'OUTER'

| 'OVER'

| 'OVERLAPS'

| 'OVERLAY'

| 'PARAMETER'

| 'PARTITION'

| 'PATTERN'

| 'PER'

| 'PERCENT'

| 'PERCENT_RANK'

| 'PERCENTILE_CONT'

| 'PERCENTILE_DISC'

| 'PERIOD'

| 'PORTION'

| 'POSITION'

| 'POSITION_REGEX'

| 'POWER'

| 'PRECEDES'

| 'PRECISION'

| 'PREPARE'

| 'PRIMARY'

| 'PROCEDURE'

| 'PTF'

| 'RANGE'

| 'RANK'

| 'READS'

| 'REAL'

| 'RECURSIVE'

| 'REF'

| 'REFERENCES'

| 'REFERENCING'

| 'REGR_AVGX'

| 'REGR_AVGY'

| 'REGR_COUNT'

| 'REGR_INTERCEPT'

| 'REGR_R2'

| 'REGR_SLOPE'

| 'REGR_SXX'

| 'REGR_SXY'

| 'REGR_SYY'

| 'RELEASE'

| 'RESULT'

| 'RETURN'

| 'RETURNS'

| 'REVOKE'

| 'RIGHT'

| 'ROLLBACK'

| 'ROLLUP'

| 'ROW'

| 'ROW_NUMBER'

| 'ROWS'

| 'RUNNING'

| 'SAVEPOINT'

| 'SCOPE'

| 'SCROLL'

| 'SEARCH'

| 'SECOND'

| 'SEEK'

| 'SELECT'

| 'SENSITIVE'

| 'SESSION_USER'

| 'SET'

| 'SHOW'

| 'SIMILAR'

| 'SIN'

| 'SINH'

| 'SKIP'

| 'SMALLINT'

| 'SOME'

| 'SPECIFIC'

| 'SPECIFICTYPE'

| 'SQL'

| 'SQLEXCEPTION'

| 'SQLSTATE'

| 'SQLWARNING'

| 'SQRT'

| 'START'

| 'STATIC'

| 'STDDEV_POP'

| 'STDDEV_SAMP'

| 'SUBMULTISET'

| 'SUBSET'

| 'SUBSTRING'

| 'SUBSTRING_REGEX'

| 'SUCCEEDS'

| 'SUM'

| 'SYMMETRIC'

| 'SYSTEM'

| 'SYSTEM_TIME'

| 'SYSTEM_USER'

| 'TABLE'

| 'TABLESAMPLE'

| 'TAN'

| 'TANH'

| 'THEN'

| 'TIME'

| 'TIMESTAMP'

| 'TIMEZONE_HOUR'

| 'TIMEZONE_MINUTE'

| 'TO'

| 'TRAILING'

| 'TRANSLATE'

| 'TRANSLATE_REGEX'

| 'TRANSLATION'

| 'TREAT'

| 'TRIGGER'

| 'TRIM'

| 'TRIM_ARRAY'

| 'TRUE'

| 'TRUNCATE'

| 'UESCAPE'

| 'UNION'

| 'UNIQUE'

| 'UNKNOWN'

| 'UNNEST'

| 'UPDATE'

| 'UPPER'

| 'USER'

| 'USING'

| 'VALUE'

| 'VALUES'

| 'VALUE_OF'

| 'VAR_POP'

| 'VAR_SAMP'

| 'VARBINARY'

| 'VARCHAR'

| 'VARYING'

| 'VERSIONING'

| 'WHEN'

| 'WHENEVER'

| 'WHERE'

| 'WIDTH_BUCKET'

| 'WINDOW'

| 'WITH'

| 'WITHIN'

| 'WITHOUT'

| 'YEAR'

referenced by: key_word literal:

literal ::= signed_numeric_literal

| general_literal

referenced by: default_option simple_value_specification value_specification unsigned_literal:

unsigned_literal

::= unsigned_numeric_literal

| general_literal

referenced by: unsigned_value_specification general_literal:

general_literal

::= character_string_literal

| national_character_string_literal

| Unicode_character_string_literal

| binary_string_literal

| datetime_literal

| interval_literal

| boolean_literal

referenced by: literal unsigned_literal character_string_literal:

character_string_literal

::= ( '_' character_set_specification )? "'" character_representation* "'" ( separator "'" character_representation* "'" )*

referenced by: JSON_path_specification cast_template delimiter_token external_routine_name general_literal listagg_separator listagg_truncation_filler character_representation:

character_representation

::= nonquote_character

| quote_symbol

referenced by: Ada_initial_value COBOL_variable_definition C_initial_value PL_I_variable_definition Unicode_representation character_string_literal national_character_string_literal quote_symbol:

quote_symbol

::= "'" "'"

referenced by: character_representation national_character_string_literal:

national_character_string_literal

::= 'N' "'" character_representation* "'" ( separator "'" character_representation* "'" )*

referenced by: general_literal nondelimiter_token Unicode_character_string_literal:

Unicode_character_string_literal

::= ( '_' character_set_specification )? 'U' '&' "'" Unicode_representation* "'" ( separator "'" Unicode_representation* "'" )* Unicode_escape_specifier

referenced by: general_literal nondelimiter_token Unicode_representation:

Unicode_representation

::= character_representation

| Unicode_escape_value

referenced by: Unicode_character_string_literal binary_string_literal:

binary_string_literal

::= 'X' "'" '!! See the Syntax Rules.'* ( hexit '!! See the Syntax Rules.'* hexit '!! See the Syntax Rules.'* )* "'" ( separator "'" '!! See the Syntax Rules.'* ( hexit '!! See the Syntax Rules.'* hexit '!! See the Syntax Rules.'* )* "'" )*

referenced by: general_literal nondelimiter_token hexit:

hexit ::= digit

| 'A'

| 'B'

| 'C'

| 'D'

| 'E'

| 'F'

| 'a'

| 'b'

| 'c'

| 'd'

| 'e'

| 'f'

referenced by: Unicode_4_digit_escape_value Unicode_6_digit_escape_value binary_string_literal signed_numeric_literal:

signed_numeric_literal

::= sign? unsigned_numeric_literal

referenced by: literal sequence_generator_increment sequence_generator_max_value sequence_generator_min_value sequence_generator_restart_value sequence_generator_start_value unsigned_numeric_literal:

unsigned_numeric_literal

::= exact_numeric_literal

| approximate_numeric_literal

referenced by: nondelimiter_token signed_numeric_literal unsigned_literal exact_numeric_literal:

exact_numeric_literal

::= unsigned_integer ( '.' unsigned_integer? )?

| '.' unsigned_integer

referenced by: mantissa offset unsigned_numeric_literal sign:

sign ::= '+'

| '-'

referenced by: factor interval_factor interval_literal signed_integer signed_numeric_literal time_zone_interval unquoted_interval_string approximate_numeric_literal:

approximate_numeric_literal

::= mantissa 'E' exponent

referenced by: unsigned_numeric_literal mantissa:

mantissa ::= exact_numeric_literal

referenced by: approximate_numeric_literal exponent:

exponent ::= signed_integer

referenced by: approximate_numeric_literal signed_integer:

signed_integer

::= sign? unsigned_integer

referenced by: exponent unsigned_integer:

unsigned_integer

::= digit+

referenced by: datetime_value exact_numeric_literal goto_target high_value interval_fractional_seconds_precision interval_leading_field_precision large_object_length length low_value maximum_cardinality maximum_returned_result_sets precision row_pattern_quantifier scale seconds_fraction seconds_integer_value signed_integer time_fractional_seconds_precision datetime_literal:

datetime_literal

::= date_literal

| time_literal

| timestamp_literal

referenced by: general_literal date_literal:

date_literal

::= 'DATE' date_string

referenced by: datetime_literal time_literal:

time_literal

::= 'TIME' time_string

referenced by: datetime_literal timestamp_literal:

timestamp_literal

::= 'TIMESTAMP' timestamp_string

referenced by: datetime_literal date_string:

date_string

::= "'" unquoted_date_string "'"

referenced by: date_literal delimiter_token time_string:

time_string

::= "'" unquoted_time_string "'"

referenced by: delimiter_token time_literal timestamp_string:

timestamp_string

::= "'" unquoted_timestamp_string "'"

referenced by: delimiter_token timestamp_literal time_zone_interval:

time_zone_interval

::= sign hours_value ':' minutes_value

referenced by: unquoted_time_string date_value:

date_value

::= years_value '-' months_value '-' days_value

referenced by: unquoted_date_string time_value:

time_value

::= hours_value ':' minutes_value ':' seconds_value

referenced by: unquoted_time_string interval_literal:

interval_literal

::= 'INTERVAL' sign? interval_string interval_qualifier

referenced by: general_literal interval_string:

interval_string

::= "'" unquoted_interval_string "'"

referenced by: delimiter_token interval_literal unquoted_date_string:

unquoted_date_string

::= date_value

referenced by: date_string unquoted_timestamp_string unquoted_time_string:

unquoted_time_string

::= time_value time_zone_interval?

referenced by: time_string unquoted_timestamp_string unquoted_timestamp_string:

unquoted_timestamp_string

::= unquoted_date_string '!! See the Syntax Rules.' unquoted_time_string

referenced by: timestamp_string unquoted_interval_string:

unquoted_interval_string

::= sign? ( year_month_literal | day_time_literal )

referenced by: interval_string year_month_literal:

year_month_literal

::= years_value ( '-' months_value )?

| months_value

referenced by: unquoted_interval_string day_time_literal:

day_time_literal

::= day_time_interval

| time_interval

referenced by: unquoted_interval_string day_time_interval:

day_time_interval

::= days_value ( '!! See the Syntax Rules.' hours_value ( ':' minutes_value ( ':' seconds_value )? )? )?

referenced by: day_time_literal time_interval:

time_interval

::= hours_value ( ':' minutes_value ( ':' seconds_value )? )?

| minutes_value ( ':' seconds_value )?

| seconds_value

referenced by: day_time_literal years_value:

years_value

::= datetime_value

referenced by: date_value year_month_literal months_value:

months_value

::= datetime_value

referenced by: date_value year_month_literal days_value:

days_value

::= datetime_value

referenced by: date_value day_time_interval hours_value:

hours_value

::= datetime_value

referenced by: day_time_interval time_interval time_value time_zone_interval minutes_value:

minutes_value

::= datetime_value

referenced by: day_time_interval time_interval time_value time_zone_interval seconds_value:

seconds_value

::= seconds_integer_value ( '.' seconds_fraction? )?

referenced by: day_time_interval time_interval time_value seconds_integer_value:

seconds_integer_value

::= unsigned_integer

referenced by: seconds_value seconds_fraction:

seconds_fraction

::= unsigned_integer

referenced by: seconds_value datetime_value:

datetime_value

::= unsigned_integer

referenced by: days_value hours_value minutes_value months_value years_value boolean_literal:

boolean_literal

::= 'TRUE'

| 'FALSE'

| 'UNKNOWN'

referenced by: general_literal identifier:

identifier

::= actual_identifier

referenced by: JSON_argument JSON_table_path_name SQL_client_module_name SQL_parameter_name application_time_period_name asterisked_identifier attribute_name cast_to_distinct_identifier cast_to_ref_identifier cast_to_source_identifier cast_to_type_identifier catalog_name column_name correlation_name external_routine_name field_name group_name host_parameter_name identifier_chain measure_name method_name non_extended_descriptor_name procedure_name qualified_identifier query_name regular_character_set_identifier role_name savepoint_name statement_name transition_table_name unqualified_schema_name user_identifier window_name actual_identifier:

actual_identifier

::= regular_identifier

| delimited_identifier

| Unicode_delimited_identifier

referenced by: identifier SQL_language_identifier:

SQL_language_identifier

::= SQL_language_identifier_start SQL_language_identifier_part*

referenced by: character_set_name nondelimiter_token SQL_language_identifier_start:

SQL_language_identifier_start

::= simple_Latin_letter

referenced by: SQL_language_identifier SQL_language_identifier_part:

SQL_language_identifier_part

::= simple_Latin_letter

| digit

| '_'

referenced by: SQL_language_identifier authorization_identifier:

authorization_identifier

::= role_name

| user_identifier

referenced by: grantee module_authorization_identifier schema_authorization_identifier table_name:

table_name

::= local_or_schema_qualified_name

referenced by: alter_table_statement drop_table_statement drop_view_statement insertion_target like_clause object_name range_variable referenced_table_and_columns scope_clause subview_clause supertable_name table_definition table_or_query_name target_table temporary_table_declaration trigger_definition view_definition domain_name:

domain_name

::= schema_qualified_name

referenced by: alter_domain_statement cast_target data_type_or_domain_name domain_definition drop_domain_statement object_name schema_name:

schema_name

::= ( catalog_name '.' )? unqualified_schema_name

referenced by: character_set_name drop_schema_statement embedded_authorization_clause local_or_schema_qualifier module_authorization_clause routine_name schema_name_clause schema_name_list schema_qualified_name specific_method_name user_defined_type_name unqualified_schema_name:

unqualified_schema_name

::= identifier

referenced by: schema_name catalog_name:

catalog_name

::= identifier

referenced by: schema_name schema_qualified_name:

schema_qualified_name

::= ( schema_name '.' )? qualified_identifier

referenced by: collation_name constraint_name domain_name schema_qualified_routine_name sequence_generator_name specific_name transcoding_name transliteration_name trigger_name local_or_schema_qualified_name:

local_or_schema_qualified_name

::= ( local_or_schema_qualifier '.' )? qualified_identifier

referenced by: table_name local_or_schema_qualifier:

local_or_schema_qualifier

::= schema_name

| 'MODULE'

referenced by: local_or_schema_qualified_name qualified_identifier:

qualified_identifier

::= identifier

referenced by: attribute_or_method_reference column_reference local_or_schema_qualified_name local_qualified_name routine_name schema_qualified_name specific_method_name user_defined_type_name column_name:

column_name

::= identifier

referenced by: JSON_table_formatted_column_definition JSON_table_ordinality_column_definition JSON_table_primitive_chaining_column JSON_table_regular_column_definition alter_column_definition as_clause column_definition column_name_list column_options column_reference cycle_column cycle_mark_column descriptor_column_specification drop_column_definition object_column path_column period_begin_column_name period_end_column_name self_referencing_column_name sequence_column table_function_column_list_element view_column_option correlation_name:

correlation_name

::= identifier

referenced by: correlation_or_recognition delete_statement__positioned delete_statement__searched join_correlation_name merge_correlation_name new_transition_variable_name old_transition_variable_name range_variable row_pattern_input_name row_pattern_output_name row_pattern_variable_name table_argument_correlation_name table_primary update_statement__positioned update_statement__searched query_name:

query_name

::= identifier

referenced by: range_variable table_or_query_name with_list_element SQL_client_module_name:

SQL_client_module_name

::= identifier

referenced by: module_name_clause procedure_name:

procedure_name

::= identifier

referenced by: externally_invoked_procedure schema_qualified_routine_name:

schema_qualified_routine_name

::= schema_qualified_name

referenced by: SQL_invoked_procedure function_specification member_name_alternatives method_name:

method_name

::= identifier

referenced by: direct_invocation generalized_invocation member_name_alternatives method_reference method_specification_designator mutated_set_clause partial_method_specification specific_method_specification_designator static_method_invocation specific_name:

specific_name

::= schema_qualified_name

referenced by: routine_characteristic specific_routine_designator state_category cursor_name:

cursor_name

::= local_qualified_name

referenced by: allocate_received_cursor_statement close_statement conventional_dynamic_cursor_name declare_cursor delete_statement__positioned described_object dynamic_declare_cursor fetch_statement open_statement preparable_dynamic_cursor_name update_statement__positioned local_qualified_name:

local_qualified_name

::= ( 'MODULE' '.' )? qualified_identifier

referenced by: cursor_name host_parameter_name:

host_parameter_name

::= ':' identifier

referenced by: host_parameter_declaration host_parameter_specification indicator_parameter locator_reference simple_target_specification simple_value_specification SQL_parameter_name:

SQL_parameter_name

::= identifier

referenced by: SQL_parameter_declaration named_argument_specification constraint_name:

constraint_name

::= schema_qualified_name

referenced by: SQL_condition alter_table_constraint_definition assertion_definition constraint_name_definition constraint_name_list drop_assertion_statement drop_domain_constraint_definition drop_table_constraint_definition external_routine_name:

external_routine_name

::= identifier

| character_string_literal

referenced by: alter_routine_characteristic external_body_reference trigger_name:

trigger_name

::= schema_qualified_name

referenced by: drop_trigger_statement trigger_definition collation_name:

collation_name

::= schema_qualified_name

referenced by: collate_clause collation_definition drop_collation_statement existing_collation_name module_collation_specification object_name character_set_name:

character_set_name

::= ( schema_name '.' )? SQL_language_identifier

referenced by: character_set_definition drop_character_set_statement implementation_defined_character_set_name object_name standard_character_set_name user_defined_character_set_name transliteration_name:

transliteration_name

::= schema_qualified_name

referenced by: character_transliteration drop_transliteration_statement existing_transliteration_name object_name transliteration_definition transcoding_name:

transcoding_name

::= schema_qualified_name

referenced by: transcoding schema_resolved_user_defined_type_name:

schema_resolved_user_defined_type_name

::= user_defined_type_name

referenced by: alter_transform_statement alter_type_statement drop_data_type_statement drop_transform_statement drop_user_defined_ordering_statement method_specification_designator object_name specific_routine_designator transform_definition user_defined_ordering_definition user_defined_type_body user_defined_type_name:

user_defined_type_name

::= ( schema_name '.' )? qualified_identifier

referenced by: path_resolved_user_defined_type_name schema_resolved_user_defined_type_name attribute_name:

attribute_name

::= identifier

referenced by: attribute_definition dereference_operation drop_attribute_definition list_of_attributes field_name:

field_name

::= identifier

referenced by: field_definition field_reference savepoint_name:

savepoint_name

::= identifier

referenced by: savepoint_specifier sequence_generator_name:

sequence_generator_name

::= schema_qualified_name

referenced by: alter_sequence_generator_statement drop_sequence_generator_statement next_value_expression object_name sequence_generator_definition role_name:

role_name

::= identifier

referenced by: authorization_identifier drop_role_statement role_definition role_granted role_revoked user_identifier:

user_identifier

::= identifier

referenced by: authorization_identifier connection_name:

connection_name

::= simple_value_specification

referenced by: connection_object connection_target SQL_server_name:

SQL_server_name

::= simple_value_specification

referenced by: connection_target connection_user_name:

connection_user_name

::= simple_value_specification

referenced by: connection_target SQL_statement_name:

SQL_statement_name

::= statement_name

| extended_statement_name

referenced by: deallocate_prepared_statement describe_input_statement described_object execute_statement prepare_statement statement_name:

statement_name

::= identifier

referenced by: SQL_statement_name dynamic_declare_cursor extended_statement_name:

extended_statement_name

::= scope_option? simple_value_specification

referenced by: SQL_statement_name allocate_extended_dynamic_cursor_statement dynamic_cursor_name:

dynamic_cursor_name

::= conventional_dynamic_cursor_name

| PTF_cursor_name

referenced by: dynamic_fetch_statement conventional_dynamic_cursor_name:

conventional_dynamic_cursor_name

::= cursor_name

| extended_cursor_name

referenced by: dynamic_close_statement dynamic_cursor_name dynamic_delete_statement__positioned dynamic_open_statement dynamic_update_statement__positioned extended_cursor_name:

extended_cursor_name

::= scope_option? simple_value_specification

referenced by: allocate_extended_dynamic_cursor_statement conventional_dynamic_cursor_name PTF_cursor_name:

PTF_cursor_name

::= 'PTF' simple_value_specification

referenced by: dynamic_cursor_name descriptor_name:

descriptor_name

::= conventional_descriptor_name

| PTF_descriptor_name

referenced by: get_descriptor_statement into_descriptor set_descriptor_statement source_descriptor_name using_descriptor conventional_descriptor_name:

conventional_descriptor_name

::= non_extended_descriptor_name

| extended_descriptor_name

referenced by: allocate_descriptor_statement deallocate_descriptor_statement descriptor_name non_extended_descriptor_name:

non_extended_descriptor_name

::= identifier

referenced by: conventional_descriptor_name extended_descriptor_name:

extended_descriptor_name

::= scope_option? simple_value_specification

referenced by: conventional_descriptor_name scope_option:

scope_option

::= 'GLOBAL'

| 'LOCAL'

referenced by: extended_cursor_name extended_descriptor_name extended_statement_name preparable_dynamic_cursor_name PTF_descriptor_name:

PTF_descriptor_name

::= 'PTF' simple_value_specification

referenced by: descriptor_name pipe_row_statement target_descriptor_name window_name:

window_name

::= identifier

referenced by: existing_window_name new_window_name window_name_or_specification row_pattern_variable_name:

row_pattern_variable_name

::= correlation_name

referenced by: classifier_function row_pattern_count_function row_pattern_definition_variable_name row_pattern_primary_variable_name row_pattern_skip_to_variable_name row_pattern_subset_item_variable_name row_pattern_subset_rhs_variable_name measure_name:

measure_name

::= identifier

referenced by: row_pattern_measure_definition window_row_pattern_measure data_type:

data_type

::= predefined_type

| row_type

| path_resolved_user_defined_type_name

| reference_type

| collection_type

referenced by: JSON_output_clause JSON_returning_clause JSON_table_formatted_column_definition JSON_table_regular_column_definition alter_column_data_type_clause array_type attribute_definition cast_target data_type_list data_type_or_domain_name descriptor_column_specification field_definition generalized_invocation host_parameter_data_type multiset_type parameter_type result_cast_from_type returns_data_type sequence_generator_data_type_option source_data_type table_function_column_list_element target_data_type predefined_type:

predefined_type

::= ( character_string_type ( 'CHARACTER' 'SET' character_set_specification )? | national_character_string_type ) collate_clause?

| binary_string_type

| numeric_type

| 'BOOLEAN'

| datetime_type

| interval_type

referenced by: Ada_user_defined_type_variable COBOL_user_defined_type_variable C_user_defined_type_variable Fortran_user_defined_type_variable MUMPS_user_defined_type_variable PL_I_user_defined_type_variable Pascal_user_defined_type_variable data_type domain_definition representation user_defined_representation character_string_type:

character_string_type

::= ( 'CHARACTER' | 'CHAR' ) ( 'VARYING'? '(' character_length ')' )?

| 'VARCHAR' '(' character_length ')'

| character_large_object_type

referenced by: predefined_type character_large_object_type:

character_large_object_type

::= ( ( 'CHARACTER' | 'CHAR' ) 'LARGE' 'OBJECT*' | 'CLOB' ) ( '(' character_large_object_length ')' )?

referenced by: character_string_type national_character_string_type:

national_character_string_type

::= ( 'NATIONAL' ( 'CHARACTER' | 'CHAR' ) | 'NCHAR' ) ( 'VARYING'? '(' character_length ')' )?

| national_character_large_object_type

referenced by: predefined_type national_character_large_object_type:

national_character_large_object_type

::= ( ( 'NATIONAL' 'CHARACTER' | 'NCHAR' ) 'LARGE' 'OBJECT*' | 'NCLOB' ) ( '(' character_large_object_length ')' )?

referenced by: national_character_string_type binary_string_type:

binary_string_type

::= 'BINARY' ( 'VARYING'? '(' length ')' )?

| 'VARBINARY' '(' length ')'

| binary_large_object_string_type

referenced by: predefined_type binary_large_object_string_type:

binary_large_object_string_type

::= ( 'BINARY' 'LARGE' 'OBJECT*' | 'BLOB' ) ( '(' large_object_length ')' )?

referenced by: binary_string_type numeric_type:

numeric_type

::= exact_numeric_type

| approximate_numeric_type

| decimal_floating_point_type

referenced by: predefined_type exact_numeric_type:

exact_numeric_type

::= ( 'NUMERIC' | 'DECIMAL' | 'DEC' ) ( '(' precision ( ',' scale )? ')' )?

| 'SMALLINT'

| 'INTEGER'

| 'INT'

| 'BIGINT'

referenced by: numeric_type approximate_numeric_type:

approximate_numeric_type

::= 'FLOAT' ( '(' precision ')' )?

| 'REAL'

| 'DOUBLE' 'PRECISION'

referenced by: numeric_type decimal_floating_point_type:

decimal_floating_point_type

::= 'DECFLOAT' ( '(' precision ')' )?

referenced by: numeric_type length:

length ::= unsigned_integer

referenced by: Ada_BINARY_variable Ada_VARBINARY_variable COBOL_BINARY_variable COBOL_nines C_BINARY_variable C_VARBINARY_variable Fortran_BINARY_variable Fortran_VARBINARY_variable PL_I_BINARY_variable PL_I_VARBINARY_variable Pascal_BINARY_variable binary_string_type character_length character_length:

character_length

::= length char_length_units?

referenced by: Ada_qualified_type_specification Ada_unqualified_type_specification COBOL_character_type COBOL_national_character_type C_array_specification Fortran_type_specification MUMPS_length_specification PL_I_type_specification Pascal_type_specification character_string_type national_character_string_type normalize_function_result_length large_object_length:

large_object_length

::= unsigned_integer multiplier?

| large_object_length_token

referenced by: Ada_BLOB_variable COBOL_BLOB_variable C_BLOB_variable Fortran_BLOB_variable PL_I_BLOB_variable Pascal_BLOB_variable binary_large_object_string_type character_large_object_length character_large_object_length:

character_large_object_length

::= large_object_length char_length_units?

referenced by: Ada_CLOB_variable COBOL_CLOB_variable COBOL_NCLOB_variable C_CLOB_variable C_NCLOB_variable Fortran_CLOB_variable PL_I_CLOB_variable Pascal_CLOB_variable character_large_object_type national_character_large_object_type normalize_function_result_length char_length_units:

char_length_units

::= 'CHARACTERS*'

| 'OCTETS*'

referenced by: char_length_expression character_large_object_length character_length character_overlay_function character_position_expression character_substring_function regex_occurrences_function regex_position_expression regex_substring_function regex_transliteration precision:

precision

::= unsigned_integer

referenced by: MUMPS_type_specification PL_I_type_specification approximate_numeric_type decimal_floating_point_type exact_numeric_type scale:

scale ::= unsigned_integer

referenced by: MUMPS_type_specification PL_I_type_specification exact_numeric_type datetime_type:

datetime_type

::= 'DATE'

| ( 'TIME' ( '(' time_precision ')' )? | 'TIMESTAMP' ( '(' timestamp_precision ')' )? ) with_or_without_time_zone?

referenced by: predefined_type with_or_without_time_zone:

with_or_without_time_zone

::= ( 'WITH' | 'WITHOUT' ) 'TIME' 'ZONE*'

referenced by: datetime_type time_precision:

time_precision

::= time_fractional_seconds_precision

referenced by: current_local_time_value_function current_time_value_function datetime_type timestamp_precision:

timestamp_precision

::= time_fractional_seconds_precision

referenced by: current_local_timestamp_value_function current_timestamp_value_function datetime_type time_fractional_seconds_precision:

time_fractional_seconds_precision

::= unsigned_integer

referenced by: time_precision timestamp_precision interval_type:

interval_type

::= 'INTERVAL' interval_qualifier

referenced by: predefined_type row_type:

row_type ::= 'ROW' row_type_body

referenced by: data_type row_type_body:

row_type_body

::= '(' field_definition ( ',' field_definition )* ')'

referenced by: row_type reference_type:

reference_type

::= 'REF' '(' referenced_type ')' scope_clause?

referenced by: Ada_REF_variable COBOL_REF_variable C_REF_variable Fortran_REF_variable MUMPS_REF_variable PL_I_REF_variable Pascal_REF_variable data_type target_subtype scope_clause:

scope_clause

::= 'SCOPE' table_name

referenced by: add_column_scope_clause column_option_list reference_type view_column_option referenced_type:

referenced_type

::= path_resolved_user_defined_type_name

referenced by: reference_type path_resolved_user_defined_type_name:

path_resolved_user_defined_type_name

::= user_defined_type_name

referenced by: Ada_user_defined_type_locator_variable Ada_user_defined_type_variable COBOL_user_defined_type_locator_variable COBOL_user_defined_type_variable C_user_defined_type_locator_variable C_user_defined_type_variable Fortran_user_defined_type_locator_variable Fortran_user_defined_type_variable MUMPS_user_defined_type_locator_variable MUMPS_user_defined_type_variable PL_I_user_defined_type_locator_variable PL_I_user_defined_type_variable Pascal_user_defined_type_locator_variable Pascal_user_defined_type_variable data_type exclusive_user_defined_type_specification general_value_specification generalized_expression group_specification inclusive_user_defined_type_specification new_specification referenceable_view_specification referenced_type static_method_invocation supertype_name target_subtype transform_group_characteristic typed_table_clause collection_type:

collection_type

::= array_type

| multiset_type

referenced by: data_type representation array_type:

array_type

::= data_type 'ARRAY' ( left_bracket_or_trigraph maximum_cardinality right_bracket_or_trigraph )?

referenced by: Ada_array_locator_variable COBOL_array_locator_variable C_array_locator_variable Fortran_array_locator_variable MUMPS_array_locator_variable PL_I_array_locator_variable Pascal_array_locator_variable collection_type maximum_cardinality:

maximum_cardinality

::= unsigned_integer

referenced by: array_type multiset_type:

multiset_type

::= data_type 'MULTISET'

referenced by: Ada_multiset_locator_variable COBOL_multiset_locator_variable C_multiset_locator_variable Fortran_multiset_locator_variable MUMPS_multiset_locator_variable PL_I_multiset_locator_variable Pascal_multiset_locator_variable collection_type field_definition:

field_definition

::= field_name data_type

referenced by: row_type_body value_expression_primary:

value_expression_primary

::= parenthesized_value_expression

| nonparenthesized_value_expression_primary

referenced by: all_fields_reference array_primary attribute_or_method_reference binary_primary character_primary datetime_primary direct_invocation field_reference generalized_invocation interval_primary method_reference multiset_primary numeric_primary reference_value_expression user_defined_type_value_expression parenthesized_value_expression:

parenthesized_value_expression

::= '(' value_expression ')'

referenced by: value_expression_primary nonparenthesized_value_expression_primary:

nonparenthesized_value_expression_primary

::= unsigned_value_specification

| column_reference

| set_function_specification

| window_function

| nested_window_function

| scalar_subquery

| case_expression

| cast_specification

| field_reference

| subtype_treatment

| method_invocation

| static_method_invocation

| new_specification

| attribute_or_method_reference

| reference_resolution

| collection_value_constructor

| array_element_reference

| multiset_element_reference

| next_value_expression

| routine_invocation

| row_pattern_navigation_operation

| JSON_value_function

referenced by: boolean_predicand row_value_special_case value_expression_primary collection_value_constructor:

collection_value_constructor

::= array_value_constructor

| multiset_value_constructor

referenced by: nonparenthesized_value_expression_primary value_specification:

value_specification

::= literal

| general_value_specification

referenced by: SQL_path_characteristic catalog_name_characteristic character_set_name_characteristic collation_specification role_specification schema_name_characteristic set_session_user_identifier_statement transform_group_characteristic unsigned_value_specification:

unsigned_value_specification

::= unsigned_literal

| general_value_specification

referenced by: nonparenthesized_value_expression_primary window_frame_following window_frame_preceding general_value_specification:

general_value_specification

::= host_parameter_specification

| SQL_parameter_reference

| '?'

| embedded_variable_specification

| current_collation_specification

| 'CURRENT_CATALOG'

| 'CURRENT_DEFAULT_TRANSFORM_GROUP'

| CURRENT_PATH

| CURRENT_ROLE

| 'CURRENT_SCHEMA'

| 'CURRENT_TRANSFORM_GROUP_FOR_TYPE' path_resolved_user_defined_type_name

| 'CURRENT_USER'

| 'SESSION_USER'

| 'SYSTEM_USER'

| 'USER'

| 'VALUE'

referenced by: unsigned_value_specification using_argument value_specification simple_value_specification:

simple_value_specification

::= literal

| host_parameter_name

| SQL_parameter_reference

| embedded_variable_name

referenced by: PTF_cursor_name PTF_descriptor_name SQL_server_name SQL_statement_variable attributes_variable condition_number connection_name connection_user_name extended_cursor_name extended_descriptor_name extended_statement_name fetch_first_percentage fetch_first_row_count fetch_orientation item_number item_number_1 item_number_2 logical_offset nth_row number_of_conditions number_of_tiles occurrences offset_row_count physical_offset row_marker_offset simple_value_specification_1 simple_value_specification_2 target_array_element_specification update_target target_specification:

target_specification

::= host_parameter_specification

| SQL_parameter_reference

| column_reference

| target_array_element_specification

| '?'

| embedded_variable_specification

referenced by: SQL_argument fetch_target_list into_argument named_argument_SQL_argument select_target_list simple_target_specification:

simple_target_specification

::= host_parameter_name

| SQL_parameter_reference

| column_reference

| embedded_variable_name

referenced by: all_info_target condition_information_item simple_target_specification_1 simple_target_specification_2 statement_information_item host_parameter_specification:

host_parameter_specification

::= host_parameter_name indicator_parameter?

referenced by: general_value_specification target_specification embedded_variable_specification:

embedded_variable_specification

::= embedded_variable_name indicator_variable?

referenced by: general_value_specification target_specification indicator_variable:

indicator_variable

::= 'INDICATOR'? embedded_variable_name

referenced by: embedded_variable_specification indicator_parameter:

indicator_parameter

::= 'INDICATOR'? host_parameter_name

referenced by: host_parameter_specification target_array_element_specification:

target_array_element_specification

::= target_array_reference left_bracket_or_trigraph simple_value_specification right_bracket_or_trigraph

referenced by: target_specification target_array_reference:

target_array_reference

::= SQL_parameter_reference

| column_reference

referenced by: target_array_element_specification current_collation_specification:

current_collation_specification

::= 'COLLATION*' 'FOR' '(' string_value_expression ')'

referenced by: general_value_specification contextually_typed_value_specification:

contextually_typed_value_specification

::= implicitly_typed_value_specification

| 'DEFAULT'

referenced by: SQL_argument contextually_typed_row_value_constructor contextually_typed_row_value_constructor_element merge_insert_value_element named_argument_SQL_argument parameter_default update_source implicitly_typed_value_specification:

implicitly_typed_value_specification

::= 'NULL'

| empty_specification

referenced by: cast_operand contextually_typed_value_specification default_option empty_specification:

empty_specification

::= ( 'ARRAY' | 'MULTISET' ) left_bracket_or_trigraph right_bracket_or_trigraph

referenced by: implicitly_typed_value_specification identifier_chain:

identifier_chain

::= identifier ( '.' identifier )*

referenced by: basic_identifier_chain basic_identifier_chain:

basic_identifier_chain

::= identifier_chain

referenced by: SQL_parameter_reference column_reference period_reference column_reference:

column_reference

::= basic_identifier_chain

| 'MODULE' '.' qualified_identifier '.' column_name

referenced by: grouping_column_reference grouping_operation nonparenthesized_value_expression_primary partitioned_join_column_reference row_pattern_partition_column simple_target_specification table_argument_ordering_column table_argument_partitioning_list target_array_reference target_specification window_partition_column_reference SQL_parameter_reference:

SQL_parameter_reference

::= basic_identifier_chain

referenced by: general_value_specification simple_target_specification simple_value_specification target_array_reference target_specification set_function_specification:

set_function_specification

::= running_or_final? aggregate_function

| grouping_operation

referenced by: nonparenthesized_value_expression_primary running_or_final:

running_or_final

::= 'RUNNING'

| 'FINAL*'

referenced by: row_pattern_navigation__compound row_pattern_navigation__logical set_function_specification grouping_operation:

grouping_operation

::= 'GROUPING' '(' column_reference ( ',' column_reference )* ')'

referenced by: set_function_specification window_function:

window_function

::= window_function_type 'OVER' window_name_or_specification

referenced by: nonparenthesized_value_expression_primary window_function_type:

window_function_type

::= ( rank_function_type | 'ROW_NUMBER' ) '(' ')'

| aggregate_function

| ntile_function

| lead_or_lag_function

| first_or_last_value_function

| nth_value_function

| window_row_pattern_measure

referenced by: window_function rank_function_type:

rank_function_type

::= 'RANK'

| 'DENSE_RANK'

| 'PERCENT_RANK'

| 'CUME_DIST'

referenced by: hypothetical_set_function window_function_type ntile_function:

ntile_function

::= 'NTILE' '(' number_of_tiles ')'

referenced by: window_function_type number_of_tiles:

number_of_tiles

::= simple_value_specification

| '?'

referenced by: ntile_function lead_or_lag_function:

lead_or_lag_function

::= lead_or_lag '(' lead_or_lag_extent ( ',' offset ( ',' default_expression )? )? ')' null_treatment?

referenced by: window_function_type lead_or_lag:

lead_or_lag

::= 'LEAD'

| 'LAG'

referenced by: lead_or_lag_function lead_or_lag_extent:

lead_or_lag_extent

::= value_expression

referenced by: lead_or_lag_function offset:

offset ::= exact_numeric_literal

referenced by: lead_or_lag_function default_expression:

default_expression

::= value_expression

referenced by: lead_or_lag_function null_treatment:

null_treatment

::= ( 'RESPECT*' | 'IGNORE*' ) 'NULLS*'

referenced by: first_or_last_value_function lead_or_lag_function nth_value_function first_or_last_value_function:

first_or_last_value_function

::= first_or_last_value '(' value_expression ')' null_treatment?

referenced by: window_function_type first_or_last_value:

first_or_last_value

::= 'FIRST_VALUE'

| 'LAST_VALUE'

referenced by: first_or_last_value_function nth_value_function:

nth_value_function

::= 'NTH_VALUE' '(' value_expression ',' nth_row ')' from_first_or_last? null_treatment?

referenced by: window_function_type nth_row:

nth_row ::= simple_value_specification

| '?'

referenced by: nth_value_function from_first_or_last:

from_first_or_last

::= 'FROM' ( 'FIRST*' | 'LAST*' )

referenced by: nth_value_function window_name_or_specification:

window_name_or_specification

::= window_name

| in_line_window_specification

referenced by: window_function in_line_window_specification:

in_line_window_specification

::= window_specification

referenced by: window_name_or_specification window_row_pattern_measure:

window_row_pattern_measure

::= measure_name

referenced by: window_function_type nested_window_function:

nested_window_function

::= nested_row_number_function

| value_of_expression_at_row

referenced by: nonparenthesized_value_expression_primary nested_row_number_function:

nested_row_number_function

::= 'ROW_NUMBER' '(' row_marker ')'

referenced by: nested_window_function value_of_expression_at_row:

value_of_expression_at_row

::= 'VALUE_OF' '(' value_expression 'AT' row_marker_expression ',' value_of_default_value ')'

referenced by: nested_window_function row_marker:

row_marker

::= 'BEGIN_PARTITION'

| 'BEGIN_FRAME'

| 'CURRENT_ROW'

| 'FRAME_ROW'

| 'END_FRAME'

| 'END_PARTITION'

referenced by: nested_row_number_function row_marker_expression row_marker_expression:

row_marker_expression

::= row_marker row_marker_delta?

referenced by: value_of_expression_at_row row_marker_delta:

row_marker_delta

::= ( '+' | '-' ) row_marker_offset

referenced by: row_marker_expression row_marker_offset:

row_marker_offset

::= simple_value_specification

| '?'

referenced by: row_marker_delta value_of_default_value:

value_of_default_value

::= value_expression

referenced by: value_of_expression_at_row case_expression:

case_expression

::= case_abbreviation

| case_specification

referenced by: nonparenthesized_value_expression_primary case_abbreviation:

case_abbreviation

::= ( 'NULLIF' '(' value_expression ',' | 'COALESCE' '(' ( value_expression ',' )* ) value_expression ')'

referenced by: case_expression case_specification:

case_specification

::= simple_case

| searched_case

referenced by: case_expression simple_case:

simple_case

::= 'CASE' case_operand simple_when_clause+ else_clause? 'END'

referenced by: case_specification searched_case:

searched_case

::= 'CASE' searched_when_clause+ else_clause? 'END'

referenced by: case_specification simple_when_clause:

simple_when_clause

::= 'WHEN' when_operand_list 'THEN' result

referenced by: simple_case searched_when_clause:

searched_when_clause

::= 'WHEN' search_condition 'THEN' result

referenced by: searched_case else_clause:

else_clause

::= 'ELSE' result

referenced by: searched_case simple_case case_operand:

case_operand

::= row_value_predicand

| overlaps_predicate_part_1

referenced by: simple_case when_operand_list:

when_operand_list

::= when_operand ( ',' when_operand )*

referenced by: simple_when_clause when_operand:

when_operand

::= row_value_predicand

| comparison_predicate_part_2

| between_predicate_part_2

| in_predicate_part_2

| character_like_predicate_part_2

| octet_like_predicate_part_2

| similar_predicate_part_2

| regex_like_predicate_part_2

| null_predicate_part_2

| quantified_comparison_predicate_part_2

| normalized_predicate_part_2

| match_predicate_part_2

| overlaps_predicate_part_2

| distinct_predicate_part_2

| member_predicate_part_2

| submultiset_predicate_part_2

| set_predicate_part_2

| type_predicate_part_2

referenced by: when_operand_list result:

result ::= result_expression

| 'NULL'

referenced by: else_clause searched_when_clause simple_when_clause result_expression:

result_expression

::= value_expression

referenced by: result cast_specification:

cast_specification

::= 'CAST' '(' cast_operand 'AS' cast_target ( 'FORMAT*' cast_template )? ')'

referenced by: nonparenthesized_value_expression_primary cast_operand:

cast_operand

::= value_expression

| implicitly_typed_value_specification

referenced by: cast_specification cast_target:

cast_target

::= domain_name

| data_type

referenced by: cast_specification cast_template:

cast_template

::= character_string_literal

referenced by: cast_specification next_value_expression:

next_value_expression

::= 'NEXT*' 'VALUE' 'FOR' sequence_generator_name

referenced by: nonparenthesized_value_expression_primary field_reference:

field_reference

::= value_expression_primary '.' field_name

referenced by: nonparenthesized_value_expression_primary subtype_treatment:

subtype_treatment

::= 'TREAT' '(' subtype_operand 'AS' target_subtype ')'

referenced by: nonparenthesized_value_expression_primary subtype_operand:

subtype_operand

::= value_expression

referenced by: subtype_treatment target_subtype:

target_subtype

::= path_resolved_user_defined_type_name

| reference_type

referenced by: subtype_treatment method_invocation:

method_invocation

::= direct_invocation

| generalized_invocation

referenced by: new_invocation nonparenthesized_value_expression_primary direct_invocation:

direct_invocation

::= value_expression_primary '.' method_name SQL_argument_list?

referenced by: method_invocation generalized_invocation:

generalized_invocation

::= '(' value_expression_primary 'AS' data_type ')' '.' method_name SQL_argument_list?

referenced by: method_invocation method_selection:

method_selection

::= routine_invocation

no referencesconstructor_method_selection:

constructor_method_selection

::= routine_invocation

no referencesstatic_method_invocation:

static_method_invocation

::= path_resolved_user_defined_type_name '::' method_name SQL_argument_list?

referenced by: nonparenthesized_value_expression_primary static_method_selection:

static_method_selection

::= routine_invocation

no referencesnew_specification:

new_specification

::= 'NEW' path_resolved_user_defined_type_name SQL_argument_list

referenced by: nonparenthesized_value_expression_primary new_invocation:

new_invocation

::= method_invocation

| routine_invocation

no referencesattribute_or_method_reference:

attribute_or_method_reference

::= value_expression_primary '->' qualified_identifier SQL_argument_list?

referenced by: nonparenthesized_value_expression_primary dereference_operation:

dereference_operation

::= reference_value_expression '->' attribute_name

no referencesmethod_reference:

method_reference

::= value_expression_primary '->' method_name SQL_argument_list

no referencesreference_resolution:

reference_resolution

::= 'DEREF' '(' reference_value_expression ')'

referenced by: nonparenthesized_value_expression_primary array_element_reference:

array_element_reference

::= array_value_expression left_bracket_or_trigraph numeric_value_expression right_bracket_or_trigraph

referenced by: nonparenthesized_value_expression_primary multiset_element_reference:

multiset_element_reference

::= 'ELEMENT' '(' multiset_value_expression ')'

referenced by: nonparenthesized_value_expression_primary row_pattern_navigation_operation:

row_pattern_navigation_operation

::= row_pattern_navigation__logical

| row_pattern_navigation__physical

| row_pattern_navigation__compound

referenced by: nonparenthesized_value_expression_primary row_pattern_navigation__logical:

row_pattern_navigation__logical

::= running_or_final? first_or_last '(' value_expression ( ',' logical_offset )? ')'

referenced by: row_pattern_navigation_operation row_pattern_navigation__physical:

row_pattern_navigation__physical

::= prev_or_next '(' value_expression ( ',' physical_offset )? ')'

referenced by: row_pattern_navigation_operation row_pattern_navigation__compound:

row_pattern_navigation__compound

::= prev_or_next '(' running_or_final? first_or_last '(' value_expression ( ',' logical_offset )? ')' ( ',' physical_offset )? ')'

referenced by: row_pattern_navigation_operation first_or_last:

first_or_last

::= 'FIRST*'

| 'LAST*'

referenced by: row_pattern_navigation__compound row_pattern_navigation__logical prev_or_next:

prev_or_next

::= PREV

| 'NEXT*'

referenced by: row_pattern_navigation__compound row_pattern_navigation__physical logical_offset:

logical_offset

::= simple_value_specification

| '?'

referenced by: row_pattern_navigation__compound row_pattern_navigation__logical physical_offset:

physical_offset

::= simple_value_specification

| '?'

referenced by: row_pattern_navigation__compound row_pattern_navigation__physical JSON_value_function:

JSON_value_function

::= 'JSON_VALUE' '(' JSON_API_common_syntax JSON_returning_clause? ( JSON_value_empty_behavior 'ON' 'EMPTY' )? ( JSON_value_error_behavior 'ON' 'ERROR*' )? ')'

referenced by: nonparenthesized_value_expression_primary JSON_returning_clause:

JSON_returning_clause

::= 'RETURNING*' data_type

referenced by: JSON_value_function JSON_value_empty_behavior:

JSON_value_empty_behavior

::= 'ERROR*'

| 'NULL'

| 'DEFAULT' value_expression

referenced by: JSON_value_function JSON_value_error_behavior:

JSON_value_error_behavior

::= 'ERROR*'

| 'NULL'

| 'DEFAULT' value_expression

referenced by: JSON_value_function value_expression:

value_expression

::= common_value_expression

| boolean_value_expression

| row_value_expression

referenced by: JSON_table_column_empty_behavior JSON_table_column_error_behavior JSON_value_empty_behavior JSON_value_error_behavior JSON_value_expression SQL_argument array_aggregate_function array_element case_abbreviation cast_operand contextually_typed_row_value_constructor_element cycle_mark_value default_expression derived_column first_or_last_value_function general_set_function generalized_expression generation_expression hypothetical_set_function_value_expression_list lead_or_lag_extent merge_insert_value_element multiset_element named_argument_SQL_argument non_cycle_mark_value nth_value_function parameter_default parenthesized_value_expression result_expression return_value row_pattern_measure_expression row_pattern_navigation__compound row_pattern_navigation__logical row_pattern_navigation__physical row_value_constructor_element sort_key subtype_operand update_source value_of_default_value value_of_expression_at_row common_value_expression:

common_value_expression

::= numeric_value_expression

| string_value_expression

| datetime_value_expression

| interval_value_expression

| user_defined_type_value_expression

| reference_value_expression

| collection_value_expression

referenced by: contextually_typed_row_value_constructor row_value_constructor row_value_constructor_predicand value_expression user_defined_type_value_expression:

user_defined_type_value_expression

::= value_expression_primary

referenced by: common_value_expression specific_type_method reference_value_expression:

reference_value_expression

::= value_expression_primary

referenced by: common_value_expression dereference_operation reference_resolution collection_value_expression:

collection_value_expression

::= array_value_expression

| multiset_value_expression

referenced by: cardinality_expression collection_derived_table common_value_expression table_function_derived_table numeric_value_expression:

numeric_value_expression

::= term ( ( '+' | '-' ) term )*

referenced by: absolute_value_expression array_element_reference ceiling_function common_logarithm common_value_expression dependent_variable_expression exponential_function floor_function general_logarithm_argument general_logarithm_base independent_variable_expression inverse_distribution_function_argument natural_logarithm numeric_value_expression_base numeric_value_expression_dividend numeric_value_expression_divisor numeric_value_expression_exponent regex_capture_group regex_occurrence repeat_argument sample_percentage square_root start_position string_length trigonometric_function trim_array_function width_bucket_bound_1 width_bucket_bound_2 width_bucket_count width_bucket_operand term:

term ::= factor ( ( '*' | '/' ) factor )*

referenced by: interval_term numeric_value_expression factor:

factor ::= sign? numeric_primary

referenced by: interval_term term numeric_primary:

numeric_primary

::= value_expression_primary

| numeric_value_function

referenced by: factor numeric_value_function:

numeric_value_function

::= position_expression

| regex_occurrences_function

| regex_position_expression

| extract_expression

| length_expression

| cardinality_expression

| max_cardinality_expression

| absolute_value_expression

| modulus_expression

| trigonometric_function

| general_logarithm_function

| common_logarithm

| natural_logarithm

| exponential_function

| power_function

| square_root

| floor_function

| ceiling_function

| width_bucket_function

| match_number_function

referenced by: numeric_primary position_expression:

position_expression

::= character_position_expression

| binary_position_expression

referenced by: numeric_value_function regex_occurrences_function:

regex_occurrences_function

::= 'OCCURRENCES_REGEX' '(' XQuery_pattern ( 'FLAG*' XQuery_option_flag )? 'IN' regex_subject_string ( 'FROM' start_position )? ( 'USING' char_length_units )? ')'

referenced by: numeric_value_function XQuery_pattern:

XQuery_pattern

::= character_value_expression

referenced by: regex_like_predicate_part_2 regex_occurrences_function regex_position_expression regex_substring_function regex_transliteration XQuery_option_flag:

XQuery_option_flag

::= character_value_expression

referenced by: regex_like_predicate_part_2 regex_occurrences_function regex_position_expression regex_substring_function regex_transliteration regex_subject_string:

regex_subject_string

::= character_value_expression

referenced by: regex_occurrences_function regex_position_expression regex_substring_function regex_transliteration regex_position_expression:

regex_position_expression

::= 'POSITION_REGEX' '(' regex_position_start_or_after? XQuery_pattern ( 'FLAG*' XQuery_option_flag )? 'IN' regex_subject_string ( 'FROM' start_position )? ( 'USING' char_length_units )? ( OCCURRENCE regex_occurrence )? ( 'GROUP' regex_capture_group )? ')'

referenced by: numeric_value_function regex_position_start_or_after:

regex_position_start_or_after

::= 'START'

| 'AFTER*'

referenced by: regex_position_expression regex_occurrence:

regex_occurrence

::= numeric_value_expression

referenced by: regex_position_expression regex_substring_function regex_transliteration_occurrence regex_capture_group:

regex_capture_group

::= numeric_value_expression

referenced by: regex_position_expression regex_substring_function character_position_expression:

character_position_expression

::= 'POSITION' '(' character_value_expression_1 'IN' character_value_expression_2 ( 'USING' char_length_units )? ')'

referenced by: position_expression character_value_expression_1:

character_value_expression_1

::= character_value_expression

referenced by: character_position_expression character_value_expression_2:

character_value_expression_2

::= character_value_expression

referenced by: character_position_expression binary_position_expression:

binary_position_expression

::= 'POSITION' '(' binary_value_expression 'IN' binary_value_expression ')'

referenced by: position_expression length_expression:

length_expression

::= char_length_expression

| octet_length_expression

referenced by: numeric_value_function char_length_expression:

char_length_expression

::= ( 'CHAR_LENGTH' | 'CHARACTER_LENGTH' ) '(' character_value_expression ( 'USING' char_length_units )? ')'

referenced by: length_expression octet_length_expression:

octet_length_expression

::= 'OCTET_LENGTH' '(' string_value_expression ')'

referenced by: length_expression extract_expression:

extract_expression

::= 'EXTRACT' '(' extract_field 'FROM' extract_source ')'

referenced by: numeric_value_function extract_field:

extract_field

::= primary_datetime_field

| time_zone_field

referenced by: extract_expression time_zone_field:

time_zone_field

::= 'TIMEZONE_HOUR'

| 'TIMEZONE_MINUTE'

referenced by: extract_field extract_source:

extract_source

::= datetime_value_expression

| interval_value_expression

referenced by: extract_expression cardinality_expression:

cardinality_expression

::= 'CARDINALITY' '(' collection_value_expression ')'

referenced by: numeric_value_function max_cardinality_expression:

max_cardinality_expression

::= 'ARRAY_MAX_CARDINALITY' '(' array_value_expression ')'

referenced by: numeric_value_function absolute_value_expression:

absolute_value_expression

::= 'ABS' '(' numeric_value_expression ')'

referenced by: numeric_value_function modulus_expression:

modulus_expression

::= 'MOD' '(' numeric_value_expression_dividend ',' numeric_value_expression_divisor ')'

referenced by: numeric_value_function numeric_value_expression_dividend:

numeric_value_expression_dividend

::= numeric_value_expression

referenced by: modulus_expression numeric_value_expression_divisor:

numeric_value_expression_divisor

::= numeric_value_expression

referenced by: modulus_expression trigonometric_function:

trigonometric_function

::= trigonometric_function_name '(' numeric_value_expression ')'

referenced by: numeric_value_function trigonometric_function_name:

trigonometric_function_name

::= 'SIN'

| 'COS'

| 'TAN'

| 'SINH'

| 'COSH'

| 'TANH'

| 'ASIN'

| 'ACOS'

| 'ATAN'

referenced by: trigonometric_function general_logarithm_function:

general_logarithm_function

::= 'LOG' '(' general_logarithm_base ',' general_logarithm_argument ')'

referenced by: numeric_value_function general_logarithm_base:

general_logarithm_base

::= numeric_value_expression

referenced by: general_logarithm_function general_logarithm_argument:

general_logarithm_argument

::= numeric_value_expression

referenced by: general_logarithm_function common_logarithm:

common_logarithm

::= 'LOG10' '(' numeric_value_expression ')'

referenced by: numeric_value_function natural_logarithm:

natural_logarithm

::= 'LN' '(' numeric_value_expression ')'

referenced by: numeric_value_function exponential_function:

exponential_function

::= 'EXP' '(' numeric_value_expression ')'

referenced by: numeric_value_function power_function:

power_function

::= 'POWER' '(' numeric_value_expression_base ',' numeric_value_expression_exponent ')'

referenced by: numeric_value_function numeric_value_expression_base:

numeric_value_expression_base

::= numeric_value_expression

referenced by: power_function numeric_value_expression_exponent:

numeric_value_expression_exponent

::= numeric_value_expression

referenced by: power_function square_root:

square_root

::= 'SQRT' '(' numeric_value_expression ')'

referenced by: numeric_value_function floor_function:

floor_function

::= 'FLOOR' '(' numeric_value_expression ')'

referenced by: numeric_value_function ceiling_function:

ceiling_function

::= ( 'CEIL' | 'CEILING' ) '(' numeric_value_expression ')'

referenced by: numeric_value_function width_bucket_function:

width_bucket_function

::= 'WIDTH_BUCKET' '(' width_bucket_operand ',' width_bucket_bound_1 ',' width_bucket_bound_2 ',' width_bucket_count ')'

referenced by: numeric_value_function width_bucket_operand:

width_bucket_operand

::= numeric_value_expression

referenced by: width_bucket_function width_bucket_bound_1:

width_bucket_bound_1

::= numeric_value_expression

referenced by: width_bucket_function width_bucket_bound_2:

width_bucket_bound_2

::= numeric_value_expression

referenced by: width_bucket_function width_bucket_count:

width_bucket_count

::= numeric_value_expression

referenced by: width_bucket_function match_number_function:

match_number_function

::= 'MATCH_NUMBER' '(' ')'

referenced by: numeric_value_function string_value_expression:

string_value_expression

::= character_value_expression

| binary_value_expression

referenced by: JSON_predicate common_value_expression current_collation_specification octet_length_expression character_value_expression:

character_value_expression

::= concatenation

| character_factor

referenced by: JSON_name XQuery_option_flag XQuery_pattern XQuery_replacement_string char_length_expression character_overlay_function character_pattern character_substring_function character_transliteration character_value_expression_1 character_value_expression_2 concatenation escape_character fold listagg_set_function normalize_function regex_subject_string regular_expression_substring_function similar_pattern string_value_expression transcoding trim_character trim_source concatenation:

concatenation

::= character_value_expression '||' character_factor

referenced by: character_value_expression character_factor:

character_factor

::= character_primary collate_clause?

referenced by: character_value_expression concatenation character_primary:

character_primary

::= value_expression_primary

| string_value_function

referenced by: character_factor binary_value_expression:

binary_value_expression

::= binary_concatenation

| binary_factor

referenced by: binary_concatenation binary_overlay_function binary_position_expression binary_substring_function binary_trim_source escape_octet octet_pattern string_value_expression trim_octet binary_factor:

binary_factor

::= binary_primary

referenced by: binary_concatenation binary_value_expression binary_primary:

binary_primary

::= value_expression_primary

| string_value_function

referenced by: binary_factor binary_concatenation:

binary_concatenation

::= binary_value_expression '||' binary_factor

referenced by: binary_value_expression string_value_function:

string_value_function

::= character_value_function

| binary_value_function

| JSON_value_constructor

| JSON_query

referenced by: binary_primary character_primary character_value_function:

character_value_function

::= character_substring_function

| regular_expression_substring_function

| regex_substring_function

| fold

| transcoding

| character_transliteration

| regex_transliteration

| trim_function

| character_overlay_function

| normalize_function

| specific_type_method

| classifier_function

referenced by: string_value_function character_substring_function:

character_substring_function

::= 'SUBSTRING' '(' character_value_expression 'FROM' start_position ( 'FOR' string_length )? ( 'USING' char_length_units )? ')'

referenced by: character_value_function regular_expression_substring_function:

regular_expression_substring_function

::= 'SUBSTRING' '(' character_value_expression 'SIMILAR' character_value_expression 'ESCAPE' escape_character ')'

referenced by: character_value_function regex_substring_function:

regex_substring_function

::= 'SUBSTRING_REGEX' '(' XQuery_pattern ( 'FLAG*' XQuery_option_flag )? 'IN' regex_subject_string ( 'FROM' start_position )? ( 'USING' char_length_units )? ( OCCURRENCE regex_occurrence )? ( 'GROUP' regex_capture_group )? ')'

referenced by: character_value_function fold:

fold ::= ( 'UPPER' | 'LOWER' ) '(' character_value_expression ')'

referenced by: character_value_function transcoding:

transcoding

::= 'CONVERT' '(' character_value_expression 'USING' transcoding_name ')'

referenced by: character_value_function character_transliteration:

character_transliteration

::= 'TRANSLATE' '(' character_value_expression 'USING' transliteration_name ')'

referenced by: character_value_function regex_transliteration:

regex_transliteration

::= 'TRANSLATE_REGEX' '(' XQuery_pattern ( 'FLAG*' XQuery_option_flag )? 'IN' regex_subject_string ( 'WITH' XQuery_replacement_string )? ( 'FROM' start_position )? ( 'USING' char_length_units )? ( OCCURRENCE regex_transliteration_occurrence )? ')'

referenced by: character_value_function XQuery_replacement_string:

XQuery_replacement_string

::= character_value_expression

referenced by: regex_transliteration regex_transliteration_occurrence:

regex_transliteration_occurrence

::= regex_occurrence

| 'ALL'

referenced by: regex_transliteration trim_function:

trim_function

::= 'TRIM' '(' trim_operands ')'

referenced by: character_value_function trim_operands:

trim_operands

::= ( trim_specification? trim_character? 'FROM' )? trim_source

referenced by: trim_function trim_source:

trim_source

::= character_value_expression

referenced by: trim_operands trim_specification:

trim_specification

::= 'LEADING'

| 'TRAILING'

| 'BOTH'

referenced by: binary_trim_operands trim_operands trim_character:

trim_character

::= character_value_expression

referenced by: trim_operands character_overlay_function:

character_overlay_function

::= 'OVERLAY' '(' character_value_expression 'PLACING*' character_value_expression 'FROM' start_position ( 'FOR' string_length )? ( 'USING' char_length_units )? ')'

referenced by: character_value_function normalize_function:

normalize_function

::= 'NORMALIZE' '(' character_value_expression ( ',' normal_form ( ',' normalize_function_result_length )? )? ')'

referenced by: character_value_function normal_form:

normal_form

::= 'NFC*'

| 'NFD*'

| 'NFKC*'

| 'NFKD*'

referenced by: normalize_function normalized_predicate_part_2 normalize_function_result_length:

normalize_function_result_length

::= character_length

| character_large_object_length

referenced by: normalize_function specific_type_method:

specific_type_method

::= user_defined_type_value_expression '.' 'SPECIFICTYPE' ( '(' ')' )?

referenced by: character_value_function binary_value_function:

binary_value_function

::= binary_substring_function

| binary_trim_function

| binary_overlay_function

referenced by: string_value_function binary_substring_function:

binary_substring_function

::= 'SUBSTRING' '(' binary_value_expression 'FROM' start_position ( 'FOR' string_length )? ')'

referenced by: binary_value_function binary_trim_function:

binary_trim_function

::= 'TRIM' '(' binary_trim_operands ')'

referenced by: binary_value_function binary_trim_operands:

binary_trim_operands

::= ( trim_specification? trim_octet? 'FROM' )? binary_trim_source

referenced by: binary_trim_function binary_trim_source:

binary_trim_source

::= binary_value_expression

referenced by: binary_trim_operands trim_octet:

trim_octet

::= binary_value_expression

referenced by: binary_trim_operands binary_overlay_function:

binary_overlay_function

::= 'OVERLAY' '(' binary_value_expression 'PLACING*' binary_value_expression 'FROM' start_position ( 'FOR' string_length )? ')'

referenced by: binary_value_function start_position:

start_position

::= numeric_value_expression

referenced by: binary_overlay_function binary_substring_function character_overlay_function character_substring_function regex_occurrences_function regex_position_expression regex_substring_function regex_transliteration string_length:

string_length

::= numeric_value_expression

referenced by: binary_overlay_function binary_substring_function character_overlay_function character_substring_function classifier_function:

classifier_function

::= 'CLASSIFIER' '(' row_pattern_variable_name? ')'

referenced by: character_value_function JSON_value_constructor:

JSON_value_constructor

::= JSON_object_constructor

| JSON_array_constructor

referenced by: string_value_function JSON_object_constructor:

JSON_object_constructor

::= 'JSON_OBJECT' '(' ( JSON_name_and_value ( ',' JSON_name_and_value )* JSON_constructor_null_clause? JSON_key_uniqueness_constraint? )? JSON_output_clause? ')'

referenced by: JSON_value_constructor JSON_name_and_value:

JSON_name_and_value

::= ( 'KEY*'? JSON_name 'VALUE' | JSON_name ':' ) JSON_value_expression

referenced by: JSON_object_aggregate_constructor JSON_object_constructor JSON_name:

JSON_name

::= character_value_expression

referenced by: JSON_name_and_value JSON_constructor_null_clause:

JSON_constructor_null_clause

::= ( 'NULL' | ABSENT ) 'ON' 'NULL'

referenced by: JSON_array_aggregate_constructor JSON_array_constructor_by_enumeration JSON_array_constructor_by_query JSON_object_aggregate_constructor JSON_object_constructor JSON_array_constructor:

JSON_array_constructor

::= JSON_array_constructor_by_enumeration

| JSON_array_constructor_by_query

referenced by: JSON_value_constructor JSON_array_constructor_by_enumeration:

JSON_array_constructor_by_enumeration

::= 'JSON_ARRAY' '(' ( JSON_value_expression ( ',' JSON_value_expression )* JSON_constructor_null_clause? )? JSON_output_clause? ')'

referenced by: JSON_array_constructor JSON_array_constructor_by_query:

JSON_array_constructor_by_query

::= 'JSON_ARRAY' '(' query_expression JSON_input_clause? JSON_constructor_null_clause? JSON_output_clause? ')'

referenced by: JSON_array_constructor JSON_query:

::= 'JSON_QUERY' '(' ? ( 'WRAPPER*' )? ( 'QUOTES*' ( 'ON' 'SCALAR*' 'STRING*' )? )? ( 'ON' 'EMPTY' )? ( 'ON' 'ERROR*' )? ')'

referenced by: string_value_function JSON_query_wrapper_behavior:

referenced by: JSON_query_quotes_behavior: referenced by: referenced by: