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

| direct_implementation_defined_statement

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

| 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

::= space

| '"'

| '%'

| '&'

| "'"

| '('

| ')'

| '*'

| '+'

| ','

| '-'

| '.'

| '/'

| ':'

| ';'

| '<'

| '='

| '>'

| '?'

| '['

| ']'

| '^'

| '_'

| '|'

| '{'

| '}'

referenced by: SQL_language_character delimiter_token space:

space ::=

referenced by: SQL_special_character day_time_interval unquoted_timestamp_string 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

| bit_string_literal

| hex_string_literal

| large_object_length_token

| multiplier

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 identifier_start:

identifier_start

::=

referenced by: identifier_body identifier_part identifier_extend:

identifier_extend

::=

referenced by: identifier_part large_object_length_token:

large_object_length_token

::= digit . . . multiplier

referenced by: large_object_length nondelimiter_token multiplier:

multiplier

::= 'K'

| 'M'

| 'G'

referenced by: large_object_length large_object_length_token nondelimiter_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

::= nondoublequote_character

| doublequote_symbol

referenced by: Unicode_identifier_part delimited_identifier_body Unicode_delimited_identifier:

Unicode_delimited_identifier

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

referenced by: delimiter_token Unicode_escape_specifier:

Unicode_escape_specifier

::= ( 'UESCAPE' "'" Unicode_escape_character "'" )?

referenced by: 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

::= Unicode_escape_character hexit hexit hexit hexit

referenced by: Unicode_escape_value Unicode_6_digit_escape_value:

Unicode_6_digit_escape_value

::= Unicode_escape_character '+' hexit hexit hexit hexit hexit hexit

referenced by: Unicode_escape_value Unicode_character_escape_value:

Unicode_character_escape_value

::= Unicode_escape_character Unicode_escape_character

referenced by: Unicode_escape_value Unicode_escape_character:

Unicode_escape_character

::=

referenced by: Unicode_4_digit_escape_value Unicode_6_digit_escape_value Unicode_character_escape_value Unicode_escape_specifier nondoublequote_character:

nondoublequote_character

::=

referenced by: delimited_identifier_part doublequote_symbol:

doublequote_symbol

::= '"' '"'

referenced by: delimited_identifier_part delimiter_token:

delimiter_token

::= character_string_literal

| date_string

| time_string

| timestamp_string

| interval_string

| delimited_identifier

| Unicode_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

::= slash '*'

referenced by: bracketed_comment bracketed_comment_terminator:

bracketed_comment_terminator

::= '*' slash

referenced by: bracketed_comment bracketed_comment_contents:

bracketed_comment_contents

::= ( comment_character | separator )*

referenced by: bracketed_comment comment_character:

comment_character

::= nonquote_character

| "'"

referenced by: bracketed_comment_contents simple_comment newline:

newline ::=

referenced by: simple_comment key_word:

key_word ::= reserved_word

| non_reserved_word

referenced by: nondelimiter_token non_reserved_word:

non_reserved_word

::= 'A*'

| 'ABS*'

| 'ABSOLUTE*'

| 'ACTION*'

| 'ADA*'

| 'ADMIN*'

| 'AFTER*'

| 'ALWAYS*'

| 'ASC*'

| 'ASSERTION*'

| 'ASSIGNMENT*'

| 'ATTRIBUTE*'

| 'ATTRIBUTES*'

| 'AVG*'

| 'BEFORE*'

| 'BERNOULLI*'

| 'BREADTH*'

| 'C*'

| 'CARDINALITY*'

| 'CASCADE*'

| 'CATALOG*'

| 'CATALOG_NAME*'

| 'CEIL*'

| 'CEILING*'

| 'CHAIN*'

| 'CHARACTERISTICS*'

| 'CHARACTERS*'

| 'CHARACTER_LENGTH*'

| 'CHARACTER_SET_CATALOG*'

| 'CHARACTER_SET_NAME*'

| 'CHARACTER_SET_SCHEMA*'

| 'CHAR_LENGTH*'

| 'CHECKED*'

| 'CLASS_ORIGIN*'

| 'COALESCE*'

| 'COBOL*'

| 'CODE_UNITS*'

| 'COLLATION*'

| 'COLLATION_CATALOG*'

| 'COLLATION_NAME*'

| 'COLLATION_SCHEMA*'

| 'COLLECT*'

| 'COLUMN_NAME*'

| 'COMMAND_FUNCTION*'

| 'COMMAND_FUNCTION_CODE*'

| 'COMMITTED*'

| 'CONDITION*'

| 'CONDITION_NUMBER*'

| 'CONNECTION_NAME*'

| 'CONSTRAINTS*'

| 'CONSTRAINT_CATALOG*'

| 'CONSTRAINT_NAME*'

| 'CONSTRAINT_SCHEMA*'

| 'CONSTRUCTORS*'

| 'CONTAINS*'

| 'CONVERT*'

| 'CORR*'

| 'COUNT*'

| 'COVAR_POP*'

| 'COVAR_SAMP*'

| 'CUME_DIST*'

| 'CURRENT_COLLATION*'

| 'CURSOR_NAME*'

| 'DATA*'

| 'DATETIME_INTERVAL_CODE*'

| 'DATETIME_INTERVAL_PRECISION*'

| 'DEFAULTS*'

| 'DEFERRABLE*'

| 'DEFERRED*'

| 'DEFINED*'

| 'DEFINER*'

| 'DEGREE*'

| 'DENSE_RANK*'

| 'DEPTH*'

| 'DERIVED*'

| 'DESC*'

| 'DESCRIPTOR*'

| 'DIAGNOSTICS*'

| 'DISPATCH*'

| 'DOMAIN*'

| 'DYNAMIC_FUNCTION*'

| 'DYNAMIC_FUNCTION_CODE*'

| 'EQUALS*'

| 'EVERY*'

| 'EXCEPTION*'

| 'EXCLUDE*'

| 'EXCLUDING*'

| 'EXP*'

| 'EXTRACT*'

| 'FINAL*'

| 'FIRST*'

| 'FLOOR*'

| 'FOLLOWING*'

| 'FORTRAN*'

| 'FOUND*'

| 'FUSION*'

| 'G*'

| 'GENERAL*'

| 'GO*'

| 'GOTO*'

| 'GRANTED*'

| 'HIERARCHY*'

| 'IMPLEMENTATION*'

| 'INCLUDING*'

| 'INCREMENT*'

| 'INITIALLY*'

| 'INSTANCE*'

| 'INSTANTIABLE*'

| 'INTERSECTION*'

| 'INVOKER*'

| ISOLATION

| 'K*'

| 'KEY*'

| 'KEY_MEMBER*'

| 'KEY_TYPE*'

| 'LAST*'

| 'LENGTH*'

| 'LEVEL*'

| 'LN*'

| 'LOCATOR*'

| 'LOWER*'

| 'M*'

| 'MAP*'

| 'MATCHED*'

| 'MAX*'

| 'MAXVALUE*'

| 'MESSAGE_LENGTH*'

| 'MESSAGE_OCTET_LENGTH*'

| 'MESSAGE_TEXT*'

| 'MIN*'

| 'MINVALUE*'

| 'MOD*'

| 'MORE*'

| 'MUMPS*'

| 'NAME*'

| 'NAMES*'

| 'NESTING*'

| 'NEXT*'

| 'NORMALIZE*'

| 'NORMALIZED*'

| 'NULLABLE*'

| 'NULLIF*'

| 'NULLS*'

| 'NUMBER*'

| 'OBJECT*'

| 'OCTETS*'

| 'OCTET_LENGTH*'

| 'OPTION*'

| 'OPTIONS*'

| 'ORDERING*'

| 'ORDINALITY*'

| 'OTHERS*'

| 'OVERLAY*'

| 'OVERRIDING*'

| 'PAD*'

| 'PARAMETER_MODE*'

| 'PARAMETER_NAME*'

| 'PARAMETER_ORDINAL_POSITION*'

| 'PARAMETER_SPECIFIC_CATALOG*'

| 'PARAMETER_SPECIFIC_NAME*'

| 'PARAMETER_SPECIFIC_SCHEMA*'

| 'PARTIAL*'

| 'PASCAL*'

| 'PATH*'

| 'PERCENTILE_CONT*'

| 'PERCENTILE_DISC*'

| 'PERCENT_RANK*'

| 'PLACING*'

| 'PLI*'

| 'POSITION*'

| 'POWER*'

| 'PRECEDING*'

| 'PRESERVE*'

| 'PRIOR*'

| 'PRIVILEGES*'

| 'PUBLIC*'

| 'RANK*'

| 'READ*'

| 'RELATIVE*'

| 'REPEATABLE*'

| 'RESTART*'

| 'RETURNED_CARDINALITY*'

| 'RETURNED_LENGTH*'

| 'RETURNED_OCTET_LENGTH*'

| 'RETURNED_SQLSTATE*'

| 'ROLE*'

| 'ROUTINE*'

| 'ROUTINE_CATALOG*'

| 'ROUTINE_NAME*'

| 'ROUTINE_SCHEMA*'

| 'ROW_COUNT*'

| 'ROW_NUMBER*'

| '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*'

| 'SQRT*'

| 'STATE*'

| 'STATEMENT*'

| 'STDDEV_POP*'

| 'STDDEV_SAMP*'

| 'STRUCTURE*'

| 'STYLE*'

| 'SUBCLASS_ORIGIN*'

| 'SUBSTRING*'

| 'SUM*'

| 'TABLESAMPLE*'

| 'TABLE_NAME*'

| 'TEMPORARY*'

| 'TIES*'

| 'TOP_LEVEL_COUNT*'

| 'TRANSACTION*'

| 'TRANSACTIONS_COMMITTED*'

| 'TRANSACTIONS_ROLLED_BACK*'

| 'TRANSACTION_ACTIVE*'

| 'TRANSFORM*'

| 'TRANSFORMS*'

| 'TRANSLATE*'

| 'TRIGGER_CATALOG*'

| 'TRIGGER_NAME*'

| 'TRIGGER_SCHEMA*'

| 'TRIM*'

| 'TYPE*'

| 'UNBOUNDED*'

| 'UNCOMMITTED*'

| 'UNDER*'

| 'UNNAMED*'

| 'USAGE*'

| 'USER_DEFINED_TYPE_CATALOG*'

| 'USER_DEFINED_TYPE_CODE*'

| 'USER_DEFINED_TYPE_NAME*'

| 'USER_DEFINED_TYPE_SCHEMA*'

| 'VIEW*'

| 'WORK*'

| 'WRITE*'

| 'ZONE*'

referenced by: key_word reserved_word:

reserved_word

::= 'ADD'

| 'ALL'

| 'ALLOCATE'

| 'ALTER'

| 'AND'

| 'ANY'

| 'ARE'

| 'ARRAY'

| 'AS'

| 'ASENSITIVE'

| 'ASYMMETRIC'

| 'AT'

| 'ATOMIC'

| 'AUTHORIZATION'

| 'BEGIN'

| 'BETWEEN'

| 'BIGINT'

| 'BINARY'

| 'BLOB'

| 'BOOLEAN'

| 'BOTH'

| 'BY'

| 'CALL'

| 'CALLED'

| 'CASCADED'

| 'CASE'

| 'CAST'

| 'CHAR'

| 'CHARACTER'

| 'CHECK'

| 'CLOB'

| 'CLOSE'

| 'COLLATE'

| 'COLUMN'

| 'COMMIT'

| 'CONNECT'

| 'CONSTRAINT'

| 'CONTINUE'

| 'CORRESPONDING'

| 'CREATE'

| 'CROSS'

| 'CUBE'

| 'CURRENT'

| 'CURRENT_DATE'

| 'CURRENT_DEFAULT_TRANSFORM_GROUP'

| 'CURRENT_PATH'

| 'CURRENT_ROLE'

| 'CURRENT_TIME'

| 'CURRENT_TIMESTAMP'

| 'CURRENT_TRANSFORM_GROUP_FOR_TYPE'

| 'CURRENT_USER'

| 'CURSOR'

| 'CYCLE'

| 'DATE'

| 'DAY'

| 'DEALLOCATE'

| 'DEC'

| 'DECIMAL'

| 'DECLARE'

| 'DEFAULT'

| 'DELETE'

| 'DEREF'

| 'DESCRIBE'

| 'DETERMINISTIC'

| 'DISCONNECT'

| 'DISTINCT'

| 'DOUBLE'

| 'DROP'

| 'DYNAMIC'

| 'EACH'

| 'ELEMENT'

| 'ELSE'

| 'END'

| 'END-EXEC'

| 'ESCAPE'

| 'EXCEPT'

| 'EXEC'

| 'EXECUTE'

| 'EXISTS'

| 'EXTERNAL'

| 'FALSE'

| 'FETCH'

| 'FILTER'

| 'FLOAT'

| 'FOR'

| 'FOREIGN'

| 'FREE'

| 'FROM'

| 'FULL'

| 'FUNCTION'

| 'GET'

| 'GLOBAL'

| 'GRANT'

| 'GROUP'

| 'GROUPING'

| 'HAVING'

| 'HOLD'

| 'HOUR'

| 'IDENTITY'

| 'IMMEDIATE'

| 'IN'

| 'INDICATOR'

| 'INNER'

| 'INOUT'

| 'INPUT'

| 'INSENSITIVE'

| 'INSERT'

| 'INT'

| 'INTEGER'

| 'INTERSECT'

| 'INTERVAL'

| 'INTO'

| 'IS'

| ISOLATION

| 'JOIN'

| 'LANGUAGE'

| 'LARGE'

| 'LATERAL'

| 'LEADING'

| 'LEFT'

| 'LIKE'

| 'LOCAL'

| 'LOCALTIME'

| 'LOCALTIMESTAMP'

| 'MATCH'

| 'MEMBER'

| 'MERGE'

| 'METHOD'

| 'MINUTE'

| 'MODIFIES'

| 'MODULE'

| 'MONTH'

| 'MULTISET'

| 'NATIONAL'

| 'NATURAL'

| 'NCHAR'

| 'NCLOB'

| 'NEW'

| 'NO'

| 'NONE'

| 'NOT'

| 'NULL'

| 'NUMERIC'

| 'OF'

| 'OLD'

| 'ON'

| 'ONLY'

| 'OPEN'

| 'OR'

| 'ORDER'

| 'OUT'

| 'OUTER'

| 'OUTPUT'

| 'OVER'

| 'OVERLAPS'

| 'PARAMETER'

| 'PARTITION'

| 'PRECISION'

| 'PREPARE'

| 'PRIMARY'

| 'PROCEDURE'

| 'RANGE'

| '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'

| 'ROWS'

| 'SAVEPOINT'

| 'SCROLL'

| 'SEARCH'

| 'SECOND'

| 'SELECT'

| 'SENSITIVE'

| 'SESSION_USER'

| 'SET'

| 'SIMILAR'

| 'SMALLINT'

| 'SOME'

| 'SPECIFIC'

| 'SPECIFICTYPE'

| 'SQL'

| 'SQLEXCEPTION'

| 'SQLSTATE'

| 'SQLWARNING'

| 'START'

| 'STATIC'

| 'SUBMULTISET'

| 'SYMMETRIC'

| 'SYSTEM'

| 'SYSTEM_USER'

| 'TABLE'

| 'THEN'

| 'TIME'

| 'TIMESTAMP'

| 'TIMEZONE_HOUR'

| 'TIMEZONE_MINUTE'

| 'TO'

| 'TRAILING'

| 'TRANSLATION'

| 'TREAT'

| 'TRIGGER'

| 'TRUE'

| 'UESCAPE'

| 'UNION'

| 'UNIQUE'

| 'UNKNOWN'

| 'UNNEST'

| 'UPDATE'

| 'UPPER'

| 'USER'

| 'USING'

| 'VALUE'

| 'VALUES'

| 'VAR_POP'

| 'VAR_SAMP'

| 'VARCHAR'

| 'VARYING'

| '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: delimiter_token external_routine_name general_literal 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 nonquote_character:

nonquote_character

::=

referenced by: character_representation comment_character 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? "'" )* ( 'ESCAPE' escape_character )?

referenced by: general_literal Unicode_representation:

Unicode_representation

::= character_representation

| Unicode_escape_value

referenced by: Unicode_character_string_literal binary_string_literal:

binary_string_literal

::= X "'" ( hexit hexit )* "'" ( separator "'" ( hexit hexit )* "'" )* ( 'ESCAPE' escape_character )?

referenced by: general_literal 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 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: array_type datetime_value exact_numeric_literal goto_target high_value interval_fractional_seconds_precision interval_leading_field_precision large_object_length length low_value maximum_dynamic_result_sets precision 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 space 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 )?

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 ( space 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: SQL_client_module_name SQL_parameter_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 method_name new_values_table_alias old_values_table_alias procedure_name qualified_identifier query_name regular_character_set_identifier role_name savepoint_name statement_name user_identifier window_name actual_identifier:

actual_identifier

::= regular_identifier

| delimited_identifier

referenced by: identifier SQL_language_identifier:

SQL_language_identifier

::= SQL_language_identifier_start ( '_' | SQL_language_identifier_part )*

referenced by: character_set_name 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 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 column_definition 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 schema_qualified_type_name specific_method_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 schema_qualified_type_name column_name:

column_name

::= identifier

referenced by: alter_column_definition as_clause column_definition column_name_list column_options column_reference cycle_column cycle_mark_column drop_column_definition object_column path_column self_referencing_column_name sequence_column table_function_column_list_element view_column_option correlation_name:

correlation_name

::= identifier

referenced by: merge_correlation_name new_values_correlation_name old_values_correlation_name table_primary query_name:

query_name

::= identifier

referenced by: 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: close_statement declare_cursor delete_statement__positioned dynamic_cursor_name dynamic_declare_cursor fetch_statement open_statement preparable_dynamic_delete_statement__positioned preparable_dynamic_update_statement__positioned 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_value_specification SQL_parameter_name:

SQL_parameter_name

::= identifier

referenced by: SQL_parameter_declaration constraint_name:

constraint_name

::= schema_qualified_name

referenced by: SQL_condition 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 user_defined_type_name:

user_defined_type_name

::= schema_qualified_type_name

referenced by: path_resolved_user_defined_type_name schema_resolved_user_defined_type_name 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 schema_qualified_type_name:

schema_qualified_type_name

::= ( schema_name '.' )? qualified_identifier

referenced by: 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 statement_cursor dynamic_cursor_name:

dynamic_cursor_name

::= cursor_name

| extended_cursor_name

referenced by: dynamic_close_statement dynamic_delete_statement__positioned dynamic_fetch_statement dynamic_open_statement dynamic_update_statement__positioned extended_cursor_name:

extended_cursor_name

::= scope_option? simple_value_specification

referenced by: allocate_cursor_statement described_object dynamic_cursor_name descriptor_name:

descriptor_name

::= scope_option? simple_value_specification

referenced by: allocate_descriptor_statement deallocate_descriptor_statement get_descriptor_statement into_descriptor set_descriptor_statement using_descriptor scope_option:

scope_option

::= 'GLOBAL'

| 'LOCAL'

referenced by: descriptor_name extended_cursor_name extended_statement_name preparable_dynamic_delete_statement__positioned preparable_dynamic_update_statement__positioned window_name:

window_name

::= identifier

referenced by: existing_window_name new_window_name window_name_or_specification data_type:

data_type

::= predefined_type

| row_type

| path_resolved_user_defined_type_name

| reference_type

| collection_type

referenced by: array_type attribute_definition cast_target column_definition data_type_list domain_definition 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_large_object_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 representation user_defined_representation character_string_type:

character_string_type

::= ( 'CHARACTER' | 'CHAR' ) ( 'VARYING'? '(' length ')' | 'LARGE' 'OBJECT*' ( '(' large_object_length ')' )? )?

| 'VARCHAR' '(' length ')'

| 'CLOB' ( '(' large_object_length ')' )?

referenced by: predefined_type national_character_string_type:

national_character_string_type

::= 'NATIONAL' ( 'CHARACTER' ( 'VARYING'? '(' length ')' | 'LARGE' 'OBJECT*' ( '(' large_object_length ')' )? )? | 'CHAR' ( 'VARYING'? '(' length ')' )? )

| 'NCHAR' ( 'VARYING'? '(' length ')' | 'LARGE' 'OBJECT*' ( '(' large_object_length ')' )? )?

| 'NCLOB' ( '(' large_object_length ')' )?

referenced by: predefined_type binary_large_object_string_type:

binary_large_object_string_type

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

referenced by: predefined_type numeric_type:

numeric_type

::= exact_numeric_type

| approximate_numeric_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 length:

length ::= unsigned_integer

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

large_object_length

::= ( unsigned_integer multiplier? | large_object_length_token ) char_length_units?

referenced by: Ada_BLOB_variable Ada_CLOB_variable COBOL_BLOB_variable COBOL_CLOB_variable COBOL_NCLOB_variable C_BLOB_variable C_CLOB_variable C_NCLOB_variable Fortran_BLOB_variable Fortran_CLOB_variable MUMPS_BLOB_variable MUMPS_CLOB_variable PL_I_BLOB_variable PL_I_CLOB_variable Pascal_BLOB_variable Pascal_CLOB_variable binary_large_object_string_type character_string_type national_character_string_type char_length_units:

char_length_units

::= 'CHARACTERS*'

| 'CODE_UNITS*'

| 'OCTETS*'

referenced by: char_length_expression character_overlay_function character_substring_function large_object_length string_position_expression precision:

precision

::= unsigned_integer

referenced by: MUMPS_type_specification PL_I_type_specification approximate_numeric_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 referenceable_view_specification referenced_type static_method_invocation supertype_name table_contents_source target_subtype transform_group_characteristic collection_type:

collection_type

::= array_type

| multiset_type

referenced by: data_type array_type:

array_type

::= data_type 'ARRAY' ( left_bracket_or_trigraph unsigned_integer 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 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 reference_scope_check?

referenced by: row_type_body value_expression_primary:

value_expression_primary

::= parenthesized_value_expression

| nonparenthesized_value_expression_primary

referenced by: all_fields_reference array_factor attribute_or_method_reference blob_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

| 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

| routine_invocation

| next_value_expression

referenced by: boolean_predicand row_value_special_case 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_DEFAULT_TRANSFORM_GROUP'

| 'CURRENT_PATH'

| 'CURRENT_ROLE'

| '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: SQL_server_name SQL_statement_variable attributes_variable condition_number connection_name connection_user_name descriptor_name extended_cursor_name extended_statement_name fetch_orientation item_number number_of_conditions occurrences 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 select_target_list simple_target_specification:

simple_target_specification

::= host_parameter_specification

| SQL_parameter_reference

| column_reference

| embedded_variable_name

referenced by: 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 simple_target_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

::= 'CURRENT_COLLATION*' '(' string_value_expression ')'

referenced by: general_value_specification contextually_typed_value_specification:

contextually_typed_value_specification

::= implicitly_typed_value_specification

| 'DEFAULT'

referenced by: contextually_typed_row_value_constructor contextually_typed_row_value_constructor_element merge_insert_value_element 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 column_reference:

column_reference

::= basic_identifier_chain

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

referenced by: grouping_column_reference grouping_operation nonparenthesized_value_expression_primary simple_target_specification 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

::= aggregate_function

| grouping_operation

referenced by: nonparenthesized_value_expression_primary 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

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 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 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 '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

referenced by: simple_case 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

| null_predicate_part_2

| quantified_comparison_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: simple_when_clause 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 ')'

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 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' routine_invocation

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 value_expression:

value_expression

::= common_value_expression

| boolean_value_expression

| row_value_expression

referenced by: SQL_argument array_element case_abbreviation cast_operand contextually_typed_row_value_constructor_element cycle_mark_value derived_column general_set_function generalized_expression generation_expression hypothetical_set_function_value_expression_list merge_insert_value_element multiset_element non_cycle_mark_value parenthesized_value_expression result_expression return_value row_value_constructor_element sort_key subtype_operand update_source 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 collection_value_constructor:

collection_value_constructor

::= array_value_constructor

| multiset_value_constructor

referenced by: nonparenthesized_value_expression_primary numeric_value_expression:

numeric_value_expression

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

referenced by: absolute_value_expression array_element_reference ceiling_function common_value_expression dependent_variable_expression exponential_function floor_function independent_variable_expression inverse_distribution_function_argument natural_logarithm numeric_value_expression_base numeric_value_expression_exponent repeat_argument sample_percentage square_root start_position string_length 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

| extract_expression

| length_expression

| cardinality_expression

| absolute_value_expression

| modulus_expression

| natural_logarithm

| exponential_function

| power_function

| square_root

| floor_function

| ceiling_function

| width_bucket_function

referenced by: numeric_primary position_expression:

position_expression

::= string_position_expression

| blob_position_expression

referenced by: numeric_value_function string_position_expression:

string_position_expression

::= 'POSITION*' '(' string_value_expression 'IN' string_value_expression ( 'USING' char_length_units )? ')'

referenced by: position_expression blob_position_expression:

blob_position_expression

::= 'POSITION*' '(' blob_value_expression 'IN' blob_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*' ) '(' string_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 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 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 string_value_expression:

string_value_expression

::= character_value_expression

| blob_value_expression

referenced by: char_length_expression common_value_expression current_collation_specification normalized_predicate octet_length_expression string_position_expression character_value_expression:

character_value_expression

::= concatenation

| character_factor

referenced by: character_overlay_function character_pattern character_substring_function character_transliteration concatenation escape_character fold normalize_function 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 blob_value_expression:

blob_value_expression

::= blob_concatenation

| blob_factor

referenced by: blob_concatenation blob_overlay_function blob_position_expression blob_substring_function blob_trim_source escape_octet octet_pattern string_value_expression trim_octet blob_factor:

blob_factor

::= blob_primary

referenced by: blob_concatenation blob_value_expression blob_primary:

blob_primary

::= value_expression_primary

| string_value_function

referenced by: blob_factor blob_concatenation:

blob_concatenation

::= blob_value_expression '||' blob_factor

referenced by: blob_value_expression string_value_function:

string_value_function

::= character_value_function

| blob_value_function

referenced by: blob_primary character_primary character_value_function:

character_value_function

::= character_substring_function

| regular_expression_substring_function

| fold

| transcoding

| character_transliteration

| trim_function

| character_overlay_function

| normalize_function

| specific_type_method

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 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 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: blob_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 ')'

referenced by: character_value_function specific_type_method:

specific_type_method

::= user_defined_type_value_expression '.' 'SPECIFICTYPE'

referenced by: character_value_function blob_value_function:

blob_value_function

::= blob_substring_function

| blob_trim_function

| blob_overlay_function

referenced by: string_value_function blob_substring_function:

blob_substring_function

::= 'SUBSTRING*' '(' blob_value_expression 'FROM' start_position ( 'FOR' string_length )? ')'

referenced by: blob_value_function blob_trim_function:

blob_trim_function

::= 'TRIM*' '(' blob_trim_operands ')'

referenced by: blob_value_function blob_trim_operands:

blob_trim_operands

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

referenced by: blob_trim_function blob_trim_source:

blob_trim_source

::= blob_value_expression

referenced by: blob_trim_operands trim_octet:

trim_octet

::= blob_value_expression

referenced by: blob_trim_operands blob_overlay_function:

blob_overlay_function

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

referenced by: blob_value_function start_position:

start_position

::= numeric_value_expression

referenced by: blob_overlay_function blob_substring_function character_overlay_function character_substring_function string_length:

string_length

::= numeric_value_expression

referenced by: blob_overlay_function blob_substring_function character_overlay_function character_substring_function datetime_value_expression:

datetime_value_expression

::= ( interval_value_expression '+' )? datetime_term ( ( '+' | '-' ) interval_term )*

referenced by: common_value_expression extract_source interval_value_expression datetime_term:

datetime_term

::= datetime_factor

referenced by: datetime_value_expression interval_value_expression datetime_factor:

datetime_factor

::= datetime_primary time_zone?

referenced by: datetime_term datetime_primary:

datetime_primary

::= value_expression_primary

| datetime_value_function

referenced by: datetime_factor time_zone:

time_zone

::= 'AT' time_zone_specifier

referenced by: datetime_factor time_zone_specifier:

time_zone_specifier

::= 'LOCAL'

| 'TIME' 'ZONE*' interval_primary

referenced by: time_zone datetime_value_function:

datetime_value_function

::= 'CURRENT_DATE'

| current_time_value_function

| current_timestamp_value_function

| current_local_time_value_function

| current_local_timestamp_value_function

referenced by: datetime_primary default_option current_time_value_function:

current_time_value_function

::= 'CURRENT_TIME' ( '(' time_precision ')' )?

referenced by: datetime_value_function current_local_time_value_function:

current_local_time_value_function

::= 'LOCALTIME' ( '(' time_precision ')' )?

referenced by: datetime_value_function current_timestamp_value_function:

current_timestamp_value_function

::= 'CURRENT_TIMESTAMP' ( '(' timestamp_precision ')' )?

referenced by: datetime_value_function current_local_timestamp_value_function:

current_local_timestamp_value_function

::= 'LOCALTIMESTAMP' ( '(' timestamp_precision ')' )?

referenced by: datetime_value_function interval_value_expression:

interval_value_expression

::= interval_term

| interval_value_expression_1 ( '+' | '-' ) interval_term_1

| '(' datetime_value_expression '-' datetime_term ')' interval_qualifier

referenced by: common_value_expression datetime_value_expression extract_source interval_absolute_value_function interval_value_expression_1 set_time_zone_value interval_term:

interval_term

::= ( term '*' )? interval_factor

| interval_term_2 ( '*' | '/' ) factor

referenced by: datetime_value_expression interval_term_1 interval_term_2 interval_value_expression interval_factor:

interval_factor

::= sign? interval_primary

referenced by: interval_term interval_primary:

interval_primary

::= value_expression_primary interval_qualifier?

| interval_value_function

referenced by: interval_factor time_zone_specifier interval_value_expression_1:

interval_value_expression_1

::= interval_value_expression

referenced by: interval_value_expression interval_term_1:

interval_term_1

::= interval_term

referenced by: interval_value_expression interval_term_2:

interval_term_2

::= interval_term

referenced by: interval_term interval_value_function:

interval_value_function

::= interval_absolute_value_function

referenced by: interval_primary interval_absolute_value_function:

interval_absolute_value_function

::= 'ABS*' '(' interval_value_expression ')'

referenced by: interval_value_function boolean_value_expression:

boolean_value_expression

::= boolean_term ( 'OR' boolean_term )*

referenced by: contextually_typed_row_value_constructor parenthesized_boolean_value_expression row_value_constructor search_condition value_expression boolean_term:

boolean_term

::= boolean_factor ( 'AND' boolean_factor )*

referenced by: boolean_value_expression boolean_factor:

boolean_factor

::= 'NOT'? boolean_test

referenced by: boolean_term boolean_test:

boolean_test

::= boolean_primary ( 'IS' 'NOT'? truth_value )?

referenced by: boolean_factor truth_value:

truth_value

::= 'TRUE'

| 'FALSE'

| 'UNKNOWN'

referenced by: boolean_test boolean_primary:

boolean_primary

::= predicate

| boolean_predicand

referenced by: boolean_test boolean_predicand:

boolean_predicand

::= parenthesized_boolean_value_expression

| nonparenthesized_value_expression_primary

referenced by: boolean_primary row_value_constructor_predicand parenthesized_boolean_value_expression:

parenthesized_boolean_value_expression

::= '(' boolean_value_expression ')'

referenced by: boolean_predicand array_value_expression:

array_value_expression

::= array_concatenation

| array_factor

referenced by: array_element_reference array_value_expression_1 collection_value_expression array_concatenation:

array_concatenation

::= array_value_expression_1 '||' array_factor

referenced by: array_value_expression array_value_expression_1:

array_value_expression_1

::= array_value_expression

referenced by: array_concatenation array_factor:

array_factor

::= value_expression_primary

referenced by: array_concatenation array_value_expression array_value_constructor:

array_value_constructor

::= array_value_constructor_by_enumeration

| array_value_constructor_by_query

referenced by: collection_value_constructor array_value_constructor_by_enumeration:

array_value_constructor_by_enumeration

::= 'ARRAY' left_bracket_or_trigraph array_element_list right_bracket_or_trigraph

referenced by: array_value_constructor array_element_list:

array_element_list

::= array_element ( ',' array_element )*

referenced by: array_value_constructor_by_enumeration array_element:

array_element

::= value_expression

referenced by: array_element_list array_value_constructor_by_query:

array_value_constructor_by_query

::= 'ARRAY' '(' query_expression order_by_clause? ')'

referenced by: array_value_constructor multiset_value_expression:

multiset_value_expression

::= multiset_term ( 'MULTISET' ( 'UNION' | 'EXCEPT' ) ( 'ALL' | 'DISTINCT' )? multiset_term )*

referenced by: collection_value_expression member_predicate_part_2 multiset_element_reference multiset_set_function submultiset_predicate_part_2 multiset_term:

multiset_term

::= multiset_primary ( 'MULTISET' 'INTERSECT' ( 'ALL' | 'DISTINCT' )? multiset_primary )*

referenced by: multiset_value_expression multiset_primary:

multiset_primary

::= multiset_value_function

| value_expression_primary

referenced by: multiset_term multiset_value_function:

multiset_value_function

::= multiset_set_function

referenced by: multiset_primary multiset_set_function:

multiset_set_function

::= 'SET' '(' multiset_value_expression ')'

referenced by: multiset_value_function multiset_value_constructor:

multiset_value_constructor

::= multiset_value_constructor_by_enumeration

| multiset_value_constructor_by_query

| table_value_constructor_by_query

referenced by: collection_value_constructor multiset_value_constructor_by_enumeration:

multiset_value_constructor_by_enumeration

::= 'MULTISET' left_bracket_or_trigraph multiset_element_list right_bracket_or_trigraph

referenced by: multiset_value_constructor multiset_element_list:

multiset_element_list

::= multiset_element ( ',' multiset_element )*

referenced by: multiset_value_constructor_by_enumeration multiset_element:

multiset_element

::= value_expression

referenced by: multiset_element_list multiset_value_constructor_by_query:

multiset_value_constructor_by_query

::= 'MULTISET' '(' query_expression ')'

referenced by: multiset_value_constructor table_value_constructor_by_query:

table_value_constructor_by_query

::= 'TABLE' '(' query_expression ')'

referenced by: multiset_value_constructor row_value_constructor:

row_value_constructor

::= common_value_expression

| boolean_value_expression

| explicit_row_value_constructor

referenced by: table_row_value_expression explicit_row_value_constructor:

explicit_row_value_constructor

::= ( '(' row_value_constructor_element ',' | 'ROW' '(' ) row_value_constructor_element_list ')'

| row_subquery

referenced by: row_value_constructor row_value_constructor_predicand row_value_expression row_value_constructor_element_list:

row_value_constructor_element_list

::= row_value_constructor_element ( ',' row_value_constructor_element )*

referenced by: explicit_row_value_constructor row_value_constructor_element:

row_value_constructor_element

::= value_expression

referenced by: explicit_row_value_constructor row_value_constructor_element_list contextually_typed_row_value_constructor:

contextually_typed_row_value_constructor

::= common_value_expression

| boolean_value_expression

| contextually_typed_value_specification

| ( '(' contextually_typed_row_value_constructor_element ',' | 'ROW' '(' ) contextually_typed_row_value_constructor_element_list ')'

referenced by: contextually_typed_row_value_expression contextually_typed_row_value_constructor_element_list:

contextually_typed_row_value_constructor_element_list

::= contextually_typed_row_value_constructor_element ( ',' contextually_typed_row_value_constructor_element )*

referenced by: contextually_typed_row_value_constructor contextually_typed_row_value_constructor_element:

contextually_typed_row_value_constructor_element

::= value_expression

| contextually_typed_value_specification

referenced by: contextually_typed_row_value_constructor contextually_typed_row_value_constructor_element_list row_value_constructor_predicand:

row_value_constructor_predicand

::= common_value_expression

| boolean_predicand

| explicit_row_value_constructor

referenced by: row_value_predicand row_value_expression:

row_value_expression

::= row_value_special_case

| explicit_row_value_constructor

referenced by: in_value_list value_expression table_row_value_expression:

table_row_value_expression

::= row_value_special_case

| row_value_constructor

referenced by: row_value_expression_list contextually_typed_row_value_expression:

contextually_typed_row_value_expression

::= row_value_special_case

| contextually_typed_row_value_constructor

referenced by: assigned_row contextually_typed_row_value_expression_list row_value_predicand:

row_value_predicand

::= row_value_special_case

| row_value_constructor_predicand

referenced by: between_predicate between_predicate_part_2 case_operand character_like_predicate comparison_predicate comparison_predicate_part_2 in_predicate match_predicate member_predicate null_predicate octet_like_predicate quantified_comparison_predicate row_value_predicand_1 row_value_predicand_2 row_value_predicand_3 row_value_predicand_4 set_predicate similar_predicate submultiset_predicate type_predicate when_operand row_value_special_case:

row_value_special_case

::= nonparenthesized_value_expression_primary