******************** Supported SQL Syntax ******************** The EBNF and Railroad Diagrams for the supported SQL Syntax. ====================================================================================================================== CompilationUnit ====================================================================================================================== .. raw:: html direct_SQL_statement EOF
         ::= direct_SQL_statement* EOF
Not referenced by any.
====================================================================================================================== non_reserved_word ====================================================================================================================== .. raw:: html A ABSOLUTE ACTION ADA ADD ADMIN AFTER ALWAYS ASC ASSERTION ASSIGNMENT ATTRIBUTE ATTRIBUTES BEFORE BERNOULLI BREADTH C CASCADE CATALOG CATALOG_NAME CHAIN CHARACTER_SET_CATALOG CHARACTER_SET_NAME CHARACTER_SET_SCHEMA CHARACTERISTICS CHARACTERS CLASS_ORIGIN COBOL COLLATION COLLATION_CATALOG COLLATION_NAME COLLATION_SCHEMA COLUMN_NAME COMMAND_FUNCTION COMMAND_FUNCTION_CODE COMMITTED CONDITION_NUMBER CONNECTION CONNECTION_NAME CONSTRAINT_CATALOG CONSTRAINT_NAME CONSTRAINT_SCHEMA CONSTRAINTS CONSTRUCTOR CONTAINS CONTINUE CURSOR_NAME DATA DATETIME_INTERVAL_CODE DATETIME_INTERVAL_PRECISION DEFAULTS DEFERRABLE DEFERRED DEFINED DEFINER DEGREE DEPTH DERIVED DESC DESCRIPTOR DIAGNOSTICS DISPATCH DOMAIN DYNAMIC_FUNCTION DYNAMIC_FUNCTION_CODE ENFORCED EQUALS EXCLUDE EXCLUDING EXPRESSION FINAL FIRST FLAG FOLLOWING FORTRAN FOUND G GENERAL GENERATED GO GOTO GRANTED HIERARCHY IF IGNORE IMMEDIATE IMPLEMENTATION INCLUDING INCREMENT INITIALLY INPUT INSTANCE INSTANTIABLE INSTEAD INVOKER ISOLATION K KEY KEY_MEMBER KEY_TYPE LAST LENGTH LEVEL LOCATOR M MAP MATCHED MAXVALUE MESSAGE_LENGTH MESSAGE_OCTET_LENGTH MESSAGE_TEXT MINVALUE MORE MUMPS NAMES NESTING NEXT NFC NFD NFKC NFKD NORMALIZED NULLABLE NULLS NUMBER OBJECT OCTETS OPTION OPTIONS ORDERING ORDINALITY OTHERS OUTPUT OVERRIDING P PAD PARAMETER_MODE PARAMETER_NAME PARAMETER_ORDINAL_POSITION PARAMETER_SPECIFIC_CATALOG PARAMETER_SPECIFIC_NAME PARAMETER_SPECIFIC_SCHEMA PARTIAL PASCAL PATH PLACING PLI PRECEDING PRESERVE PRIOR PRIVILEGES PROPERTIES PUBLIC READ RELATIVE REPEATABLE RESPECT RESTART RESTRICT RETURNED_CARDINALITY RETURNED_LENGTH RETURNED_OCTET_LENGTH RETURNED_SQLSTATE ROLE ROUTINE ROUTINE_CATALOG ROUTINE_NAME ROUTINE_SCHEMA ROW_COUNT 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 STATE STATEMENT STRUCTURE STYLE SUBCLASS_ORIGIN T TABLE_NAME TEMPORARY TIES TOP_LEVEL_COUNT TRANSACTION TRANSACTION_ACTIVE TRANSACTIONS_COMMITTED TRANSACTIONS_ROLLED_BACK TRANSFORM TRANSFORMS TRIGGER_CATALOG TRIGGER_NAME TRIGGER_SCHEMA TRY_CAST 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 ABS ALL ARRAY_AGG AT AVG BLOB BOTH CARDINALITY CLOSE COLUMN CONDITION COUNT CUBE CURRENT CURRENT_CATALOG CURRENT_DATE CURRENT_DEFAULT_TRANSFORM_GROUP CURRENT_PATH CURRENT_ROLE CURRENT_SCHEMA CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TRANSFORM_GROUP_FOR_TYPE CURRENT_USER CURSOR CYCLE DATE DAY DAYS DEC DYNAMIC EXP EXTERNAL FILTER FLOOR FREE FUNCTION GLOBAL HOLD HOUR HOURS IDENTITY INDICATOR INTERSECTION INTERVAL LANGUAGE LEAD LOCAL LOWER MAX MERGE METHOD MIN MINUTE MINUTES MOD MODULE MONTH MONTHS NAME NEW NONE OCCURRENCE OFFSET OLD OPEN PARTITION POSITION POWER PRECISION RANGE RANK READS REF REFERENCES RELEASE RESULT RETURNS ROLLUP ROW ROW_NUMBER ROWS SAVEPOINT SCOPE SEARCH SECOND SECONDS SESSION_USER SQL START STATIC SUM SYSTEM TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TRIGGER TRUNCATE UNKNOWN UPDATE UPPER USER VALUE VALUES VERSION VERSIONS WINDOW YEAR YEARS COMMENT DEFAULT USE LIMIT NUMERIC_HISTOGRAM REPLACE HISTOGRAM APPROEX_PERCENTILE MAP_AGG SET_AGG MAP_UNION "COUNT"
         ::= 'A'
           | 'ABSOLUTE'
           | 'ACTION'
           | 'ADA'
           | 'ADD'
           | 'ADMIN'
           | 'AFTER'
           | 'ALWAYS'
           | 'ASC'
           | 'ASSERTION'
           | 'ASSIGNMENT'
           | 'ATTRIBUTE'
           | 'ATTRIBUTES'
           | 'BEFORE'
           | 'BERNOULLI'
           | 'BREADTH'
           | 'C'
           | 'CASCADE'
           | 'CATALOG'
           | 'CATALOG_NAME'
           | 'CHAIN'
           | 'CHARACTER_SET_CATALOG'
           | 'CHARACTER_SET_NAME'
           | 'CHARACTER_SET_SCHEMA'
           | 'CHARACTERISTICS'
           | 'CHARACTERS'
           | 'CLASS_ORIGIN'
           | 'COBOL'
           | 'COLLATION'
           | 'COLLATION_CATALOG'
           | 'COLLATION_NAME'
           | 'COLLATION_SCHEMA'
           | 'COLUMN_NAME'
           | 'COMMAND_FUNCTION'
           | 'COMMAND_FUNCTION_CODE'
           | 'COMMITTED'
           | 'CONDITION_NUMBER'
           | 'CONNECTION'
           | 'CONNECTION_NAME'
           | 'CONSTRAINT_CATALOG'
           | 'CONSTRAINT_NAME'
           | 'CONSTRAINT_SCHEMA'
           | 'CONSTRAINTS'
           | 'CONSTRUCTOR'
           | 'CONTAINS'
           | 'CONTINUE'
           | 'CURSOR_NAME'
           | 'DATA'
           | 'DATETIME_INTERVAL_CODE'
           | 'DATETIME_INTERVAL_PRECISION'
           | 'DEFAULTS'
           | 'DEFERRABLE'
           | 'DEFERRED'
           | 'DEFINED'
           | 'DEFINER'
           | 'DEGREE'
           | 'DEPTH'
           | 'DERIVED'
           | 'DESC'
           | 'DESCRIPTOR'
           | 'DIAGNOSTICS'
           | 'DISPATCH'
           | 'DOMAIN'
           | 'DYNAMIC_FUNCTION'
           | 'DYNAMIC_FUNCTION_CODE'
           | 'ENFORCED'
           | 'EQUALS'
           | 'EXCLUDE'
           | 'EXCLUDING'
           | 'EXPRESSION'
           | 'FINAL'
           | 'FIRST'
           | 'FLAG'
           | 'FOLLOWING'
           | 'FORTRAN'
           | 'FOUND'
           | 'G'
           | 'GENERAL'
           | 'GENERATED'
           | 'GO'
           | 'GOTO'
           | 'GRANTED'
           | 'HIERARCHY'
           | 'IF'
           | 'IGNORE'
           | 'IMMEDIATE'
           | 'IMPLEMENTATION'
           | 'INCLUDING'
           | 'INCREMENT'
           | 'INITIALLY'
           | 'INPUT'
           | 'INSTANCE'
           | 'INSTANTIABLE'
           | 'INSTEAD'
           | 'INVOKER'
           | 'ISOLATION'
           | 'K'
           | 'KEY'
           | 'KEY_MEMBER'
           | 'KEY_TYPE'
           | 'LAST'
           | 'LENGTH'
           | 'LEVEL'
           | 'LOCATOR'
           | 'M'
           | 'MAP'
           | 'MATCHED'
           | 'MAXVALUE'
           | 'MESSAGE_LENGTH'
           | 'MESSAGE_OCTET_LENGTH'
           | 'MESSAGE_TEXT'
           | 'MINVALUE'
           | 'MORE'
           | 'MUMPS'
           | 'NAMES'
           | 'NESTING'
           | 'NEXT'
           | 'NFC'
           | 'NFD'
           | 'NFKC'
           | 'NFKD'
           | 'NORMALIZED'
           | 'NULLABLE'
           | 'NULLS'
           | 'NUMBER'
           | 'OBJECT'
           | 'OCTETS'
           | 'OPTION'
           | 'OPTIONS'
           | 'ORDERING'
           | 'ORDINALITY'
           | 'OTHERS'
           | 'OUTPUT'
           | 'OVERRIDING'
           | 'P'
           | 'PAD'
           | 'PARAMETER_MODE'
           | 'PARAMETER_NAME'
           | 'PARAMETER_ORDINAL_POSITION'
           | 'PARAMETER_SPECIFIC_CATALOG'
           | 'PARAMETER_SPECIFIC_NAME'
           | 'PARAMETER_SPECIFIC_SCHEMA'
           | 'PARTIAL'
           | 'PASCAL'
           | 'PATH'
           | 'PLACING'
           | 'PLI'
           | 'PRECEDING'
           | 'PRESERVE'
           | 'PRIOR'
           | 'PRIVILEGES'
           | 'PROPERTIES'
           | 'PUBLIC'
           | 'READ'
           | 'RELATIVE'
           | 'REPEATABLE'
           | 'RESPECT'
           | 'RESTART'
           | 'RESTRICT'
           | 'RETURNED_CARDINALITY'
           | 'RETURNED_LENGTH'
           | 'RETURNED_OCTET_LENGTH'
           | 'RETURNED_SQLSTATE'
           | 'ROLE'
           | 'ROUTINE'
           | 'ROUTINE_CATALOG'
           | 'ROUTINE_NAME'
           | 'ROUTINE_SCHEMA'
           | 'ROW_COUNT'
           | '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'
           | 'STATE'
           | 'STATEMENT'
           | 'STRUCTURE'
           | 'STYLE'
           | 'SUBCLASS_ORIGIN'
           | 'T'
           | 'TABLE_NAME'
           | 'TEMPORARY'
           | 'TIES'
           | 'TOP_LEVEL_COUNT'
           | 'TRANSACTION'
           | 'TRANSACTION_ACTIVE'
           | 'TRANSACTIONS_COMMITTED'
           | 'TRANSACTIONS_ROLLED_BACK'
           | 'TRANSFORM'
           | 'TRANSFORMS'
           | 'TRIGGER_CATALOG'
           | 'TRIGGER_NAME'
           | 'TRIGGER_SCHEMA'
           | 'TRY_CAST'
           | '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'
           | 'ABS'
           | 'ALL'
           | 'ARRAY_AGG'
           | 'AT'
           | 'AVG'
           | 'BLOB'
           | 'BOTH'
           | 'CARDINALITY'
           | 'CLOSE'
           | 'COLUMN'
           | 'CONDITION'
           | 'COUNT'
           | 'CUBE'
           | 'CURRENT'
           | 'CURRENT_CATALOG'
           | 'CURRENT_DATE'
           | 'CURRENT_DEFAULT_TRANSFORM_GROUP'
           | 'CURRENT_PATH'
           | 'CURRENT_ROLE'
           | 'CURRENT_SCHEMA'
           | 'CURRENT_TIME'
           | 'CURRENT_TIMESTAMP'
           | 'CURRENT_TRANSFORM_GROUP_FOR_TYPE'
           | 'CURRENT_USER'
           | 'CURSOR'
           | 'CYCLE'
           | 'DATE'
           | 'DAY'
           | 'DAYS'
           | 'DEC'
           | 'DYNAMIC'
           | 'EXP'
           | 'EXTERNAL'
           | 'FILTER'
           | 'FLOOR'
           | 'FREE'
           | 'FUNCTION'
           | 'GLOBAL'
           | 'HOLD'
           | 'HOUR'
           | 'HOURS'
           | 'IDENTITY'
           | 'INDICATOR'
           | 'INTERSECTION'
           | 'INTERVAL'
           | 'LANGUAGE'
           | 'LEAD'
           | 'LOCAL'
           | 'LOWER'
           | 'MAX'
           | 'MERGE'
           | 'METHOD'
           | 'MIN'
           | 'MINUTE'
           | 'MINUTES'
           | 'MOD'
           | 'MODULE'
           | 'MONTH'
           | 'MONTHS'
           | 'NAME'
           | 'NEW'
           | 'NONE'
           | 'OCCURRENCE'
           | 'OFFSET'
           | 'OLD'
           | 'OPEN'
           | 'PARTITION'
           | 'POSITION'
           | 'POWER'
           | 'PRECISION'
           | 'RANGE'
           | 'RANK'
           | 'READS'
           | 'REF'
           | 'REFERENCES'
           | 'RELEASE'
           | 'RESULT'
           | 'RETURNS'
           | 'ROLLUP'
           | 'ROW'
           | 'ROW_NUMBER'
           | 'ROWS'
           | 'SAVEPOINT'
           | 'SCOPE'
           | 'SEARCH'
           | 'SECOND'
           | 'SECONDS'
           | 'SESSION_USER'
           | 'SQL'
           | 'START'
           | 'STATIC'
           | 'SUM'
           | 'SYSTEM'
           | 'TIME'
           | 'TIMESTAMP'
           | 'TIMEZONE_HOUR'
           | 'TIMEZONE_MINUTE'
           | 'TRIGGER'
           | 'TRUNCATE'
           | 'UNKNOWN'
           | 'UPDATE'
           | 'UPPER'
           | 'USER'
           | 'VALUE'
           | 'VALUES'
           | 'VERSION'
           | 'VERSIONS'
           | 'WINDOW'
           | 'YEAR'
           | 'YEARS'
           | 'COMMENT'
           | 'DEFAULT'
           | 'USE'
           | 'LIMIT'
           | 'NUMERIC_HISTOGRAM'
           | 'REPLACE'
           | 'HISTOGRAM'
           | 'APPROEX_PERCENTILE'
           | 'MAP_AGG'
           | 'SET_AGG'
           | 'MAP_UNION'
           | '"COUNT"'
Referenced by:
====================================================================================================================== left_bracket_or_trigraph ====================================================================================================================== .. raw:: html [ ??(
         ::= '['
           | '??('
Referenced by:
====================================================================================================================== right_bracket_or_trigraph ====================================================================================================================== .. raw:: html ] ??)
         ::= ']'
           | '??)'
Referenced by:
====================================================================================================================== literal ====================================================================================================================== .. raw:: html signed_numeric_literal general_literal
           | general_literal
Referenced by:
====================================================================================================================== signed_numeric_literal ====================================================================================================================== .. raw:: html + - unsigned_numeric_literal
         ::= ( '+' | '-' )? unsigned_numeric_literal
Referenced by:
====================================================================================================================== unsigned_literal ====================================================================================================================== .. raw:: html unsigned_numeric_literal general_literal
         ::= unsigned_numeric_literal
           | general_literal
Referenced by:
====================================================================================================================== unsigned_numeric_literal ====================================================================================================================== .. raw:: html exact_numeric_literal approximate_numeric_literal
         ::= exact_numeric_literal
           | approximate_numeric_literal
Referenced by:
====================================================================================================================== exact_numeric_literal ====================================================================================================================== .. raw:: html unsigned_integer float_literal
         ::= unsigned_integer
           | float_literal
Referenced by:
====================================================================================================================== general_literal ====================================================================================================================== .. raw:: html character_string_literal national_character_string_literal Unicode_character_string_literal binary_string_literal datetime_literal interval_literal boolean_literal
         ::= character_string_literal
           | national_character_string_literal
           | Unicode_character_string_literal
           | binary_string_literal
           | datetime_literal
           | interval_literal
           | boolean_literal
Referenced by:
====================================================================================================================== character_string_literal ====================================================================================================================== .. raw:: html _ character_set_specification quoted_string
         ::= ( '_' character_set_specification )? quoted_string+
Referenced by:
====================================================================================================================== Unicode_character_string_literal ====================================================================================================================== .. raw:: html _ character_set_specification unicode_literal
         ::= ( '_' character_set_specification )? unicode_literal
Referenced by:
====================================================================================================================== datetime_literal ====================================================================================================================== .. raw:: html date_literal time_literal timestamp_literal
         ::= date_literal
           | time_literal
           | timestamp_literal
Referenced by:
====================================================================================================================== date_literal ====================================================================================================================== .. raw:: html DATE character_string_literal
         ::= 'DATE' character_string_literal
Referenced by:
====================================================================================================================== time_literal ====================================================================================================================== .. raw:: html TIME character_string_literal
         ::= 'TIME' character_string_literal
Referenced by:
====================================================================================================================== timestamp_literal ====================================================================================================================== .. raw:: html TIMESTAMP character_string_literal
         ::= 'TIMESTAMP' character_string_literal
Referenced by:
====================================================================================================================== interval_literal ====================================================================================================================== .. raw:: html INTERVAL + - character_string_literal interval_qualifier
         ::= 'INTERVAL' ( '+' | '-' )? character_string_literal interval_qualifier
Referenced by:
====================================================================================================================== boolean_literal ====================================================================================================================== .. raw:: html TRUE FALSE UNKNOWN
         ::= 'TRUE'
           | 'FALSE'
           | 'UNKNOWN'
Referenced by:
====================================================================================================================== identifier ====================================================================================================================== .. raw:: html actual_identifier _ identifier_suffix_chain
         ::= ( actual_identifier | '_' ) identifier_suffix_chain?
Referenced by:
====================================================================================================================== actual_identifier ====================================================================================================================== .. raw:: html regular_identifier delimited_identifier Unicode_delimited_identifier non_reserved_word
         ::= regular_identifier
           | delimited_identifier
           | Unicode_delimited_identifier
           | non_reserved_word
Referenced by:
====================================================================================================================== table_name ====================================================================================================================== .. raw:: html identifier_chain
         ::= identifier_chain
Referenced by:
====================================================================================================================== schema_name ====================================================================================================================== .. raw:: html identifier_chain
         ::= identifier_chain
Referenced by:
====================================================================================================================== catalog_name ====================================================================================================================== .. raw:: html identifier
         ::= identifier
Not referenced by any.
====================================================================================================================== schema_qualified_name ====================================================================================================================== .. raw:: html identifier_chain
         ::= identifier_chain
Referenced by:
====================================================================================================================== local_or_schema_qualified_name ====================================================================================================================== .. raw:: html identifier_chain
         ::= identifier_chain
Not referenced by any.
====================================================================================================================== local_or_schema_qualifier ====================================================================================================================== .. raw:: html MODULE schema_name
         ::= 'MODULE'
           | schema_name
Not referenced by any.
====================================================================================================================== cursor_name ====================================================================================================================== .. raw:: html identifier_chain
         ::= identifier_chain
Referenced by:
====================================================================================================================== host_parameter_name ====================================================================================================================== .. raw:: html : identifier
         ::= ':' identifier
Referenced by:
====================================================================================================================== external_routine_name ====================================================================================================================== .. raw:: html identifier character_string_literal
         ::= identifier
           | character_string_literal
Referenced by:
====================================================================================================================== character_set_name ====================================================================================================================== .. raw:: html schema_name . SQL_language_identifier
         ::= ( schema_name '.' )? SQL_language_identifier
Referenced by:
====================================================================================================================== schema_resolved_user_defined_type_name ====================================================================================================================== .. raw:: html user_defined_type_name
         ::= user_defined_type_name
Referenced by:
====================================================================================================================== user_defined_type_name ====================================================================================================================== .. raw:: html identifier_chain
         ::= identifier_chain
Referenced by:
====================================================================================================================== SQL_identifier ====================================================================================================================== .. raw:: html identifier extended_identifier
         ::= identifier
           | extended_identifier
Referenced by:
====================================================================================================================== extended_identifier ====================================================================================================================== .. raw:: html scope_option simple_value_specification
Referenced by:
====================================================================================================================== dynamic_cursor_name ====================================================================================================================== .. raw:: html cursor_name extended_cursor_name
         ::= cursor_name
           | extended_cursor_name
Referenced by:
====================================================================================================================== extended_cursor_name ====================================================================================================================== .. raw:: html scope_option simple_value_specification
Referenced by:
====================================================================================================================== descriptor_name ====================================================================================================================== .. raw:: html identifier extended_descriptor_name
         ::= identifier
           | extended_descriptor_name
Referenced by:
====================================================================================================================== extended_descriptor_name ====================================================================================================================== .. raw:: html scope_option simple_value_specification
Referenced by:
====================================================================================================================== scope_option ====================================================================================================================== .. raw:: html GLOBAL LOCAL
         ::= 'GLOBAL'
           | 'LOCAL'
Referenced by:
====================================================================================================================== data_type ====================================================================================================================== .. raw:: html predefined_type row_type reference_type presto_generic_type path_resolved_user_defined_type_name collection_type
Referenced by:
====================================================================================================================== predefined_type ====================================================================================================================== .. raw:: html character_string_type CHARACTER SET character_set_specification national_character_string_type collate_clause binary_string_type numeric_type BOOLEAN datetime_type interval_type
           | binary_string_type
           | numeric_type
           | 'BOOLEAN'
           | datetime_type
           | interval_type
Referenced by:
====================================================================================================================== character_string_type ====================================================================================================================== .. raw:: html CHARACTER CHAR VARYING ( character_length ) VARCHAR ( character_length ) character_large_object_type
         ::= ( 'CHARACTER' | 'CHAR' ) ( 'VARYING'? '(' character_length ')' )?
           | 'VARCHAR' ( '(' character_length ')' )?
           | character_large_object_type
Referenced by:
====================================================================================================================== character_large_object_type ====================================================================================================================== .. raw:: html CHARACTER CHAR LARGE OBJECT CLOB ( character_large_object_length )
         ::= ( ( 'CHARACTER' | 'CHAR' ) 'LARGE' 'OBJECT' | 'CLOB' ) ( '(' character_large_object_length ')' )?
Referenced by:
====================================================================================================================== national_character_string_type ====================================================================================================================== .. raw:: html NATIONAL CHARACTER CHAR NCHAR VARYING ( character_length ) national_character_large_object_type
         ::= ( 'NATIONAL' ( 'CHARACTER' | 'CHAR' ) | 'NCHAR' ) ( 'VARYING'? '(' character_length ')' )?
           | national_character_large_object_type
Referenced by:
====================================================================================================================== national_character_large_object_type ====================================================================================================================== .. raw:: html NATIONAL CHARACTER NCHAR LARGE OBJECT NCLOB ( character_large_object_length )
         ::= ( ( 'NATIONAL' 'CHARACTER' | 'NCHAR' ) 'LARGE' 'OBJECT' | 'NCLOB' ) ( '(' character_large_object_length ')' )?
Referenced by:
====================================================================================================================== binary_string_type ====================================================================================================================== .. raw:: html BINARY VARYING ( unsigned_integer ) VARBINARY ( unsigned_integer ) binary_large_object_string_type
         ::= 'BINARY' ( 'VARYING'? '(' unsigned_integer ')' )?
           | 'VARBINARY' ( '(' unsigned_integer ')' )?
           | binary_large_object_string_type
Referenced by:
====================================================================================================================== binary_large_object_string_type ====================================================================================================================== .. raw:: html BINARY LARGE OBJECT BLOB ( large_object_length )
         ::= ( 'BINARY' 'LARGE' 'OBJECT' | 'BLOB' ) ( '(' large_object_length ')' )?
Referenced by:
====================================================================================================================== numeric_type ====================================================================================================================== .. raw:: html exact_numeric_type approximate_numeric_type
         ::= exact_numeric_type
           | approximate_numeric_type
Referenced by:
====================================================================================================================== exact_numeric_type ====================================================================================================================== .. raw:: html NUMERIC DECIMAL DEC ( unsigned_integer , unsigned_integer ) SMALLINT INTEGER INT BIGINT
         ::= ( 'NUMERIC' | 'DECIMAL' | 'DEC' ) ( '(' unsigned_integer ( ',' unsigned_integer )? ')' )?
           | 'SMALLINT'
           | 'INTEGER'
           | 'INT'
           | 'BIGINT'
Referenced by:
====================================================================================================================== approximate_numeric_type ====================================================================================================================== .. raw:: html FLOAT ( unsigned_integer ) REAL DOUBLE PRECISION
         ::= 'FLOAT' ( '(' unsigned_integer ')' )?
           | 'REAL'
           | 'DOUBLE' 'PRECISION'?
Referenced by:
====================================================================================================================== character_length ====================================================================================================================== .. raw:: html unsigned_integer char_length_units
         ::= unsigned_integer char_length_units?
Referenced by:
====================================================================================================================== large_object_length ====================================================================================================================== .. raw:: html unsigned_integer multiplier large_object_length_token
         ::= unsigned_integer multiplier?
           | large_object_length_token
Referenced by:
====================================================================================================================== character_large_object_length ====================================================================================================================== .. raw:: html large_object_length char_length_units
         ::= large_object_length char_length_units?
Referenced by:
====================================================================================================================== char_length_units ====================================================================================================================== .. raw:: html CHARACTERS OCTETS
         ::= 'CHARACTERS'
           | 'OCTETS'
Referenced by:
====================================================================================================================== datetime_type ====================================================================================================================== .. raw:: html DATE TIME TIMESTAMP ( unsigned_integer ) with_or_without_time_zone
         ::= 'DATE'
           | ( 'TIME' | 'TIMESTAMP' ) ( '(' unsigned_integer ')' )? with_or_without_time_zone?
Referenced by:
====================================================================================================================== with_or_without_time_zone ====================================================================================================================== .. raw:: html WITH WITHOUT TIME ZONE
         ::= ( 'WITH' | 'WITHOUT' ) 'TIME' 'ZONE'
Referenced by:
====================================================================================================================== interval_type ====================================================================================================================== .. raw:: html INTERVAL interval_qualifier
         ::= 'INTERVAL' interval_qualifier
Referenced by:
====================================================================================================================== row_type ====================================================================================================================== .. raw:: html ROW row_type_body
Referenced by:
====================================================================================================================== row_type_body ====================================================================================================================== .. raw:: html ( field_definition , )
         ::= '(' field_definition ( ',' field_definition )* ')'
Referenced by:
====================================================================================================================== reference_type ====================================================================================================================== .. raw:: html REF ( referenced_type ) scope_clause
         ::= 'REF' '(' referenced_type ')' scope_clause?
Referenced by:
====================================================================================================================== scope_clause ====================================================================================================================== .. raw:: html SCOPE table_name
         ::= 'SCOPE' table_name
Referenced by:
====================================================================================================================== referenced_type ====================================================================================================================== .. raw:: html path_resolved_user_defined_type_name
Referenced by:
====================================================================================================================== path_resolved_user_defined_type_name ====================================================================================================================== .. raw:: html user_defined_type_name
         ::= user_defined_type_name
Referenced by:
====================================================================================================================== collection_type ====================================================================================================================== .. raw:: html array_type MULTISET
         ::= array_type
           | 'MULTISET'
Referenced by:
====================================================================================================================== array_type ====================================================================================================================== .. raw:: html ARRAY left_bracket_or_trigraph unsigned_integer right_bracket_or_trigraph
Referenced by:
====================================================================================================================== field_definition ====================================================================================================================== .. raw:: html identifier data_type
         ::= identifier data_type
Referenced by:
====================================================================================================================== value_expression_primary ====================================================================================================================== .. raw:: html parenthesized_value_expression nonparenthesized_value_expression_primary
         ::= parenthesized_value_expression
Referenced by:
====================================================================================================================== parenthesized_value_expression ====================================================================================================================== .. raw:: html ( value_expression , ) primary_suffix
         ::= '(' value_expression ( ',' value_expression )* ')' primary_suffix*
Referenced by:
====================================================================================================================== nonparenthesized_value_expression_primary ====================================================================================================================== .. raw:: html set_function_specification subquery case_expression cast_specification subtype_treatment new_specification reference_resolution collection_value_constructor multiset_element_reference next_value_expression window_function_type ( column_name_list ) unsigned_value_specification column_reference primary_suffix contextually_typed_value_specification
Referenced by:
====================================================================================================================== primary_suffix ====================================================================================================================== .. raw:: html field_reference attribute_or_method_reference method_invocation window_function array_element_reference static_method_invocation
         ::= field_reference
           | attribute_or_method_reference
           | method_invocation
           | window_function
           | array_element_reference
           | static_method_invocation
Referenced by:
====================================================================================================================== collection_value_constructor ====================================================================================================================== .. raw:: html array_value_constructor multiset_value_constructor
         ::= array_value_constructor
           | multiset_value_constructor
Referenced by:
====================================================================================================================== value_specification ====================================================================================================================== .. raw:: html literal general_value_specification
         ::= literal
           | general_value_specification
Referenced by:
====================================================================================================================== unsigned_value_specification ====================================================================================================================== .. raw:: html unsigned_literal general_value_specification
         ::= unsigned_literal
           | general_value_specification
Referenced by:
====================================================================================================================== general_value_specification ====================================================================================================================== .. raw:: html identifier_chain CURRENT_USER USER ? host_parameter_name current_collation_specification SESSION_USER SYSTEM_USER CURRENT_CATALOG CURRENT_PATH CURRENT_ROLE CURRENT_SCHEMA VALUE CURRENT_DEFAULT_TRANSFORM_GROUP CURRENT_TRANSFORM_GROUP_FOR_TYPE path_resolved_user_defined_type_name
         ::= identifier_chain
           | 'CURRENT_USER'
           | 'USER'
           | '?'
           | host_parameter_name
           | current_collation_specification
           | 'SESSION_USER'
           | 'SYSTEM_USER'
           | 'CURRENT_CATALOG'
           | 'CURRENT_PATH'
           | 'CURRENT_ROLE'
           | 'CURRENT_SCHEMA'
           | 'VALUE'
           | 'CURRENT_DEFAULT_TRANSFORM_GROUP'
           | 'CURRENT_TRANSFORM_GROUP_FOR_TYPE' path_resolved_user_defined_type_name
Referenced by:
====================================================================================================================== simple_value_specification ====================================================================================================================== .. raw:: html literal identifier_chain host_parameter_name
         ::= literal
           | identifier_chain
           | host_parameter_name
Referenced by:
====================================================================================================================== target_specification ====================================================================================================================== .. raw:: html identifier_chain column_reference target_array_element_specification ?
Referenced by:
====================================================================================================================== simple_target_specification ====================================================================================================================== .. raw:: html identifier_chain column_reference
         ::= identifier_chain
           | column_reference
Referenced by:
====================================================================================================================== target_array_element_specification ====================================================================================================================== .. raw:: html left_bracket_or_trigraph simple_value_specification right_bracket_or_trigraph
Referenced by:
====================================================================================================================== current_collation_specification ====================================================================================================================== .. raw:: html COLLATION FOR ( string_value_expression )
         ::= 'COLLATION' 'FOR' '(' string_value_expression ')'
Referenced by:
====================================================================================================================== contextually_typed_value_specification ====================================================================================================================== .. raw:: html implicitly_typed_value_specification DEFAULT
           | 'DEFAULT'
Referenced by:
====================================================================================================================== implicitly_typed_value_specification ====================================================================================================================== .. raw:: html NULL empty_specification
         ::= 'NULL'
           | empty_specification
Referenced by:
====================================================================================================================== empty_specification ====================================================================================================================== .. raw:: html ARRAY MULTISET left_bracket_or_trigraph right_bracket_or_trigraph
         ::= ( 'ARRAY' | 'MULTISET' ) left_bracket_or_trigraph right_bracket_or_trigraph
Referenced by:
====================================================================================================================== identifier_chain ====================================================================================================================== .. raw:: html identifier .
         ::= identifier ( '.' identifier )*
Referenced by:
====================================================================================================================== column_reference ====================================================================================================================== .. raw:: html identifier_chain MODULE . identifier . identifier
         ::= identifier_chain
           | 'MODULE' '.' identifier '.' identifier
Referenced by:
====================================================================================================================== set_function_specification ====================================================================================================================== .. raw:: html aggregate_function grouping_operation
         ::= aggregate_function
           | grouping_operation
Referenced by:
====================================================================================================================== grouping_operation ====================================================================================================================== .. raw:: html GROUPING ( column_reference , )
         ::= 'GROUPING' '(' column_reference ( ',' column_reference )* ')'
Referenced by:
====================================================================================================================== window_function ====================================================================================================================== .. raw:: html OVER window_name_or_specification
         ::= 'OVER' window_name_or_specification
Referenced by:
====================================================================================================================== window_function_type ====================================================================================================================== .. raw:: html rank_function_type ROW_NUMBER ( ) aggregate_function ntile_function lead_or_lag_function first_or_last_value_function nth_value_function
         ::= ( rank_function_type | 'ROW_NUMBER' ) '(' ')'
           | aggregate_function
           | ntile_function
           | lead_or_lag_function
           | first_or_last_value_function
           | nth_value_function
Referenced by:
====================================================================================================================== rank_function_type ====================================================================================================================== .. raw:: html RANK DENSE_RANK PERCENT_RANK CUME_DIST
         ::= 'RANK'
           | 'DENSE_RANK'
           | 'PERCENT_RANK'
           | 'CUME_DIST'
Referenced by:
====================================================================================================================== ntile_function ====================================================================================================================== .. raw:: html NTILE ( number_of_tiles )
         ::= 'NTILE' '(' number_of_tiles ')'
Referenced by:
====================================================================================================================== number_of_tiles ====================================================================================================================== .. raw:: html value_expression ?
         ::= value_expression
           | '?'
Referenced by:
====================================================================================================================== lead_or_lag_function ====================================================================================================================== .. raw:: html lead_or_lag ( value_expression , value_expression , value_expression ) null_treatment
         ::= lead_or_lag '(' value_expression ( ',' value_expression ( ',' value_expression )? )? ')' null_treatment?
Referenced by:
====================================================================================================================== lead_or_lag ====================================================================================================================== .. raw:: html LEAD LAG
         ::= 'LEAD'
           | 'LAG'
Referenced by:
====================================================================================================================== null_treatment ====================================================================================================================== .. raw:: html RESPECT IGNORE NULLS
         ::= ( 'RESPECT' | 'IGNORE' ) 'NULLS'
Referenced by:
====================================================================================================================== first_or_last_value_function ====================================================================================================================== .. raw:: html first_or_last_value ( value_expression ) null_treatment
         ::= first_or_last_value '(' value_expression ')' null_treatment?
Referenced by:
====================================================================================================================== first_or_last_value ====================================================================================================================== .. raw:: html FIRST_VALUE LAST_VALUE
         ::= 'FIRST_VALUE'
           | 'LAST_VALUE'
Referenced by:
====================================================================================================================== nth_value_function ====================================================================================================================== .. raw:: html NTH_VALUE ( value_expression , nth_row ) from_first_or_last null_treatment
         ::= 'NTH_VALUE' '(' value_expression ',' nth_row ')' from_first_or_last? null_treatment?
Referenced by:
====================================================================================================================== nth_row ====================================================================================================================== .. raw:: html simple_value_specification ?
           | '?'
Referenced by:
====================================================================================================================== from_first_or_last ====================================================================================================================== .. raw:: html FROM FIRST LAST
         ::= 'FROM' ( 'FIRST' | 'LAST' )
Referenced by:
====================================================================================================================== window_name_or_specification ====================================================================================================================== .. raw:: html in_line_window_specification identifier
         ::= in_line_window_specification
           | identifier
Referenced by:
====================================================================================================================== in_line_window_specification ====================================================================================================================== .. raw:: html window_specification
         ::= window_specification
Referenced by:
====================================================================================================================== case_expression ====================================================================================================================== .. raw:: html case_abbreviation case_specification
         ::= case_abbreviation
           | case_specification
Referenced by:
====================================================================================================================== case_abbreviation ====================================================================================================================== .. raw:: html NULLIF ( value_expression , COALESCE ( value_expression , value_expression )
         ::= ( 'NULLIF' '(' value_expression ',' | 'COALESCE' '(' ( value_expression ',' )+ ) value_expression ')'
Referenced by:
====================================================================================================================== case_specification ====================================================================================================================== .. raw:: html simple_case searched_case
         ::= simple_case
           | searched_case
Referenced by:
====================================================================================================================== simple_case ====================================================================================================================== .. raw:: html CASE case_operand simple_when_clause else_clause END
         ::= 'CASE' case_operand simple_when_clause+ else_clause? 'END'
Referenced by:
====================================================================================================================== searched_case ====================================================================================================================== .. raw:: html CASE searched_when_clause else_clause END
         ::= 'CASE' searched_when_clause+ else_clause? 'END'
Referenced by:
====================================================================================================================== simple_when_clause ====================================================================================================================== .. raw:: html WHEN when_operand_list THEN result
         ::= 'WHEN' when_operand_list 'THEN' result
Referenced by:
====================================================================================================================== searched_when_clause ====================================================================================================================== .. raw:: html WHEN search_condition THEN result
         ::= 'WHEN' search_condition 'THEN' result
Referenced by:
====================================================================================================================== else_clause ====================================================================================================================== .. raw:: html ELSE result
         ::= 'ELSE' result
Referenced by:
====================================================================================================================== case_operand ====================================================================================================================== .. raw:: html row_value_predicand overlaps_predicate_part_1
         ::= row_value_predicand
           | overlaps_predicate_part_1
Referenced by:
====================================================================================================================== when_operand_list ====================================================================================================================== .. raw:: html when_operand ,
         ::= when_operand ( ',' when_operand )*
Referenced by:
====================================================================================================================== when_operand ====================================================================================================================== .. raw:: html 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
         ::= 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
           | 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:
====================================================================================================================== result ====================================================================================================================== .. raw:: html value_expression NULL
           | 'NULL'
Referenced by:
====================================================================================================================== cast_specification ====================================================================================================================== .. raw:: html CAST ( cast_operand AS cast_target ) try_cast
         ::= 'CAST' '(' cast_operand 'AS' cast_target ')'
           | try_cast
Referenced by:
====================================================================================================================== cast_operand ====================================================================================================================== .. raw:: html value_expression implicitly_typed_value_specification
         ::= value_expression
           | implicitly_typed_value_specification
Referenced by:
====================================================================================================================== cast_target ====================================================================================================================== .. raw:: html data_type schema_qualified_name
         ::= data_type
           | schema_qualified_name
Referenced by:
====================================================================================================================== next_value_expression ====================================================================================================================== .. raw:: html NEXT VALUE FOR schema_qualified_name
         ::= 'NEXT' 'VALUE' 'FOR' schema_qualified_name
Referenced by:
====================================================================================================================== field_reference ====================================================================================================================== .. raw:: html . identifier
         ::= '.' identifier
Referenced by:
====================================================================================================================== subtype_treatment ====================================================================================================================== .. raw:: html TREAT ( value_expression AS target_subtype )
         ::= 'TREAT' '(' value_expression 'AS' target_subtype ')'
Referenced by:
====================================================================================================================== target_subtype ====================================================================================================================== .. raw:: html path_resolved_user_defined_type_name reference_type
           | reference_type
Referenced by:
====================================================================================================================== method_invocation ====================================================================================================================== .. raw:: html direct_invocation udaf_filter generalized_invocation
         ::= direct_invocation udaf_filter?
           | generalized_invocation
Referenced by:
====================================================================================================================== direct_invocation ====================================================================================================================== .. raw:: html SQL_argument_list
         ::= SQL_argument_list
Referenced by:
====================================================================================================================== generalized_invocation ====================================================================================================================== .. raw:: html . identifier SQL_argument_list
         ::= '.' identifier SQL_argument_list?
Referenced by:
====================================================================================================================== static_method_invocation ====================================================================================================================== .. raw:: html :: identifier SQL_argument_list
         ::= '::' identifier SQL_argument_list?
Referenced by:
====================================================================================================================== new_specification ====================================================================================================================== .. raw:: html NEW path_resolved_user_defined_type_name SQL_argument_list
Referenced by:
====================================================================================================================== new_invocation ====================================================================================================================== .. raw:: html method_invocation routine_invocation
         ::= method_invocation
           | routine_invocation
Not referenced by any.
====================================================================================================================== attribute_or_method_reference ====================================================================================================================== .. raw:: html lambda_body
         ::= lambda_body
Referenced by:
====================================================================================================================== dereference_operation ====================================================================================================================== .. raw:: html reference_value_expression -> identifier
         ::= reference_value_expression '->' identifier
Not referenced by any.
====================================================================================================================== reference_resolution ====================================================================================================================== .. raw:: html DEREF ( reference_value_expression )
         ::= 'DEREF' '(' reference_value_expression ')'
Referenced by:
====================================================================================================================== array_element_reference ====================================================================================================================== .. raw:: html left_bracket_or_trigraph value_expression right_bracket_or_trigraph
Referenced by:
====================================================================================================================== multiset_element_reference ====================================================================================================================== .. raw:: html ELEMENT ( multiset_value_expression )
         ::= 'ELEMENT' '(' multiset_value_expression ')'
Referenced by:
====================================================================================================================== value_expression ====================================================================================================================== .. raw:: html boolean_value_expression common_value_expression row_value_expression
         ::= boolean_value_expression
           | common_value_expression
           | row_value_expression
Referenced by:
====================================================================================================================== common_value_expression ====================================================================================================================== .. raw:: html numeric_value_expression string_value_expression datetime_value_expression interval_value_expression user_defined_type_value_expression reference_value_expression collection_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:
====================================================================================================================== user_defined_type_value_expression ====================================================================================================================== .. raw:: html value_expression_primary
         ::= value_expression_primary
Referenced by:
====================================================================================================================== reference_value_expression ====================================================================================================================== .. raw:: html value_expression_primary
         ::= value_expression_primary
Referenced by:
====================================================================================================================== collection_value_expression ====================================================================================================================== .. raw:: html array_value_expression multiset_value_expression
         ::= array_value_expression
           | multiset_value_expression
Referenced by:
====================================================================================================================== numeric_value_expression ====================================================================================================================== .. raw:: html term + -
         ::= term ( ( '+' | '-' ) term )*
Referenced by:
====================================================================================================================== term ====================================================================================================================== .. raw:: html factor * / %
term     ::= factor ( ( '*' | '/' | '%' ) factor )*
Referenced by:
====================================================================================================================== factor ====================================================================================================================== .. raw:: html + - numeric_primary
factor   ::= ( '+' | '-' )? numeric_primary
Referenced by:
====================================================================================================================== numeric_primary ====================================================================================================================== .. raw:: html numeric_value_function character_value_expression
         ::= numeric_value_function
           | character_value_expression
Referenced by:
====================================================================================================================== numeric_value_function ====================================================================================================================== .. raw:: html position_expression regex_occurrences_function regex_position_expression extract_expression length_expression cardinality_expression max_cardinality_expression absolute_value_expression modulus_expression natural_logarithm exponential_function power_function square_root floor_function ceiling_function width_bucket_function
         ::= position_expression
           | regex_occurrences_function
           | regex_position_expression
           | extract_expression
           | length_expression
           | cardinality_expression
           | max_cardinality_expression
           | absolute_value_expression
           | modulus_expression
           | natural_logarithm
           | exponential_function
           | power_function
           | square_root
           | floor_function
           | ceiling_function
           | width_bucket_function
Referenced by:
====================================================================================================================== position_expression ====================================================================================================================== .. raw:: html character_position_expression binary_position_expression
         ::= character_position_expression
           | binary_position_expression
Referenced by:
====================================================================================================================== regex_occurrences_function ====================================================================================================================== .. raw:: html OCCURRENCES_REGEX ( character_value_expression FLAG character_value_expression IN character_value_expression FROM numeric_value_expression USING char_length_units )
         ::= 'OCCURRENCES_REGEX' '(' character_value_expression ( 'FLAG' character_value_expression )? 'IN' character_value_expression ( 'FROM' numeric_value_expression )? ( 'USING' char_length_units )? ')'
Referenced by:
====================================================================================================================== regex_position_expression ====================================================================================================================== .. raw:: html POSITION_REGEX ( regex_position_start_or_after character_value_expression FLAG character_value_expression IN character_value_expression FROM numeric_value_expression USING char_length_units OCCURRENCE numeric_value_expression GROUP numeric_value_expression )
Referenced by:
====================================================================================================================== regex_position_start_or_after ====================================================================================================================== .. raw:: html START AFTER
         ::= 'START'
           | 'AFTER'
Referenced by:
====================================================================================================================== character_position_expression ====================================================================================================================== .. raw:: html POSITION ( character_value_expression IN character_value_expression USING char_length_units )
         ::= 'POSITION' '(' character_value_expression 'IN' character_value_expression ( 'USING' char_length_units )? ')'
Referenced by:
====================================================================================================================== binary_position_expression ====================================================================================================================== .. raw:: html POSITION ( binary_value_expression IN binary_value_expression )
         ::= 'POSITION' '(' binary_value_expression 'IN' binary_value_expression ')'
Referenced by:
====================================================================================================================== length_expression ====================================================================================================================== .. raw:: html char_length_expression octet_length_expression
         ::= char_length_expression
           | octet_length_expression
Referenced by:
====================================================================================================================== char_length_expression ====================================================================================================================== .. raw:: html CHAR_LENGTH CHARACTER_LENGTH ( character_value_expression USING char_length_units )
         ::= ( 'CHAR_LENGTH' | 'CHARACTER_LENGTH' ) '(' character_value_expression ( 'USING' char_length_units )? ')'
Referenced by:
====================================================================================================================== octet_length_expression ====================================================================================================================== .. raw:: html OCTET_LENGTH ( string_value_expression )
         ::= 'OCTET_LENGTH' '(' string_value_expression ')'
Referenced by:
====================================================================================================================== extract_expression ====================================================================================================================== .. raw:: html EXTRACT ( extract_field FROM extract_source )
         ::= 'EXTRACT' '(' extract_field 'FROM' extract_source ')'
Referenced by:
====================================================================================================================== extract_field ====================================================================================================================== .. raw:: html primary_datetime_field time_zone_field
         ::= primary_datetime_field
           | time_zone_field
Referenced by:
====================================================================================================================== time_zone_field ====================================================================================================================== .. raw:: html TIMEZONE_HOUR TIMEZONE_MINUTE
         ::= 'TIMEZONE_HOUR'
           | 'TIMEZONE_MINUTE'
Referenced by:
====================================================================================================================== extract_source ====================================================================================================================== .. raw:: html datetime_value_expression interval_value_expression
         ::= datetime_value_expression
           | interval_value_expression
Referenced by:
====================================================================================================================== cardinality_expression ====================================================================================================================== .. raw:: html CARDINALITY ( collection_value_expression )
         ::= 'CARDINALITY' '(' collection_value_expression ')'
Referenced by:
====================================================================================================================== max_cardinality_expression ====================================================================================================================== .. raw:: html MAX_CARDINALITY ( array_value_expression )
         ::= 'MAX_CARDINALITY' '(' array_value_expression ')'
Referenced by:
====================================================================================================================== absolute_value_expression ====================================================================================================================== .. raw:: html ABS ( numeric_value_expression )
         ::= 'ABS' '(' numeric_value_expression ')'
Referenced by:
====================================================================================================================== modulus_expression ====================================================================================================================== .. raw:: html MOD ( numeric_value_expression , numeric_value_expression )
         ::= 'MOD' '(' numeric_value_expression ',' numeric_value_expression ')'
Referenced by:
====================================================================================================================== natural_logarithm ====================================================================================================================== .. raw:: html LN ( numeric_value_expression )
         ::= 'LN' '(' numeric_value_expression ')'
Referenced by:
====================================================================================================================== exponential_function ====================================================================================================================== .. raw:: html EXP ( numeric_value_expression )
         ::= 'EXP' '(' numeric_value_expression ')'
Referenced by:
====================================================================================================================== power_function ====================================================================================================================== .. raw:: html POWER ( numeric_value_expression , numeric_value_expression )
         ::= 'POWER' '(' numeric_value_expression ',' numeric_value_expression ')'
Referenced by:
====================================================================================================================== square_root ====================================================================================================================== .. raw:: html SQRT ( numeric_value_expression )
         ::= 'SQRT' '(' numeric_value_expression ')'
Referenced by:
====================================================================================================================== floor_function ====================================================================================================================== .. raw:: html FLOOR ( numeric_value_expression )
         ::= 'FLOOR' '(' numeric_value_expression ')'
Referenced by:
====================================================================================================================== ceiling_function ====================================================================================================================== .. raw:: html CEIL CEILING ( numeric_value_expression )
         ::= ( 'CEIL' | 'CEILING' ) '(' numeric_value_expression ')'
Referenced by:
====================================================================================================================== width_bucket_function ====================================================================================================================== .. raw:: html WIDTH_BUCKET ( numeric_value_expression , numeric_value_expression , numeric_value_expression , numeric_value_expression )
         ::= 'WIDTH_BUCKET' '(' numeric_value_expression ',' numeric_value_expression ( ',' numeric_value_expression ',' numeric_value_expression )? ')'
Referenced by:
====================================================================================================================== string_value_expression ====================================================================================================================== .. raw:: html character_value_expression binary_value_expression
         ::= character_value_expression
           | binary_value_expression
Referenced by:
====================================================================================================================== character_value_expression ====================================================================================================================== .. raw:: html character_factor concatenation
         ::= character_factor concatenation*
Referenced by:
====================================================================================================================== concatenation ====================================================================================================================== .. raw:: html || character_factor
         ::= '||' character_factor
Referenced by:
====================================================================================================================== character_factor ====================================================================================================================== .. raw:: html character_primary collate_clause
         ::= character_primary collate_clause?
Referenced by:
====================================================================================================================== character_primary ====================================================================================================================== .. raw:: html string_value_function binary_value_expression
         ::= string_value_function
           | binary_value_expression
Referenced by:
====================================================================================================================== binary_value_expression ====================================================================================================================== .. raw:: html binary_primary binary_concatenation
         ::= binary_primary binary_concatenation*
Referenced by:
====================================================================================================================== binary_primary ====================================================================================================================== .. raw:: html string_value_function datetime_value_expression
         ::= string_value_function
           | datetime_value_expression
Referenced by:
====================================================================================================================== binary_concatenation ====================================================================================================================== .. raw:: html || binary_primary
         ::= '||' binary_primary
Referenced by:
====================================================================================================================== string_value_function ====================================================================================================================== .. raw:: html character_value_function binary_value_function
         ::= character_value_function
           | binary_value_function
Referenced by:
====================================================================================================================== character_value_function ====================================================================================================================== .. raw:: html 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
         ::= character_substring_function
           | regex_substring_function
           | fold
           | transcoding
           | character_transliteration
           | regex_transliteration
           | trim_function
           | character_overlay_function
           | normalize_function
           | specific_type_method
Referenced by:
====================================================================================================================== character_substring_function ====================================================================================================================== .. raw:: html SUBSTRING ( character_value_expression FROM numeric_value_expression FOR numeric_value_expression USING char_length_units )
         ::= 'SUBSTRING' '(' character_value_expression 'FROM' numeric_value_expression ( 'FOR' numeric_value_expression )? ( 'USING' char_length_units )? ')'
Referenced by:
====================================================================================================================== regular_expression_substring_function ====================================================================================================================== .. raw:: html SUBSTRING ( character_value_expression SIMILAR character_value_expression ESCAPE character_value_expression )
         ::= 'SUBSTRING' '(' character_value_expression 'SIMILAR' character_value_expression 'ESCAPE' character_value_expression ')'
Referenced by:
====================================================================================================================== regex_substring_function ====================================================================================================================== .. raw:: html SUBSTRING_REGEX ( character_value_expression FLAG character_value_expression IN character_value_expression FROM numeric_value_expression USING char_length_units OCCURRENCE numeric_value_expression GROUP numeric_value_expression )
         ::= 'SUBSTRING_REGEX' '(' character_value_expression ( 'FLAG' character_value_expression )? 'IN' character_value_expression ( 'FROM' numeric_value_expression )? ( 'USING' char_length_units )? ( 'OCCURRENCE' numeric_value_expression )? ( 'GROUP' numeric_value_expression )? ')'
Referenced by:
====================================================================================================================== fold ====================================================================================================================== .. raw:: html UPPER LOWER ( character_value_expression )
fold     ::= ( 'UPPER' | 'LOWER' ) '(' character_value_expression ')'
Referenced by:
====================================================================================================================== transcoding ====================================================================================================================== .. raw:: html CONVERT ( character_value_expression USING schema_qualified_name )
         ::= 'CONVERT' '(' character_value_expression 'USING' schema_qualified_name ')'
Referenced by:
====================================================================================================================== character_transliteration ====================================================================================================================== .. raw:: html TRANSLATE ( character_value_expression USING schema_qualified_name )
         ::= 'TRANSLATE' '(' character_value_expression 'USING' schema_qualified_name ')'
Referenced by:
====================================================================================================================== regex_transliteration ====================================================================================================================== .. raw:: html TRANSLATE_REGEX ( character_value_expression FLAG character_value_expression IN character_value_expression WITH character_value_expression FROM numeric_value_expression USING char_length_units OCCURRENCE regex_transliteration_occurrence )
         ::= 'TRANSLATE_REGEX' '(' character_value_expression ( 'FLAG' character_value_expression )? 'IN' character_value_expression ( 'WITH' character_value_expression )? ( 'FROM' numeric_value_expression )? ( 'USING' char_length_units )? ( 'OCCURRENCE' regex_transliteration_occurrence )? ')'
Referenced by:
====================================================================================================================== regex_transliteration_occurrence ====================================================================================================================== .. raw:: html ALL numeric_value_expression
         ::= 'ALL'
           | numeric_value_expression
Referenced by:
====================================================================================================================== trim_function ====================================================================================================================== .. raw:: html TRIM ( trim_operands )
         ::= 'TRIM' '(' trim_operands ')'
Referenced by:
====================================================================================================================== trim_operands ====================================================================================================================== .. raw:: html trim_specification character_value_expression , FROM character_value_expression
         ::= trim_specification? character_value_expression ( ( ',' | 'FROM' ) character_value_expression )?
Referenced by:
====================================================================================================================== trim_specification ====================================================================================================================== .. raw:: html LEADING TRAILING BOTH
         ::= 'LEADING'
           | 'TRAILING'
           | 'BOTH'
Referenced by:
====================================================================================================================== character_overlay_function ====================================================================================================================== .. raw:: html OVERLAY ( character_value_expression PLACING character_value_expression FROM numeric_value_expression FOR numeric_value_expression USING char_length_units )
         ::= 'OVERLAY' '(' character_value_expression 'PLACING' character_value_expression 'FROM' numeric_value_expression ( 'FOR' numeric_value_expression )? ( 'USING' char_length_units )? ')'
Referenced by:
====================================================================================================================== normalize_function ====================================================================================================================== .. raw:: html NORMALIZE ( character_value_expression , normal_form , normalize_function_result_length )
         ::= 'NORMALIZE' '(' character_value_expression ( ',' normal_form ( ',' normalize_function_result_length )? )? ')'
Referenced by:
====================================================================================================================== normal_form ====================================================================================================================== .. raw:: html NFC NFD NFKC NFKD
         ::= 'NFC'
           | 'NFD'
           | 'NFKC'
           | 'NFKD'
Referenced by:
====================================================================================================================== normalize_function_result_length ====================================================================================================================== .. raw:: html character_length character_large_object_length
         ::= character_length
           | character_large_object_length
Referenced by:
====================================================================================================================== specific_type_method ====================================================================================================================== .. raw:: html . SPECIFICTYPE ( )
         ::= '.' 'SPECIFICTYPE' ( '(' ')' )?
Referenced by:
====================================================================================================================== binary_value_function ====================================================================================================================== .. raw:: html binary_substring_function binary_trim_function binary_overlay_function
         ::= binary_substring_function
           | binary_trim_function
           | binary_overlay_function
Referenced by:
====================================================================================================================== binary_substring_function ====================================================================================================================== .. raw:: html SUBSTRING ( binary_value_expression FROM numeric_value_expression FOR numeric_value_expression )
         ::= 'SUBSTRING' '(' binary_value_expression 'FROM' numeric_value_expression ( 'FOR' numeric_value_expression )? ')'
Referenced by:
====================================================================================================================== binary_trim_function ====================================================================================================================== .. raw:: html TRIM ( binary_trim_operands )
         ::= 'TRIM' '(' binary_trim_operands ')'
Referenced by:
====================================================================================================================== binary_trim_operands ====================================================================================================================== .. raw:: html trim_specification binary_value_expression , FROM binary_value_expression
         ::= trim_specification? binary_value_expression ( ( ',' | 'FROM' ) binary_value_expression )?
Referenced by:
====================================================================================================================== binary_overlay_function ====================================================================================================================== .. raw:: html OVERLAY ( binary_value_expression PLACING binary_value_expression FROM numeric_value_expression FOR numeric_value_expression )
         ::= 'OVERLAY' '(' binary_value_expression 'PLACING' binary_value_expression 'FROM' numeric_value_expression ( 'FOR' numeric_value_expression )? ')'
Referenced by:
====================================================================================================================== datetime_value_expression ====================================================================================================================== .. raw:: html datetime_term interval_value_expression
         ::= datetime_term
           | interval_value_expression
Referenced by:
====================================================================================================================== datetime_term ====================================================================================================================== .. raw:: html datetime_factor
         ::= datetime_factor
Referenced by:
====================================================================================================================== datetime_factor ====================================================================================================================== .. raw:: html datetime_primary time_zone
         ::= datetime_primary time_zone?
Referenced by:
====================================================================================================================== datetime_primary ====================================================================================================================== .. raw:: html datetime_value_function interval_value_expression
         ::= datetime_value_function
           | interval_value_expression
Referenced by:
====================================================================================================================== time_zone ====================================================================================================================== .. raw:: html AT time_zone_specifier
         ::= 'AT' time_zone_specifier
Referenced by:
====================================================================================================================== time_zone_specifier ====================================================================================================================== .. raw:: html LOCAL TIME ZONE interval_primary
         ::= 'LOCAL'
           | 'TIME' 'ZONE' interval_primary
Referenced by:
====================================================================================================================== datetime_value_function ====================================================================================================================== .. raw:: html CURRENT_DATE current_time_value_function current_timestamp_value_function current_local_time_value_function current_local_timestamp_value_function
         ::= 'CURRENT_DATE'
           | current_time_value_function
           | current_timestamp_value_function
           | current_local_time_value_function
Referenced by:
====================================================================================================================== current_time_value_function ====================================================================================================================== .. raw:: html CURRENT_TIME ( unsigned_integer )
         ::= 'CURRENT_TIME' ( '(' unsigned_integer ')' )?
Referenced by:
====================================================================================================================== current_local_time_value_function ====================================================================================================================== .. raw:: html LOCALTIME ( unsigned_integer )
         ::= 'LOCALTIME' ( '(' unsigned_integer ')' )?
Referenced by:
====================================================================================================================== current_timestamp_value_function ====================================================================================================================== .. raw:: html CURRENT_TIMESTAMP ( unsigned_integer )
         ::= 'CURRENT_TIMESTAMP' ( '(' unsigned_integer ')' )?
Referenced by:
====================================================================================================================== current_local_timestamp_value_function ====================================================================================================================== .. raw:: html LOCALTIMESTAMP ( unsigned_integer )
         ::= 'LOCALTIMESTAMP' ( '(' unsigned_integer ')' )?
Referenced by:
====================================================================================================================== interval_value_expression ====================================================================================================================== .. raw:: html interval_term ( datetime_value_expression - datetime_term ) interval_qualifier
         ::= interval_term
           | '(' datetime_value_expression '-' datetime_term ')' interval_qualifier
Referenced by:
====================================================================================================================== interval_term ====================================================================================================================== .. raw:: html interval_factor * / factor
         ::= interval_factor ( ( '*' | '/' ) factor )?
Referenced by:
====================================================================================================================== interval_factor ====================================================================================================================== .. raw:: html + - interval_primary
         ::= ( '+' | '-' )? interval_primary
Referenced by:
====================================================================================================================== interval_primary ====================================================================================================================== .. raw:: html interval_value_function array_value_expression interval_qualifier
         ::= interval_value_function
Referenced by:
====================================================================================================================== interval_value_function ====================================================================================================================== .. raw:: html interval_absolute_value_function
         ::= interval_absolute_value_function
Referenced by:
====================================================================================================================== interval_absolute_value_function ====================================================================================================================== .. raw:: html ABS ( interval_value_expression )
         ::= 'ABS' '(' interval_value_expression ')'
Referenced by:
====================================================================================================================== boolean_value_expression ====================================================================================================================== .. raw:: html boolean_term OR
         ::= boolean_term ( 'OR' boolean_term )*
Referenced by:
====================================================================================================================== boolean_term ====================================================================================================================== .. raw:: html boolean_factor AND
         ::= boolean_factor ( 'AND' boolean_factor )*
Referenced by:
====================================================================================================================== boolean_factor ====================================================================================================================== .. raw:: html NOT boolean_test
         ::= 'NOT'? boolean_test
Referenced by:
====================================================================================================================== boolean_test ====================================================================================================================== .. raw:: html boolean_primary IS NOT truth_value
         ::= boolean_primary ( 'IS' 'NOT'? truth_value )?
Referenced by:
====================================================================================================================== truth_value ====================================================================================================================== .. raw:: html TRUE FALSE UNKNOWN
         ::= 'TRUE'
           | 'FALSE'
           | 'UNKNOWN'
Referenced by:
====================================================================================================================== boolean_primary ====================================================================================================================== .. raw:: html predicate boolean_predicand
         ::= predicate
           | boolean_predicand
Referenced by:
====================================================================================================================== boolean_predicand ====================================================================================================================== .. raw:: html parenthesized_boolean_value_expression numeric_value_expression
           | numeric_value_expression
Referenced by:
====================================================================================================================== parenthesized_boolean_value_expression ====================================================================================================================== .. raw:: html ( boolean_value_expression )
         ::= '(' boolean_value_expression ')'
Referenced by:
====================================================================================================================== array_value_expression ====================================================================================================================== .. raw:: html array_primary ||
         ::= array_primary ( '||' array_primary )*
Referenced by:
====================================================================================================================== array_value_expression_1 ====================================================================================================================== .. raw:: html array_value_expression
         ::= array_value_expression
Not referenced by any.
====================================================================================================================== array_primary ====================================================================================================================== .. raw:: html array_value_function multiset_value_expression
         ::= array_value_function
           | multiset_value_expression
Referenced by:
====================================================================================================================== array_value_function ====================================================================================================================== .. raw:: html trim_array_function
         ::= trim_array_function
Referenced by:
====================================================================================================================== trim_array_function ====================================================================================================================== .. raw:: html TRIM_ARRAY ( array_value_expression , numeric_value_expression )
         ::= 'TRIM_ARRAY' '(' array_value_expression ',' numeric_value_expression ')'
Referenced by:
====================================================================================================================== array_value_constructor ====================================================================================================================== .. raw:: html array_value_constructor_by_enumeration array_value_constructor_by_query
           | array_value_constructor_by_query
Referenced by:
====================================================================================================================== array_value_constructor_by_enumeration ====================================================================================================================== .. raw:: html ARRAY left_bracket_or_trigraph array_element_list right_bracket_or_trigraph
Referenced by:
====================================================================================================================== array_element_list ====================================================================================================================== .. raw:: html array_element ,
         ::= array_element ( ',' array_element )*
Referenced by:
====================================================================================================================== array_element ====================================================================================================================== .. raw:: html value_expression
         ::= value_expression
Referenced by:
====================================================================================================================== array_value_constructor_by_query ====================================================================================================================== .. raw:: html ARRAY subquery
         ::= 'ARRAY' subquery
Referenced by:
====================================================================================================================== multiset_value_expression ====================================================================================================================== .. raw:: html multiset_term MULTISET UNION EXCEPT ALL DISTINCT multiset_term
         ::= multiset_term ( 'MULTISET' ( 'UNION' | 'EXCEPT' ) ( 'ALL' | 'DISTINCT' )? multiset_term )?
Referenced by:
====================================================================================================================== multiset_term ====================================================================================================================== .. raw:: html multiset_primary MULTISET INTERSECT ALL DISTINCT multiset_primary
         ::= multiset_primary ( 'MULTISET' 'INTERSECT' ( 'ALL' | 'DISTINCT' )? multiset_primary )?
Referenced by:
====================================================================================================================== multiset_primary ====================================================================================================================== .. raw:: html multiset_set_function value_expression_primary
         ::= multiset_set_function
           | value_expression_primary
Referenced by:
====================================================================================================================== multiset_set_function ====================================================================================================================== .. raw:: html SET ( multiset_value_expression )
         ::= 'SET' '(' multiset_value_expression ')'
Referenced by:
====================================================================================================================== multiset_value_constructor ====================================================================================================================== .. raw:: html multiset_value_constructor_by_enumeration multiset_value_constructor_by_query table_value_constructor_by_query
           | multiset_value_constructor_by_query
           | table_value_constructor_by_query
Referenced by:
====================================================================================================================== multiset_value_constructor_by_enumeration ====================================================================================================================== .. raw:: html MULTISET left_bracket_or_trigraph multiset_element_list right_bracket_or_trigraph
Referenced by:
====================================================================================================================== multiset_element_list ====================================================================================================================== .. raw:: html multiset_element ,
         ::= multiset_element ( ',' multiset_element )*
Referenced by:
====================================================================================================================== multiset_element ====================================================================================================================== .. raw:: html value_expression
         ::= value_expression
Referenced by:
====================================================================================================================== multiset_value_constructor_by_query ====================================================================================================================== .. raw:: html MULTISET subquery
         ::= 'MULTISET' subquery
Referenced by:
====================================================================================================================== table_value_constructor_by_query ====================================================================================================================== .. raw:: html TABLE subquery
         ::= 'TABLE' subquery
Referenced by:
====================================================================================================================== row_value_constructor ====================================================================================================================== .. raw:: html explicit_row_value_constructor common_value_expression boolean_value_expression
         ::= explicit_row_value_constructor
           | common_value_expression
           | boolean_value_expression
Referenced by:
====================================================================================================================== explicit_row_value_constructor ====================================================================================================================== .. raw:: html ROW ( row_value_constructor_element_list ( row_value_constructor_element , row_value_constructor_element_list ) subquery
           | subquery
Referenced by:
====================================================================================================================== row_value_constructor_element_list ====================================================================================================================== .. raw:: html row_value_constructor_element ,
Referenced by:
====================================================================================================================== row_value_constructor_element ====================================================================================================================== .. raw:: html value_expression
         ::= value_expression
Referenced by:
====================================================================================================================== contextually_typed_row_value_constructor ====================================================================================================================== .. raw:: html common_value_expression boolean_value_expression contextually_typed_value_specification ( contextually_typed_value_specification contextually_typed_row_value_constructor_element , contextually_typed_row_value_constructor_element_list ROW ( contextually_typed_row_value_constructor_element_list )
         ::= common_value_expression
           | boolean_value_expression
Referenced by:
====================================================================================================================== contextually_typed_row_value_constructor_element_list ====================================================================================================================== .. raw:: html contextually_typed_row_value_constructor_element ,
Referenced by:
====================================================================================================================== contextually_typed_row_value_constructor_element ====================================================================================================================== .. raw:: html contextually_typed_value_specification
Referenced by:
====================================================================================================================== row_value_constructor_predicand ====================================================================================================================== .. raw:: html common_value_expression explicit_row_value_constructor
         ::= common_value_expression
           | explicit_row_value_constructor
Referenced by:
====================================================================================================================== row_value_expression ====================================================================================================================== .. raw:: html explicit_row_value_constructor row_value_special_case
         ::= explicit_row_value_constructor
           | row_value_special_case
Referenced by:
====================================================================================================================== table_row_value_expression ====================================================================================================================== .. raw:: html row_value_constructor row_value_special_case
         ::= row_value_constructor
           | row_value_special_case
Referenced by:
====================================================================================================================== contextually_typed_row_value_expression ====================================================================================================================== .. raw:: html contextually_typed_row_value_constructor row_value_special_case
           | row_value_special_case
Referenced by:
====================================================================================================================== row_value_predicand ====================================================================================================================== .. raw:: html row_value_constructor_predicand row_value_special_case
         ::= row_value_constructor_predicand
           | row_value_special_case
Referenced by:
====================================================================================================================== row_value_special_case ====================================================================================================================== .. raw:: html common_value_expression nonparenthesized_value_expression_primary
         ::= common_value_expression
Referenced by:
====================================================================================================================== table_value_constructor ====================================================================================================================== .. raw:: html VALUES row_value_expression_list
         ::= 'VALUES' row_value_expression_list
Referenced by:
====================================================================================================================== row_value_expression_list ====================================================================================================================== .. raw:: html table_row_value_expression ,
Referenced by:
====================================================================================================================== contextually_typed_table_value_constructor ====================================================================================================================== .. raw:: html VALUES contextually_typed_row_value_expression_list
         ::= 'VALUES' contextually_typed_row_value_expression_list
Referenced by:
====================================================================================================================== contextually_typed_row_value_expression_list ====================================================================================================================== .. raw:: html contextually_typed_row_value_expression ,
Referenced by:
====================================================================================================================== table_expression ====================================================================================================================== .. raw:: html from_clause where_clause group_by_clause having_clause window_clause
Referenced by:
====================================================================================================================== from_clause ====================================================================================================================== .. raw:: html FROM table_reference_list
         ::= 'FROM' table_reference_list
Referenced by:
====================================================================================================================== table_reference_list ====================================================================================================================== .. raw:: html table_reference ,
         ::= table_reference ( ',' table_reference )*
Referenced by:
====================================================================================================================== table_reference ====================================================================================================================== .. raw:: html table_factor joined_table
         ::= table_factor joined_table*
Referenced by:
====================================================================================================================== table_factor ====================================================================================================================== .. raw:: html table_primary sample_clause partitioned_join_table
Referenced by:
====================================================================================================================== sample_clause ====================================================================================================================== .. raw:: html TABLESAMPLE sample_method ( sample_percentage ) repeatable_clause
         ::= 'TABLESAMPLE' sample_method '(' sample_percentage ')' repeatable_clause?
Referenced by:
====================================================================================================================== sample_method ====================================================================================================================== .. raw:: html BERNOULLI SYSTEM
         ::= 'BERNOULLI'
           | 'SYSTEM'
Referenced by:
====================================================================================================================== repeatable_clause ====================================================================================================================== .. raw:: html REPEATABLE ( repeat_argument )
         ::= 'REPEATABLE' '(' repeat_argument ')'
Referenced by:
====================================================================================================================== sample_percentage ====================================================================================================================== .. raw:: html numeric_value_expression
         ::= numeric_value_expression
Referenced by:
====================================================================================================================== repeat_argument ====================================================================================================================== .. raw:: html numeric_value_expression
         ::= numeric_value_expression
Referenced by:
====================================================================================================================== table_primary ====================================================================================================================== .. raw:: html table_or_query_name derived_table parenthesized_joined_table lateral_derived_table collection_derived_table table_function_derived_table only_spec data_change_delta_table alias
Referenced by:
====================================================================================================================== alias ====================================================================================================================== .. raw:: html AS identifier identifier_suffix_chain ( column_name_list )
Referenced by:
====================================================================================================================== system_version_specification ====================================================================================================================== .. raw:: html AS OF SYSTEM TIME VERSIONS BEFORE AFTER SYSTEM TIME BETWEEN ASYMMETRIC SYMMETRIC SYSTEM TIME datetime_value_expression AND datetime_value_expression
         ::= ( 'AS' 'OF' 'SYSTEM' 'TIME' | 'VERSIONS' ( ( 'BEFORE' | 'AFTER' ) 'SYSTEM' 'TIME' | 'BETWEEN' ( 'ASYMMETRIC' | 'SYMMETRIC' )? 'SYSTEM' 'TIME' datetime_value_expression 'AND' ) ) datetime_value_expression
Not referenced by any.
====================================================================================================================== only_spec ====================================================================================================================== .. raw:: html ONLY ( table_or_query_name )
         ::= 'ONLY' '(' table_or_query_name ')'
Referenced by:
====================================================================================================================== lateral_derived_table ====================================================================================================================== .. raw:: html LATERAL subquery
         ::= 'LATERAL' subquery
Referenced by:
====================================================================================================================== collection_derived_table ====================================================================================================================== .. raw:: html UNNEST ( collection_value_expression , ) WITH ORDINALITY
         ::= 'UNNEST' '(' collection_value_expression ( ',' collection_value_expression )* ')' ( 'WITH' 'ORDINALITY' )?
Referenced by:
====================================================================================================================== table_function_derived_table ====================================================================================================================== .. raw:: html TABLE ( collection_value_expression )
         ::= 'TABLE' '(' collection_value_expression ')'
Referenced by:
====================================================================================================================== derived_table ====================================================================================================================== .. raw:: html query_expression subquery
         ::= query_expression
           | subquery
Referenced by:
====================================================================================================================== table_or_query_name ====================================================================================================================== .. raw:: html table_name identifier
         ::= table_name
           | identifier
Referenced by:
====================================================================================================================== column_name_list ====================================================================================================================== .. raw:: html identifier ,
         ::= identifier ( ',' identifier )*
Referenced by:
====================================================================================================================== data_change_delta_table ====================================================================================================================== .. raw:: html result_option TABLE ( data_change_statement )
         ::= result_option 'TABLE' '(' data_change_statement ')'
Referenced by:
====================================================================================================================== data_change_statement ====================================================================================================================== .. raw:: html delete_statement_searched insert_statement merge_statement update_statement_searched
         ::= delete_statement_searched
           | insert_statement
           | merge_statement
           | update_statement_searched
Referenced by:
====================================================================================================================== result_option ====================================================================================================================== .. raw:: html FINAL NEW OLD
         ::= 'FINAL'
           | 'NEW'
           | 'OLD'
Referenced by:
====================================================================================================================== parenthesized_joined_table ====================================================================================================================== .. raw:: html ( table_primary table_reference joined_table )
         ::= '(' ( table_primary | table_reference ) joined_table* ')'
Referenced by:
====================================================================================================================== joined_table ====================================================================================================================== .. raw:: html cross_join qualified_join natural_join
         ::= cross_join
           | qualified_join
           | natural_join
Referenced by:
====================================================================================================================== cross_join ====================================================================================================================== .. raw:: html CROSS JOIN table_factor
         ::= 'CROSS' 'JOIN' table_factor
Referenced by:
====================================================================================================================== qualified_join ====================================================================================================================== .. raw:: html join_type JOIN table_reference partitioned_join_table join_specification
Referenced by:
====================================================================================================================== partitioned_join_table ====================================================================================================================== .. raw:: html PARTITION BY partitioned_join_column_reference_list
         ::= 'PARTITION' 'BY' partitioned_join_column_reference_list
Referenced by:
====================================================================================================================== partitioned_join_column_reference_list ====================================================================================================================== .. raw:: html ( partitioned_join_column_reference , )
Referenced by:
====================================================================================================================== partitioned_join_column_reference ====================================================================================================================== .. raw:: html column_reference
         ::= column_reference
Referenced by:
====================================================================================================================== natural_join ====================================================================================================================== .. raw:: html NATURAL join_type JOIN table_factor partitioned_join_table
         ::= 'NATURAL' join_type? 'JOIN' ( table_factor | partitioned_join_table )
Referenced by:
====================================================================================================================== join_specification ====================================================================================================================== .. raw:: html join_condition named_columns_join
         ::= join_condition
           | named_columns_join
Referenced by:
====================================================================================================================== join_condition ====================================================================================================================== .. raw:: html ON search_condition
         ::= 'ON' search_condition
Referenced by:
====================================================================================================================== named_columns_join ====================================================================================================================== .. raw:: html USING ( join_column_list )
         ::= 'USING' '(' join_column_list ')'
Referenced by:
====================================================================================================================== join_type ====================================================================================================================== .. raw:: html INNER outer_join_type OUTER
         ::= 'INNER'
           | outer_join_type 'OUTER'?
Referenced by:
====================================================================================================================== outer_join_type ====================================================================================================================== .. raw:: html LEFT RIGHT FULL
         ::= 'LEFT'
           | 'RIGHT'
           | 'FULL'
Referenced by:
====================================================================================================================== join_column_list ====================================================================================================================== .. raw:: html column_name_list
         ::= column_name_list
Referenced by:
====================================================================================================================== where_clause ====================================================================================================================== .. raw:: html WHERE search_condition
         ::= 'WHERE' search_condition
Referenced by:
====================================================================================================================== group_by_clause ====================================================================================================================== .. raw:: html GROUP BY set_quantifier grouping_element_list
         ::= 'GROUP' 'BY' set_quantifier? grouping_element_list
Referenced by:
====================================================================================================================== grouping_element_list ====================================================================================================================== .. raw:: html grouping_element ,
         ::= grouping_element ( ',' grouping_element )*
Referenced by:
====================================================================================================================== grouping_element ====================================================================================================================== .. raw:: html rollup_list cube_list grouping_sets_specification empty_grouping_set ordinary_grouping_set
         ::= rollup_list
           | cube_list
           | grouping_sets_specification
           | empty_grouping_set
           | ordinary_grouping_set
Referenced by:
====================================================================================================================== ordinary_grouping_set ====================================================================================================================== .. raw:: html grouping_column_reference ( grouping_column_reference_list )
         ::= grouping_column_reference
           | '(' grouping_column_reference_list ')'
Referenced by:
====================================================================================================================== grouping_column_reference ====================================================================================================================== .. raw:: html grouping_expression column_reference collate_clause
Referenced by:
====================================================================================================================== grouping_column_reference_list ====================================================================================================================== .. raw:: html grouping_column_reference ,
Referenced by:
====================================================================================================================== rollup_list ====================================================================================================================== .. raw:: html ROLLUP ( ordinary_grouping_set_list )
         ::= 'ROLLUP' '(' ordinary_grouping_set_list ')'
Referenced by:
====================================================================================================================== ordinary_grouping_set_list ====================================================================================================================== .. raw:: html ordinary_grouping_set ,
         ::= ordinary_grouping_set ( ',' ordinary_grouping_set )*
Referenced by:
====================================================================================================================== cube_list ====================================================================================================================== .. raw:: html CUBE ( ordinary_grouping_set_list )
         ::= 'CUBE' '(' ordinary_grouping_set_list ')'
Referenced by:
====================================================================================================================== grouping_sets_specification ====================================================================================================================== .. raw:: html GROUPING SETS ( grouping_set_list )
         ::= 'GROUPING' 'SETS' '(' grouping_set_list ')'
Referenced by:
====================================================================================================================== grouping_set_list ====================================================================================================================== .. raw:: html grouping_set ,
         ::= grouping_set ( ',' grouping_set )*
Referenced by:
====================================================================================================================== grouping_set ====================================================================================================================== .. raw:: html rollup_list cube_list grouping_sets_specification empty_grouping_set ordinary_grouping_set
         ::= rollup_list
           | cube_list
           | grouping_sets_specification
           | empty_grouping_set
           | ordinary_grouping_set
Referenced by:
====================================================================================================================== empty_grouping_set ====================================================================================================================== .. raw:: html ( )
         ::= '(' ')'
Referenced by:
====================================================================================================================== having_clause ====================================================================================================================== .. raw:: html HAVING search_condition
         ::= 'HAVING' search_condition
Referenced by:
====================================================================================================================== window_clause ====================================================================================================================== .. raw:: html WINDOW window_definition_list
         ::= 'WINDOW' window_definition_list
Referenced by:
====================================================================================================================== window_definition_list ====================================================================================================================== .. raw:: html window_definition ,
         ::= window_definition ( ',' window_definition )*
Referenced by:
====================================================================================================================== window_definition ====================================================================================================================== .. raw:: html identifier AS window_specification
         ::= identifier 'AS' window_specification
Referenced by:
====================================================================================================================== window_specification ====================================================================================================================== .. raw:: html ( window_specification_details )
         ::= '(' window_specification_details? ')'
Referenced by:
====================================================================================================================== window_specification_details ====================================================================================================================== .. raw:: html window_partition_clause window_order_clause window_frame_clause existing_identifier
Referenced by:
====================================================================================================================== existing_identifier ====================================================================================================================== .. raw:: html identifier
         ::= identifier
Referenced by:
====================================================================================================================== window_partition_clause ====================================================================================================================== .. raw:: html PARTITION BY window_partition_column_reference_list
         ::= 'PARTITION' 'BY' window_partition_column_reference_list
Referenced by:
====================================================================================================================== window_partition_column_reference_list ====================================================================================================================== .. raw:: html window_partition_column_reference ,
Referenced by:
====================================================================================================================== window_partition_column_reference ====================================================================================================================== .. raw:: html value_expression column_reference collate_clause
         ::= ( value_expression | column_reference ) collate_clause?
Referenced by:
====================================================================================================================== window_order_clause ====================================================================================================================== .. raw:: html ORDER BY sort_specification_list
         ::= 'ORDER' 'BY' sort_specification_list
Referenced by:
====================================================================================================================== window_frame_clause ====================================================================================================================== .. raw:: html window_frame_units window_frame_extent window_frame_exclusion
Referenced by:
====================================================================================================================== window_frame_units ====================================================================================================================== .. raw:: html ROWS RANGE
         ::= 'ROWS'
           | 'RANGE'
Referenced by:
====================================================================================================================== window_frame_extent ====================================================================================================================== .. raw:: html window_frame_start window_frame_between
         ::= window_frame_start
           | window_frame_between
Referenced by:
====================================================================================================================== window_frame_start ====================================================================================================================== .. raw:: html UNBOUNDED PRECEDING CURRENT ROW window_frame_preceding
         ::= 'UNBOUNDED' 'PRECEDING'
           | 'CURRENT' 'ROW'
           | window_frame_preceding
Referenced by:
====================================================================================================================== window_frame_preceding ====================================================================================================================== .. raw:: html value_expression PRECEDING
         ::= value_expression 'PRECEDING'
Referenced by:
====================================================================================================================== window_frame_between ====================================================================================================================== .. raw:: html BETWEEN window_frame_bound AND window_frame_bound
         ::= 'BETWEEN' window_frame_bound 'AND' window_frame_bound
Referenced by:
====================================================================================================================== window_frame_bound ====================================================================================================================== .. raw:: html window_frame_start UNBOUNDED FOLLOWING window_frame_following
         ::= window_frame_start
           | 'UNBOUNDED' 'FOLLOWING'
           | window_frame_following
Referenced by:
====================================================================================================================== window_frame_following ====================================================================================================================== .. raw:: html value_expression FOLLOWING
         ::= value_expression 'FOLLOWING'
Referenced by:
====================================================================================================================== window_frame_exclusion ====================================================================================================================== .. raw:: html EXCLUDE CURRENT ROW GROUP TIES NO OTHERS
         ::= 'EXCLUDE' ( 'CURRENT' 'ROW' | 'GROUP' | 'TIES' | 'NO' 'OTHERS' )
Referenced by:
====================================================================================================================== query_specification ====================================================================================================================== .. raw:: html SELECT set_quantifier select_list table_expression
         ::= 'SELECT' set_quantifier? select_list table_expression?
Referenced by:
====================================================================================================================== select_list ====================================================================================================================== .. raw:: html * select_sublist , , * , select_sublist
         ::= ( '*' | select_sublist ( ',' select_sublist )* ( ',' '*' )? ) ( ',' select_sublist )*
Referenced by:
====================================================================================================================== select_sublist ====================================================================================================================== .. raw:: html derived_column . * AS ( all_fields_column_name_list ) as_clause
         ::= derived_column ( '.' '*' ( 'AS' '(' all_fields_column_name_list ')' )? | as_clause )?
Referenced by:
====================================================================================================================== qualified_asterisk ====================================================================================================================== .. raw:: html asterisked_identifier_chain . * all_fields_reference
         ::= asterisked_identifier_chain '.' '*'
           | all_fields_reference
Not referenced by any.
====================================================================================================================== asterisked_identifier_chain ====================================================================================================================== .. raw:: html identifier .
         ::= identifier ( '.' identifier )*
Referenced by:
====================================================================================================================== derived_column ====================================================================================================================== .. raw:: html value_expression as_clause
         ::= value_expression as_clause?
Referenced by:
====================================================================================================================== as_clause ====================================================================================================================== .. raw:: html AS identifier
         ::= 'AS'? identifier
Referenced by:
====================================================================================================================== all_fields_reference ====================================================================================================================== .. raw:: html value_expression_primary . * AS ( all_fields_column_name_list )
         ::= value_expression_primary '.' '*' ( 'AS' '(' all_fields_column_name_list ')' )?
Referenced by:
====================================================================================================================== all_fields_column_name_list ====================================================================================================================== .. raw:: html column_name_list
         ::= column_name_list
Referenced by:
====================================================================================================================== query_expression ====================================================================================================================== .. raw:: html with_clause query_expression_body order_by_clause result_offset_clause fetch_first_clause limit_clause
Referenced by:
====================================================================================================================== with_clause ====================================================================================================================== .. raw:: html WITH RECURSIVE with_list
         ::= 'WITH' 'RECURSIVE'? with_list
Referenced by:
====================================================================================================================== with_list ====================================================================================================================== .. raw:: html with_list_element ,
         ::= with_list_element ( ',' with_list_element )*
Referenced by:
====================================================================================================================== with_list_element ====================================================================================================================== .. raw:: html identifier ( column_name_list ) AS subquery search_or_cycle_clause
         ::= identifier ( '(' column_name_list ')' )? 'AS' subquery search_or_cycle_clause?
Referenced by:
====================================================================================================================== query_expression_body ====================================================================================================================== .. raw:: html query_term corresponding_spec ALL DISTINCT UNION EXCEPT
         ::= query_term ( ( 'UNION' | 'EXCEPT' ) ( 'ALL' | 'DISTINCT' )? corresponding_spec? query_term )*
Referenced by:
====================================================================================================================== query_term ====================================================================================================================== .. raw:: html query_primary corresponding_spec ALL DISTINCT INTERSECT
         ::= query_primary ( 'INTERSECT' ( 'ALL' | 'DISTINCT' )? corresponding_spec? query_primary )*
Referenced by:
====================================================================================================================== query_primary ====================================================================================================================== .. raw:: html ( query_expression_body order_by_clause limit_clause result_offset_clause fetch_first_clause ) simple_table
           | simple_table
Referenced by:
====================================================================================================================== simple_table ====================================================================================================================== .. raw:: html table_value_constructor explicit_table query_specification
         ::= table_value_constructor
           | explicit_table
           | query_specification
Referenced by:
====================================================================================================================== explicit_table ====================================================================================================================== .. raw:: html TABLE table_or_query_name
         ::= 'TABLE' table_or_query_name
Referenced by:
====================================================================================================================== corresponding_spec ====================================================================================================================== .. raw:: html CORRESPONDING BY ( column_name_list )
         ::= 'CORRESPONDING' ( 'BY' '(' column_name_list ')' )?
Referenced by:
====================================================================================================================== order_by_clause ====================================================================================================================== .. raw:: html ORDER BY sort_specification_list
         ::= 'ORDER' 'BY' sort_specification_list
Referenced by:
====================================================================================================================== result_offset_clause ====================================================================================================================== .. raw:: html OFFSET simple_value_specification ROW ROWS
         ::= 'OFFSET' simple_value_specification ( 'ROW' | 'ROWS' )
Referenced by:
====================================================================================================================== fetch_first_clause ====================================================================================================================== .. raw:: html FETCH FIRST NEXT simple_value_specification ROW ROWS ONLY
         ::= 'FETCH' ( 'FIRST' | 'NEXT' ) simple_value_specification? ( 'ROW' | 'ROWS' ) 'ONLY'
Referenced by:
====================================================================================================================== search_or_cycle_clause ====================================================================================================================== .. raw:: html search_clause cycle_clause cycle_clause
         ::= search_clause cycle_clause?
           | cycle_clause
Referenced by:
====================================================================================================================== search_clause ====================================================================================================================== .. raw:: html SEARCH recursive_search_order SET identifier
         ::= 'SEARCH' recursive_search_order 'SET' identifier
Referenced by:
====================================================================================================================== recursive_search_order ====================================================================================================================== .. raw:: html DEPTH BREADTH FIRST BY column_name_list
         ::= ( 'DEPTH' | 'BREADTH' ) 'FIRST' 'BY' column_name_list
Referenced by:
====================================================================================================================== cycle_clause ====================================================================================================================== .. raw:: html CYCLE cycle_column_list SET identifier TO value_expression DEFAULT value_expression USING identifier
         ::= 'CYCLE' cycle_column_list 'SET' identifier 'TO' value_expression 'DEFAULT' value_expression 'USING' identifier
Referenced by:
====================================================================================================================== cycle_column_list ====================================================================================================================== .. raw:: html identifier ,
         ::= identifier ( ',' identifier )*
Referenced by:
====================================================================================================================== subquery ====================================================================================================================== .. raw:: html ( query_expression )
Referenced by:
====================================================================================================================== predicate ====================================================================================================================== .. raw:: html exists_predicate unique_predicate row_value_predicand comparison_predicate between_predicate in_predicate like_predicate similar_predicate regex_like_predicate null_predicate quantified_comparison_predicate normalized_predicate match_predicate overlaps_predicate distinct_predicate member_predicate submultiset_predicate set_predicate type_predicate
         ::= exists_predicate
           | unique_predicate
Referenced by:
====================================================================================================================== comparison_predicate ====================================================================================================================== .. raw:: html comparison_predicate_part_2
         ::= comparison_predicate_part_2
Referenced by:
====================================================================================================================== comparison_predicate_part_2 ====================================================================================================================== .. raw:: html comp_op row_value_predicand
         ::= comp_op row_value_predicand
Referenced by:
====================================================================================================================== comp_op ====================================================================================================================== .. raw:: html = <> < > <= >= !=
comp_op  ::= '='
           | '<>'
           | '<'
           | '>'
           | '<='
           | '>='
           | '!='
Referenced by:
====================================================================================================================== between_predicate ====================================================================================================================== .. raw:: html between_predicate_part_2
         ::= between_predicate_part_2
Referenced by:
====================================================================================================================== between_predicate_part_2 ====================================================================================================================== .. raw:: html NOT BETWEEN ASYMMETRIC SYMMETRIC row_value_predicand AND row_value_predicand
         ::= 'NOT'? 'BETWEEN' ( 'ASYMMETRIC' | 'SYMMETRIC' )? row_value_predicand 'AND' row_value_predicand
Referenced by:
====================================================================================================================== in_predicate ====================================================================================================================== .. raw:: html in_predicate_part_2
         ::= in_predicate_part_2
Referenced by:
====================================================================================================================== in_predicate_part_2 ====================================================================================================================== .. raw:: html NOT IN in_predicate_value
         ::= 'NOT'? 'IN' in_predicate_value
Referenced by:
====================================================================================================================== in_predicate_value ====================================================================================================================== .. raw:: html ( in_value_list ) subquery
         ::= '(' in_value_list ')'
           | subquery
Referenced by:
====================================================================================================================== in_value_list ====================================================================================================================== .. raw:: html row_value_expression ,
         ::= row_value_expression ( ',' row_value_expression )*
Referenced by:
====================================================================================================================== like_predicate ====================================================================================================================== .. raw:: html character_like_predicate octet_like_predicate
         ::= character_like_predicate
           | octet_like_predicate
Referenced by:
====================================================================================================================== character_like_predicate ====================================================================================================================== .. raw:: html character_like_predicate_part_2
         ::= character_like_predicate_part_2
Referenced by:
====================================================================================================================== character_like_predicate_part_2 ====================================================================================================================== .. raw:: html NOT LIKE character_value_expression ESCAPE character_value_expression
         ::= 'NOT'? 'LIKE' character_value_expression ( 'ESCAPE' character_value_expression )?
Referenced by:
====================================================================================================================== octet_like_predicate ====================================================================================================================== .. raw:: html octet_like_predicate_part_2
         ::= octet_like_predicate_part_2
Referenced by:
====================================================================================================================== octet_like_predicate_part_2 ====================================================================================================================== .. raw:: html NOT LIKE binary_value_expression ESCAPE binary_value_expression
         ::= 'NOT'? 'LIKE' binary_value_expression ( 'ESCAPE' binary_value_expression )?
Referenced by:
====================================================================================================================== similar_predicate ====================================================================================================================== .. raw:: html similar_predicate_part_2
         ::= similar_predicate_part_2
Referenced by:
====================================================================================================================== similar_predicate_part_2 ====================================================================================================================== .. raw:: html NOT SIMILAR TO character_value_expression ESCAPE character_value_expression
         ::= 'NOT'? 'SIMILAR' 'TO' character_value_expression ( 'ESCAPE' character_value_expression )?
Referenced by:
====================================================================================================================== regex_like_predicate ====================================================================================================================== .. raw:: html regex_like_predicate_part_2
         ::= regex_like_predicate_part_2
Referenced by:
====================================================================================================================== regex_like_predicate_part_2 ====================================================================================================================== .. raw:: html NOT LIKE_REGEX character_value_expression FLAG character_value_expression
         ::= 'NOT'? 'LIKE_REGEX' character_value_expression ( 'FLAG' character_value_expression )?
Referenced by:
====================================================================================================================== null_predicate ====================================================================================================================== .. raw:: html null_predicate_part_2
         ::= null_predicate_part_2
Referenced by:
====================================================================================================================== null_predicate_part_2 ====================================================================================================================== .. raw:: html IS NOT NULL
         ::= 'IS' 'NOT'? 'NULL'
Referenced by:
====================================================================================================================== quantified_comparison_predicate ====================================================================================================================== .. raw:: html quantified_comparison_predicate_part_2
Referenced by:
====================================================================================================================== quantified_comparison_predicate_part_2 ====================================================================================================================== .. raw:: html comp_op ALL SOME ANY subquery
         ::= comp_op ( 'ALL' | 'SOME' | 'ANY' ) subquery
Referenced by:
====================================================================================================================== exists_predicate ====================================================================================================================== .. raw:: html EXISTS subquery
         ::= 'EXISTS' subquery
Referenced by:
====================================================================================================================== unique_predicate ====================================================================================================================== .. raw:: html UNIQUE subquery
         ::= 'UNIQUE' subquery
Referenced by:
====================================================================================================================== normalized_predicate ====================================================================================================================== .. raw:: html normalized_predicate_part_2
         ::= normalized_predicate_part_2
Referenced by:
====================================================================================================================== normalized_predicate_part_2 ====================================================================================================================== .. raw:: html IS NOT normal_form NORMALIZED
         ::= 'IS' 'NOT'? normal_form? 'NORMALIZED'
Referenced by:
====================================================================================================================== match_predicate ====================================================================================================================== .. raw:: html match_predicate_part_2
         ::= match_predicate_part_2
Referenced by:
====================================================================================================================== match_predicate_part_2 ====================================================================================================================== .. raw:: html MATCH UNIQUE SIMPLE PARTIAL FULL subquery
         ::= 'MATCH' 'UNIQUE'? ( 'SIMPLE' | 'PARTIAL' | 'FULL' )? subquery
Referenced by:
====================================================================================================================== overlaps_predicate ====================================================================================================================== .. raw:: html overlaps_predicate_part_2
         ::= overlaps_predicate_part_2
Referenced by:
====================================================================================================================== overlaps_predicate_part_1 ====================================================================================================================== .. raw:: html row_value_predicand_1
         ::= row_value_predicand_1
Referenced by:
====================================================================================================================== overlaps_predicate_part_2 ====================================================================================================================== .. raw:: html OVERLAPS row_value_predicand_2
         ::= 'OVERLAPS' row_value_predicand_2
Referenced by:
====================================================================================================================== row_value_predicand_1 ====================================================================================================================== .. raw:: html row_value_predicand
         ::= row_value_predicand
Referenced by:
====================================================================================================================== row_value_predicand_2 ====================================================================================================================== .. raw:: html row_value_predicand
         ::= row_value_predicand
Referenced by:
====================================================================================================================== distinct_predicate ====================================================================================================================== .. raw:: html distinct_predicate_part_2
         ::= distinct_predicate_part_2
Referenced by:
====================================================================================================================== distinct_predicate_part_2 ====================================================================================================================== .. raw:: html IS NOT DISTINCT FROM row_value_predicand_4
         ::= 'IS' 'NOT'? 'DISTINCT' 'FROM' row_value_predicand_4
Referenced by:
====================================================================================================================== row_value_predicand_3 ====================================================================================================================== .. raw:: html row_value_predicand
         ::= row_value_predicand
Not referenced by any.
====================================================================================================================== row_value_predicand_4 ====================================================================================================================== .. raw:: html row_value_predicand
         ::= row_value_predicand
Referenced by:
====================================================================================================================== member_predicate ====================================================================================================================== .. raw:: html member_predicate_part_2
         ::= member_predicate_part_2
Referenced by:
====================================================================================================================== member_predicate_part_2 ====================================================================================================================== .. raw:: html NOT MEMBER OF multiset_value_expression
         ::= 'NOT'? 'MEMBER' 'OF'? multiset_value_expression
Referenced by:
====================================================================================================================== submultiset_predicate ====================================================================================================================== .. raw:: html submultiset_predicate_part_2
         ::= submultiset_predicate_part_2
Referenced by:
====================================================================================================================== submultiset_predicate_part_2 ====================================================================================================================== .. raw:: html NOT SUBMULTISET OF multiset_value_expression
         ::= 'NOT'? 'SUBMULTISET' 'OF'? multiset_value_expression
Referenced by:
====================================================================================================================== set_predicate ====================================================================================================================== .. raw:: html set_predicate_part_2
         ::= set_predicate_part_2
Referenced by:
====================================================================================================================== set_predicate_part_2 ====================================================================================================================== .. raw:: html IS NOT A SET
         ::= 'IS' 'NOT'? 'A' 'SET'
Referenced by:
====================================================================================================================== type_predicate ====================================================================================================================== .. raw:: html type_predicate_part_2
         ::= type_predicate_part_2
Referenced by:
====================================================================================================================== type_predicate_part_2 ====================================================================================================================== .. raw:: html IS NOT OF ( type_list )
         ::= 'IS' 'NOT'? 'OF' '(' type_list ')'
Referenced by:
====================================================================================================================== type_list ====================================================================================================================== .. raw:: html user_defined_type_specification ,
Referenced by:
====================================================================================================================== user_defined_type_specification ====================================================================================================================== .. raw:: html exclusive_user_defined_type_specification inclusive_user_defined_type_specification
Referenced by:
====================================================================================================================== inclusive_user_defined_type_specification ====================================================================================================================== .. raw:: html path_resolved_user_defined_type_name
Referenced by:
====================================================================================================================== exclusive_user_defined_type_specification ====================================================================================================================== .. raw:: html ONLY path_resolved_user_defined_type_name
         ::= 'ONLY' path_resolved_user_defined_type_name
Referenced by:
====================================================================================================================== search_condition ====================================================================================================================== .. raw:: html boolean_value_expression
         ::= boolean_value_expression
Referenced by:
====================================================================================================================== interval_qualifier ====================================================================================================================== .. raw:: html start_field TO end_field single_datetime_field
         ::= start_field 'TO' end_field
           | single_datetime_field
Referenced by:
====================================================================================================================== start_field ====================================================================================================================== .. raw:: html non_second_primary_datetime_field ( interval_leading_field_precision )
Referenced by:
====================================================================================================================== end_field ====================================================================================================================== .. raw:: html non_second_primary_datetime_field SECOND ( interval_fractional_seconds_precision )
         ::= non_second_primary_datetime_field
           | 'SECOND' ( '(' interval_fractional_seconds_precision ')' )?
Referenced by:
====================================================================================================================== single_datetime_field ====================================================================================================================== .. raw:: html start_field SECOND ( interval_leading_field_precision , interval_fractional_seconds_precision )
         ::= start_field
           | 'SECOND' ( '(' interval_leading_field_precision ( ',' interval_fractional_seconds_precision )? ')' )?
Referenced by:
====================================================================================================================== primary_datetime_field ====================================================================================================================== .. raw:: html non_second_primary_datetime_field SECOND
         ::= non_second_primary_datetime_field
           | 'SECOND'
Referenced by:
====================================================================================================================== non_second_primary_datetime_field ====================================================================================================================== .. raw:: html YEAR MONTH DAY HOUR MINUTE
         ::= 'YEAR'
           | 'MONTH'
           | 'DAY'
           | 'HOUR'
           | 'MINUTE'
Referenced by:
====================================================================================================================== interval_fractional_seconds_precision ====================================================================================================================== .. raw:: html unsigned_integer
         ::= unsigned_integer
Referenced by:
====================================================================================================================== interval_leading_field_precision ====================================================================================================================== .. raw:: html unsigned_integer
         ::= unsigned_integer
Referenced by:
====================================================================================================================== language_clause ====================================================================================================================== .. raw:: html LANGUAGE language_name
         ::= 'LANGUAGE' language_name
Referenced by:
====================================================================================================================== language_name ====================================================================================================================== .. raw:: html ADA C COBOL FORTRAN M MUMPS PASCAL PLI SQL
         ::= 'ADA'
           | 'C'
           | 'COBOL'
           | 'FORTRAN'
           | 'M'
           | 'MUMPS'
           | 'PASCAL'
           | 'PLI'
           | 'SQL'
Referenced by:
====================================================================================================================== path_specification ====================================================================================================================== .. raw:: html PATH schema_name_list
         ::= 'PATH' schema_name_list
Referenced by:
====================================================================================================================== schema_name_list ====================================================================================================================== .. raw:: html schema_name ,
         ::= schema_name ( ',' schema_name )*
Referenced by:
====================================================================================================================== routine_invocation ====================================================================================================================== .. raw:: html routine_name SQL_argument_list
         ::= routine_name SQL_argument_list
Referenced by:
====================================================================================================================== routine_name ====================================================================================================================== .. raw:: html schema_name . identifier
         ::= ( schema_name '.' )? identifier
Referenced by:
====================================================================================================================== SQL_argument_list ====================================================================================================================== .. raw:: html ( SQL_argument , )
         ::= '(' ( SQL_argument ( ',' SQL_argument )* )? ')'
Referenced by:
====================================================================================================================== SQL_argument ====================================================================================================================== .. raw:: html lambda value_expression generalized_expression named_argument_specification contextually_typed_value_specification target_specification
         ::= lambda
           | value_expression generalized_expression?
           | named_argument_specification
           | target_specification
Referenced by:
====================================================================================================================== generalized_expression ====================================================================================================================== .. raw:: html AS path_resolved_user_defined_type_name
         ::= 'AS' path_resolved_user_defined_type_name
Referenced by:
====================================================================================================================== named_argument_specification ====================================================================================================================== .. raw:: html identifier => named_argument_SQL_argument
         ::= identifier '=>' named_argument_SQL_argument
Referenced by:
====================================================================================================================== named_argument_SQL_argument ====================================================================================================================== .. raw:: html value_expression contextually_typed_value_specification target_specification
         ::= value_expression
           | target_specification
Referenced by:
====================================================================================================================== character_set_specification ====================================================================================================================== .. raw:: html standard_character_set_name implementation_defined_character_set_name user_defined_character_set_name
         ::= standard_character_set_name
           | user_defined_character_set_name
Referenced by:
====================================================================================================================== standard_character_set_name ====================================================================================================================== .. raw:: html character_set_name
         ::= character_set_name
Referenced by:
====================================================================================================================== implementation_defined_character_set_name ====================================================================================================================== .. raw:: html character_set_name
         ::= character_set_name
Referenced by:
====================================================================================================================== user_defined_character_set_name ====================================================================================================================== .. raw:: html character_set_name
         ::= character_set_name
Referenced by:
====================================================================================================================== specific_routine_designator ====================================================================================================================== .. raw:: html SPECIFIC routine_type schema_qualified_name routine_type member_name FOR schema_resolved_user_defined_type_name
         ::= 'SPECIFIC' routine_type schema_qualified_name
Referenced by:
====================================================================================================================== routine_type ====================================================================================================================== .. raw:: html ROUTINE FUNCTION PROCEDURE INSTANCE STATIC CONSTRUCTOR METHOD
         ::= 'ROUTINE'
           | 'FUNCTION'
           | 'PROCEDURE'
           | ( 'INSTANCE' | 'STATIC' | 'CONSTRUCTOR' )? 'METHOD'
Referenced by:
====================================================================================================================== member_name ====================================================================================================================== .. raw:: html member_name_alternatives data_type_list
Referenced by:
====================================================================================================================== member_name_alternatives ====================================================================================================================== .. raw:: html schema_qualified_name identifier
         ::= schema_qualified_name
           | identifier
Referenced by:
====================================================================================================================== data_type_list ====================================================================================================================== .. raw:: html ( data_type , )
         ::= '(' ( data_type ( ',' data_type )* )? ')'
Referenced by:
====================================================================================================================== collate_clause ====================================================================================================================== .. raw:: html COLLATE schema_qualified_name
         ::= 'COLLATE' schema_qualified_name
Referenced by:
====================================================================================================================== constraint_name_definition ====================================================================================================================== .. raw:: html CONSTRAINT schema_qualified_name
         ::= 'CONSTRAINT' schema_qualified_name
Referenced by:
====================================================================================================================== constraint_characteristics ====================================================================================================================== .. raw:: html constraint_check_time NOT DEFERRABLE NOT DEFERRABLE constraint_check_time constraint_enforcement constraint_enforcement
         ::= ( constraint_check_time ( 'NOT'? 'DEFERRABLE' )? | 'NOT'? 'DEFERRABLE' constraint_check_time? ) constraint_enforcement?
           | constraint_enforcement
Referenced by:
====================================================================================================================== constraint_check_time ====================================================================================================================== .. raw:: html INITIALLY DEFERRED IMMEDIATE
         ::= 'INITIALLY' ( 'DEFERRED' | 'IMMEDIATE' )
Referenced by:
====================================================================================================================== constraint_enforcement ====================================================================================================================== .. raw:: html NOT ENFORCED
         ::= 'NOT'? 'ENFORCED'
Referenced by:
====================================================================================================================== aggregate_function ====================================================================================================================== .. raw:: html COUNT ( * ) count general_set_function binary_set_function ordered_set_function array_aggregate_function presto_aggregations filter_clause
Referenced by:
====================================================================================================================== general_set_function ====================================================================================================================== .. raw:: html set_function_type ( set_quantifier value_expression extra_args_to_agg )
Referenced by:
====================================================================================================================== set_function_type ====================================================================================================================== .. raw:: html computational_operation
         ::= computational_operation
Referenced by:
====================================================================================================================== computational_operation ====================================================================================================================== .. raw:: html AVG MAX MIN SUM EVERY ANY SOME COUNT STDDEV_POP STDDEV_SAMP VAR_SAMP VAR_POP COLLECT FUSION INTERSECTION
         ::= 'AVG'
           | 'MAX'
           | 'MIN'
           | 'SUM'
           | 'EVERY'
           | 'ANY'
           | 'SOME'
           | 'COUNT'
           | 'STDDEV_POP'
           | 'STDDEV_SAMP'
           | 'VAR_SAMP'
           | 'VAR_POP'
           | 'COLLECT'
           | 'FUSION'
           | 'INTERSECTION'
Referenced by:
====================================================================================================================== set_quantifier ====================================================================================================================== .. raw:: html DISTINCT ALL
         ::= 'DISTINCT'
           | 'ALL'
Referenced by:
====================================================================================================================== filter_clause ====================================================================================================================== .. raw:: html FILTER ( WHERE search_condition )
         ::= 'FILTER' '(' 'WHERE' search_condition ')'
Referenced by:
====================================================================================================================== binary_set_function ====================================================================================================================== .. raw:: html binary_set_function_type ( dependent_variable_expression , independent_variable_expression )
Referenced by:
====================================================================================================================== binary_set_function_type ====================================================================================================================== .. raw:: html COVAR_POP COVAR_SAMP CORR REGR_SLOPE REGR_INTERCEPT REGR_COUNT REGR_R2 REGR_AVGX REGR_AVGY REGR_SXX REGR_SYY REGR_SXY
         ::= 'COVAR_POP'
           | 'COVAR_SAMP'
           | 'CORR'
           | 'REGR_SLOPE'
           | 'REGR_INTERCEPT'
           | 'REGR_COUNT'
           | 'REGR_R2'
           | 'REGR_AVGX'
           | 'REGR_AVGY'
           | 'REGR_SXX'
           | 'REGR_SYY'
           | 'REGR_SXY'
Referenced by:
====================================================================================================================== dependent_variable_expression ====================================================================================================================== .. raw:: html numeric_value_expression
         ::= numeric_value_expression
Referenced by:
====================================================================================================================== independent_variable_expression ====================================================================================================================== .. raw:: html numeric_value_expression
         ::= numeric_value_expression
Referenced by:
====================================================================================================================== ordered_set_function ====================================================================================================================== .. raw:: html hypothetical_set_function inverse_distribution_function
         ::= hypothetical_set_function
           | inverse_distribution_function
Referenced by:
====================================================================================================================== hypothetical_set_function ====================================================================================================================== .. raw:: html rank_function_type ( hypothetical_set_function_value_expression_list ) within_group_specification
Referenced by:
====================================================================================================================== within_group_specification ====================================================================================================================== .. raw:: html WITHIN GROUP ( ORDER BY sort_specification_list )
         ::= 'WITHIN' 'GROUP' '(' 'ORDER' 'BY' sort_specification_list ')'
Referenced by:
====================================================================================================================== hypothetical_set_function_value_expression_list ====================================================================================================================== .. raw:: html value_expression ,
         ::= value_expression ( ',' value_expression )*
Referenced by:
====================================================================================================================== inverse_distribution_function ====================================================================================================================== .. raw:: html inverse_distribution_function_type ( inverse_distribution_function_argument ) within_group_specification
Referenced by:
====================================================================================================================== inverse_distribution_function_argument ====================================================================================================================== .. raw:: html numeric_value_expression
         ::= numeric_value_expression
Referenced by:
====================================================================================================================== inverse_distribution_function_type ====================================================================================================================== .. raw:: html PERCENTILE_CONT PERCENTILE_DISC
         ::= 'PERCENTILE_CONT'
           | 'PERCENTILE_DISC'
Referenced by:
====================================================================================================================== array_aggregate_function ====================================================================================================================== .. raw:: html ARRAY_AGG ( DISTINCT value_expression ORDER BY sort_specification_list )
         ::= 'ARRAY_AGG' '(' 'DISTINCT'? value_expression ( 'ORDER' 'BY' sort_specification_list )? ')'
Referenced by:
====================================================================================================================== sort_specification_list ====================================================================================================================== .. raw:: html sort_specification ,
         ::= sort_specification ( ',' sort_specification )*
Referenced by:
====================================================================================================================== sort_specification ====================================================================================================================== .. raw:: html sort_key ordering_specification null_ordering
Referenced by:
====================================================================================================================== sort_key ====================================================================================================================== .. raw:: html value_expression
Referenced by:
====================================================================================================================== ordering_specification ====================================================================================================================== .. raw:: html ASC DESC
         ::= 'ASC'
           | 'DESC'
Referenced by:
====================================================================================================================== null_ordering ====================================================================================================================== .. raw:: html NULLS FIRST LAST
         ::= 'NULLS' ( 'FIRST' | 'LAST' )
Referenced by:
====================================================================================================================== schema_definition ====================================================================================================================== .. raw:: html CREATE SCHEMA if_not_exists schema_name_clause schema_character_set_or_path schema_element
Referenced by:
====================================================================================================================== schema_character_set_or_path ====================================================================================================================== .. raw:: html schema_character_set_specification schema_path_specification schema_path_specification schema_character_set_specification
Referenced by:
====================================================================================================================== schema_name_clause ====================================================================================================================== .. raw:: html schema_name AUTHORIZATION identifier AUTHORIZATION identifier
         ::= schema_name ( 'AUTHORIZATION' identifier )?
           | 'AUTHORIZATION' identifier
Referenced by:
====================================================================================================================== schema_character_set_specification ====================================================================================================================== .. raw:: html DEFAULT CHARACTER SET character_set_specification
         ::= 'DEFAULT' 'CHARACTER' 'SET' character_set_specification
Referenced by:
====================================================================================================================== schema_path_specification ====================================================================================================================== .. raw:: html path_specification
         ::= path_specification
Referenced by:
====================================================================================================================== schema_element ====================================================================================================================== .. raw:: html table_definition view_definition domain_definition character_set_definition collation_definition transliteration_definition assertion_definition trigger_definition user_defined_type_definition user_defined_cast_definition user_defined_ordering_definition transform_definition schema_routine sequence_generator_definition grant_statement role_definition
         ::= table_definition
           | view_definition
           | domain_definition
           | character_set_definition
           | collation_definition
           | transliteration_definition
           | assertion_definition
           | trigger_definition
           | user_defined_type_definition
           | user_defined_cast_definition
           | user_defined_ordering_definition
           | transform_definition
           | schema_routine
           | sequence_generator_definition
           | grant_statement
           | role_definition
Referenced by:
====================================================================================================================== drop_schema_statement ====================================================================================================================== .. raw:: html DROP SCHEMA schema_name drop_behavior
         ::= 'DROP' 'SCHEMA' schema_name drop_behavior
Referenced by:
====================================================================================================================== drop_behavior ====================================================================================================================== .. raw:: html CASCADE RESTRICT
         ::= 'CASCADE'
           | 'RESTRICT'
Referenced by:
====================================================================================================================== table_definition ====================================================================================================================== .. raw:: html CREATE table_scope TABLE if_not_exists table_name table_description WITH system_versioning_clause table_attributes table_contents_source table_contents_source table_description WITH system_versioning_clause table_attributes ON COMMIT table_commit_action ROWS
Referenced by:
====================================================================================================================== table_contents_source ====================================================================================================================== .. raw:: html typed_table_clause as_subquery_clause table_element_list
         ::= typed_table_clause
           | as_subquery_clause
           | table_element_list
Referenced by:
====================================================================================================================== table_scope ====================================================================================================================== .. raw:: html global_or_local TEMPORARY
         ::= global_or_local 'TEMPORARY'
Referenced by:
====================================================================================================================== global_or_local ====================================================================================================================== .. raw:: html GLOBAL LOCAL
         ::= 'GLOBAL'
           | 'LOCAL'
Referenced by:
====================================================================================================================== system_versioning_clause ====================================================================================================================== .. raw:: html SYSTEM VERSIONING retention_period_specification
         ::= 'SYSTEM' 'VERSIONING' retention_period_specification?
Referenced by:
====================================================================================================================== retention_period_specification ====================================================================================================================== .. raw:: html KEEP VERSIONS FOREVER FOR length_of_time time_unit
         ::= 'KEEP' 'VERSIONS' ( 'FOREVER' | 'FOR' length_of_time time_unit )
Referenced by:
====================================================================================================================== length_of_time ====================================================================================================================== .. raw:: html unsigned_integer
         ::= unsigned_integer
Referenced by:
====================================================================================================================== time_unit ====================================================================================================================== .. raw:: html SECOND SECONDS MINUTE MINUTES HOUR HOURS DAY DAYS MONTH MONTHS YEAR YEARS
         ::= 'SECOND'
           | 'SECONDS'
           | 'MINUTE'
           | 'MINUTES'
           | 'HOUR'
           | 'HOURS'
           | 'DAY'
           | 'DAYS'
           | 'MONTH'
           | 'MONTHS'
           | 'YEAR'
           | 'YEARS'
Referenced by:
====================================================================================================================== table_commit_action ====================================================================================================================== .. raw:: html PRESERVE DELETE
         ::= 'PRESERVE'
           | 'DELETE'
Referenced by:
====================================================================================================================== table_element_list ====================================================================================================================== .. raw:: html ( table_element , )
         ::= '(' table_element ( ',' table_element )* ')'
Referenced by:
====================================================================================================================== table_element ====================================================================================================================== .. raw:: html column_definition table_constraint_definition like_clause
         ::= column_definition
           | table_constraint_definition
           | like_clause
Referenced by:
====================================================================================================================== typed_table_clause ====================================================================================================================== .. raw:: html OF path_resolved_user_defined_type_name subtable_clause typed_table_element_list
Referenced by:
====================================================================================================================== typed_table_element_list ====================================================================================================================== .. raw:: html ( typed_table_element , )
         ::= '(' typed_table_element ( ',' typed_table_element )* ')'
Referenced by:
====================================================================================================================== typed_table_element ====================================================================================================================== .. raw:: html column_options table_constraint_definition self_referencing_column_specification
         ::= column_options
           | table_constraint_definition
Referenced by:
====================================================================================================================== self_referencing_column_specification ====================================================================================================================== .. raw:: html REF IS identifier reference_generation
         ::= 'REF' 'IS' identifier reference_generation?
Referenced by:
====================================================================================================================== reference_generation ====================================================================================================================== .. raw:: html SYSTEM USER GENERATED DERIVED
         ::= ( 'SYSTEM' | 'USER' ) 'GENERATED'
           | 'DERIVED'
Referenced by:
====================================================================================================================== column_options ====================================================================================================================== .. raw:: html identifier WITH OPTIONS column_option_list
         ::= identifier 'WITH' 'OPTIONS' column_option_list
Referenced by:
====================================================================================================================== column_option_list ====================================================================================================================== .. raw:: html scope_clause default_clause column_constraint_definition
Referenced by:
====================================================================================================================== subtable_clause ====================================================================================================================== .. raw:: html UNDER supertable_clause
         ::= 'UNDER' supertable_clause
Referenced by:
====================================================================================================================== supertable_clause ====================================================================================================================== .. raw:: html supertable_name
         ::= supertable_name
Referenced by:
====================================================================================================================== supertable_name ====================================================================================================================== .. raw:: html table_name
         ::= table_name
Referenced by:
====================================================================================================================== like_clause ====================================================================================================================== .. raw:: html LIKE table_name like_options
         ::= 'LIKE' table_name like_options?
Referenced by:
====================================================================================================================== like_options ====================================================================================================================== .. raw:: html like_option
         ::= like_option+
Referenced by:
====================================================================================================================== like_option ====================================================================================================================== .. raw:: html identity_option column_default_option generation_option INCLUDING PROPERTIES
         ::= identity_option
           | column_default_option
           | generation_option
           | 'INCLUDING' 'PROPERTIES'
Referenced by:
====================================================================================================================== identity_option ====================================================================================================================== .. raw:: html INCLUDING EXCLUDING IDENTITY
         ::= ( 'INCLUDING' | 'EXCLUDING' ) 'IDENTITY'
Referenced by:
====================================================================================================================== column_default_option ====================================================================================================================== .. raw:: html INCLUDING EXCLUDING DEFAULTS
         ::= ( 'INCLUDING' | 'EXCLUDING' ) 'DEFAULTS'
Referenced by:
====================================================================================================================== generation_option ====================================================================================================================== .. raw:: html INCLUDING EXCLUDING GENERATED
         ::= ( 'INCLUDING' | 'EXCLUDING' ) 'GENERATED'
Referenced by:
====================================================================================================================== as_subquery_clause ====================================================================================================================== .. raw:: html ( column_name_list ) WITH table_attributes AS subquery query_expression with_or_without_data
         ::= ( '(' column_name_list ')' )? ( 'WITH' table_attributes )? 'AS' ( subquery | query_expression ) with_or_without_data?
Referenced by:
====================================================================================================================== with_or_without_data ====================================================================================================================== .. raw:: html WITH NO DATA
         ::= 'WITH' 'NO'? 'DATA'
Referenced by:
====================================================================================================================== column_definition ====================================================================================================================== .. raw:: html identifier data_type_or_schema_qualified_name default_clause identity_column_specification generation_clause system_version_start_column_specification system_version_end_column_specification column_constraint_definition collate_clause column_description
Referenced by:
====================================================================================================================== data_type_or_schema_qualified_name ====================================================================================================================== .. raw:: html data_type schema_qualified_name
         ::= data_type
           | schema_qualified_name
Referenced by:
====================================================================================================================== system_version_start_column_specification ====================================================================================================================== .. raw:: html timestamp_generation_rule AS SYSTEM VERSION START
         ::= timestamp_generation_rule 'AS' 'SYSTEM' 'VERSION' 'START'
Referenced by:
====================================================================================================================== system_version_end_column_specification ====================================================================================================================== .. raw:: html timestamp_generation_rule AS SYSTEM VERSION END
         ::= timestamp_generation_rule 'AS' 'SYSTEM' 'VERSION' 'END'
Referenced by:
====================================================================================================================== timestamp_generation_rule ====================================================================================================================== .. raw:: html GENERATED ALWAYS
         ::= 'GENERATED' 'ALWAYS'
Referenced by:
====================================================================================================================== column_constraint_definition ====================================================================================================================== .. raw:: html constraint_name_definition column_constraint constraint_characteristics
Referenced by:
====================================================================================================================== column_constraint ====================================================================================================================== .. raw:: html NOT NULL unique_specification references_specification check_constraint_definition
         ::= 'NOT' 'NULL'
           | unique_specification
           | references_specification
           | check_constraint_definition
Referenced by:
====================================================================================================================== identity_column_specification ====================================================================================================================== .. raw:: html GENERATED ALWAYS BY DEFAULT AS IDENTITY ( common_sequence_generator_options )
         ::= 'GENERATED' ( 'ALWAYS' | 'BY' 'DEFAULT' ) 'AS' 'IDENTITY' ( '(' common_sequence_generator_options ')' )?
Referenced by:
====================================================================================================================== generation_clause ====================================================================================================================== .. raw:: html generation_rule AS generation_expression
         ::= generation_rule 'AS' generation_expression
Referenced by:
====================================================================================================================== generation_rule ====================================================================================================================== .. raw:: html GENERATED ALWAYS
         ::= 'GENERATED' 'ALWAYS'
Referenced by:
====================================================================================================================== generation_expression ====================================================================================================================== .. raw:: html ( value_expression )
         ::= '(' value_expression ')'
Referenced by:
====================================================================================================================== default_clause ====================================================================================================================== .. raw:: html DEFAULT default_option
         ::= 'DEFAULT' default_option
Referenced by:
====================================================================================================================== default_option ====================================================================================================================== .. raw:: html literal datetime_value_function USER CURRENT_USER CURRENT_ROLE SESSION_USER SYSTEM_USER CURRENT_CATALOG CURRENT_SCHEMA CURRENT_PATH implicitly_typed_value_specification
         ::= literal
           | datetime_value_function
           | 'USER'
           | 'CURRENT_USER'
           | 'CURRENT_ROLE'
           | 'SESSION_USER'
           | 'SYSTEM_USER'
           | 'CURRENT_CATALOG'
           | 'CURRENT_SCHEMA'
           | 'CURRENT_PATH'
           | implicitly_typed_value_specification
Referenced by:
====================================================================================================================== table_constraint_definition ====================================================================================================================== .. raw:: html constraint_name_definition table_constraint constraint_characteristics
Referenced by:
====================================================================================================================== table_constraint ====================================================================================================================== .. raw:: html unique_constraint_definition referential_constraint_definition check_constraint_definition
         ::= unique_constraint_definition
           | referential_constraint_definition
           | check_constraint_definition
Referenced by:
====================================================================================================================== unique_constraint_definition ====================================================================================================================== .. raw:: html unique_specification ( unique_column_list ) UNIQUE VALUE
         ::= unique_specification '(' unique_column_list ')'
           | 'UNIQUE' 'VALUE'
Referenced by:
====================================================================================================================== unique_specification ====================================================================================================================== .. raw:: html UNIQUE PRIMARY KEY
         ::= 'UNIQUE'
           | 'PRIMARY' 'KEY'
Referenced by:
====================================================================================================================== unique_column_list ====================================================================================================================== .. raw:: html column_name_list
         ::= column_name_list
Referenced by:
====================================================================================================================== referential_constraint_definition ====================================================================================================================== .. raw:: html FOREIGN KEY ( referencing_columns ) references_specification
         ::= 'FOREIGN' 'KEY' '(' referencing_columns ')' references_specification
Referenced by:
====================================================================================================================== references_specification ====================================================================================================================== .. raw:: html REFERENCES referenced_table_and_columns MATCH match_type referential_triggered_action
         ::= 'REFERENCES' referenced_table_and_columns ( 'MATCH' match_type )? referential_triggered_action?
Referenced by:
====================================================================================================================== match_type ====================================================================================================================== .. raw:: html FULL PARTIAL SIMPLE
         ::= 'FULL'
           | 'PARTIAL'
           | 'SIMPLE'
Referenced by:
====================================================================================================================== referencing_columns ====================================================================================================================== .. raw:: html reference_column_list
         ::= reference_column_list
Referenced by:
====================================================================================================================== referenced_table_and_columns ====================================================================================================================== .. raw:: html table_name ( reference_column_list )
         ::= table_name ( '(' reference_column_list ')' )?
Referenced by:
====================================================================================================================== reference_column_list ====================================================================================================================== .. raw:: html column_name_list
         ::= column_name_list
Referenced by:
====================================================================================================================== referential_triggered_action ====================================================================================================================== .. raw:: html update_rule delete_rule delete_rule update_rule
         ::= update_rule delete_rule?
           | delete_rule update_rule?
Referenced by:
====================================================================================================================== update_rule ====================================================================================================================== .. raw:: html ON UPDATE referential_action
         ::= 'ON' 'UPDATE' referential_action
Referenced by:
====================================================================================================================== delete_rule ====================================================================================================================== .. raw:: html ON DELETE referential_action
         ::= 'ON' 'DELETE' referential_action
Referenced by:
====================================================================================================================== referential_action ====================================================================================================================== .. raw:: html CASCADE SET NULL DEFAULT RESTRICT NO ACTION
         ::= 'CASCADE'
           | 'SET' ( 'NULL' | 'DEFAULT' )
           | 'RESTRICT'
           | 'NO' 'ACTION'
Referenced by:
====================================================================================================================== check_constraint_definition ====================================================================================================================== .. raw:: html CHECK ( search_condition )
         ::= 'CHECK' '(' search_condition ')'
Referenced by:
====================================================================================================================== alter_table_statement ====================================================================================================================== .. raw:: html ALTER TABLE table_name alter_table_action
         ::= 'ALTER' 'TABLE' table_name alter_table_action
Referenced by:
====================================================================================================================== alter_table_action ====================================================================================================================== .. raw:: html add_column_definition alter_column_definition drop_column_definition add_table_constraint_definition alter_table_constraint_definition drop_table_constraint_definition add_system_versioning_clause alter_system_versioning_clause drop_system_versioning_clause
         ::= add_column_definition
           | alter_column_definition
           | drop_column_definition
           | add_table_constraint_definition
           | alter_table_constraint_definition
           | drop_table_constraint_definition
           | add_system_versioning_clause
           | alter_system_versioning_clause
           | drop_system_versioning_clause
Referenced by:
====================================================================================================================== add_column_definition ====================================================================================================================== .. raw:: html ADD COLUMN column_definition
         ::= 'ADD' 'COLUMN'? column_definition
Referenced by:
====================================================================================================================== alter_column_definition ====================================================================================================================== .. raw:: html ALTER COLUMN identifier alter_column_action
         ::= 'ALTER' 'COLUMN'? identifier alter_column_action
Referenced by:
====================================================================================================================== alter_column_action ====================================================================================================================== .. raw:: html set_column_default_clause drop_column_default_clause set_column_not_null_clause drop_column_not_null_clause add_column_scope_clause drop_column_scope_clause alter_column_data_type_clause alter_identity_column_specification drop_identity_property_clause drop_column_generation_expression_clause
         ::= set_column_default_clause
           | drop_column_default_clause
           | set_column_not_null_clause
           | drop_column_not_null_clause
           | add_column_scope_clause
           | drop_column_scope_clause
           | alter_column_data_type_clause
           | alter_identity_column_specification
           | drop_identity_property_clause
Referenced by:
====================================================================================================================== set_column_default_clause ====================================================================================================================== .. raw:: html SET default_clause
         ::= 'SET' default_clause
Referenced by:
====================================================================================================================== drop_column_default_clause ====================================================================================================================== .. raw:: html DROP DEFAULT
         ::= 'DROP' 'DEFAULT'
Referenced by:
====================================================================================================================== set_column_not_null_clause ====================================================================================================================== .. raw:: html SET NOT NULL
         ::= 'SET' 'NOT' 'NULL'
Referenced by:
====================================================================================================================== drop_column_not_null_clause ====================================================================================================================== .. raw:: html DROP NOT NULL
         ::= 'DROP' 'NOT' 'NULL'
Referenced by:
====================================================================================================================== add_column_scope_clause ====================================================================================================================== .. raw:: html ADD scope_clause
         ::= 'ADD' scope_clause
Referenced by:
====================================================================================================================== drop_column_scope_clause ====================================================================================================================== .. raw:: html DROP SCOPE drop_behavior
         ::= 'DROP' 'SCOPE' drop_behavior
Referenced by:
====================================================================================================================== alter_column_data_type_clause ====================================================================================================================== .. raw:: html SET DATA TYPE data_type
         ::= 'SET' 'DATA' 'TYPE' data_type
Referenced by:
====================================================================================================================== alter_identity_column_specification ====================================================================================================================== .. raw:: html set_identity_column_generation_clause alter_identity_column_option alter_identity_column_option
Referenced by:
====================================================================================================================== set_identity_column_generation_clause ====================================================================================================================== .. raw:: html SET GENERATED ALWAYS BY DEFAULT
         ::= 'SET' 'GENERATED' ( 'ALWAYS' | 'BY' 'DEFAULT' )
Referenced by:
====================================================================================================================== alter_identity_column_option ====================================================================================================================== .. raw:: html alter_sequence_generator_restart_option SET basic_sequence_generator_option
           | 'SET' basic_sequence_generator_option
Referenced by:
====================================================================================================================== drop_identity_property_clause ====================================================================================================================== .. raw:: html DROP IDENTITY
         ::= 'DROP' 'IDENTITY'
Referenced by:
====================================================================================================================== drop_column_generation_expression_clause ====================================================================================================================== .. raw:: html DROP EXPRESSION
         ::= 'DROP' 'EXPRESSION'
Referenced by:
====================================================================================================================== drop_column_definition ====================================================================================================================== .. raw:: html DROP COLUMN identifier drop_behavior
         ::= 'DROP' 'COLUMN'? identifier drop_behavior
Referenced by:
====================================================================================================================== add_table_constraint_definition ====================================================================================================================== .. raw:: html ADD table_constraint_definition
         ::= 'ADD' table_constraint_definition
Referenced by:
====================================================================================================================== alter_table_constraint_definition ====================================================================================================================== .. raw:: html ALTER CONSTRAINT schema_qualified_name constraint_enforcement
         ::= 'ALTER' 'CONSTRAINT' schema_qualified_name constraint_enforcement
Referenced by:
====================================================================================================================== drop_table_constraint_definition ====================================================================================================================== .. raw:: html DROP CONSTRAINT schema_qualified_name drop_behavior
         ::= 'DROP' 'CONSTRAINT' schema_qualified_name drop_behavior
Referenced by:
====================================================================================================================== add_system_versioning_clause ====================================================================================================================== .. raw:: html ADD system_versioning_clause add_system_version_column_list
Referenced by:
====================================================================================================================== add_system_version_column_list ====================================================================================================================== .. raw:: html ADD COLUMN column_definition_1 ADD COLUMN column_definition_2
         ::= 'ADD' 'COLUMN'? column_definition_1 'ADD' 'COLUMN'? column_definition_2
Referenced by:
====================================================================================================================== column_definition_1 ====================================================================================================================== .. raw:: html column_definition
         ::= column_definition
Referenced by:
====================================================================================================================== column_definition_2 ====================================================================================================================== .. raw:: html column_definition
         ::= column_definition
Referenced by:
====================================================================================================================== alter_system_versioning_clause ====================================================================================================================== .. raw:: html ALTER SYSTEM VERSIONING retention_period_specification
         ::= 'ALTER' 'SYSTEM' 'VERSIONING' retention_period_specification
Referenced by:
====================================================================================================================== drop_system_versioning_clause ====================================================================================================================== .. raw:: html DROP SYSTEM VERSIONING drop_behavior
         ::= 'DROP' 'SYSTEM' 'VERSIONING' drop_behavior
Referenced by:
====================================================================================================================== drop_table_statement ====================================================================================================================== .. raw:: html DROP TABLE IF EXISTS table_name drop_behavior
         ::= 'DROP' 'TABLE' ( 'IF' 'EXISTS' )? table_name drop_behavior?
Referenced by:
====================================================================================================================== view_definition ====================================================================================================================== .. raw:: html CREATE or_replace RECURSIVE VIEW table_name view_specification AS query_expression WITH levels_clause CHECK OPTION
         ::= 'CREATE' or_replace? 'RECURSIVE'? 'VIEW' table_name view_specification 'AS' query_expression ( 'WITH' levels_clause? 'CHECK' 'OPTION' )?
Referenced by:
====================================================================================================================== view_specification ====================================================================================================================== .. raw:: html regular_view_specification referenceable_view_specification
         ::= regular_view_specification
           | referenceable_view_specification
Referenced by:
====================================================================================================================== regular_view_specification ====================================================================================================================== .. raw:: html ( view_column_list )
         ::= ( '(' view_column_list ')' )?
Referenced by:
====================================================================================================================== referenceable_view_specification ====================================================================================================================== .. raw:: html OF path_resolved_user_defined_type_name subview_clause view_element_list
Referenced by:
====================================================================================================================== subview_clause ====================================================================================================================== .. raw:: html UNDER table_name
         ::= 'UNDER' table_name
Referenced by:
====================================================================================================================== view_element_list ====================================================================================================================== .. raw:: html ( view_element , )
         ::= '(' view_element ( ',' view_element )* ')'
Referenced by:
====================================================================================================================== view_element ====================================================================================================================== .. raw:: html self_referencing_column_specification view_column_option
           | view_column_option
Referenced by:
====================================================================================================================== view_column_option ====================================================================================================================== .. raw:: html identifier WITH OPTIONS scope_clause
         ::= identifier 'WITH' 'OPTIONS' scope_clause
Referenced by:
====================================================================================================================== levels_clause ====================================================================================================================== .. raw:: html CASCADED LOCAL
         ::= 'CASCADED'
           | 'LOCAL'
Referenced by:
====================================================================================================================== view_column_list ====================================================================================================================== .. raw:: html column_name_list
         ::= column_name_list
Referenced by:
====================================================================================================================== drop_view_statement ====================================================================================================================== .. raw:: html DROP VIEW table_name drop_behavior
         ::= 'DROP' 'VIEW' table_name drop_behavior
Referenced by:
====================================================================================================================== domain_definition ====================================================================================================================== .. raw:: html CREATE DOMAIN schema_qualified_name AS predefined_type default_clause domain_constraint collate_clause
Referenced by:
====================================================================================================================== domain_constraint ====================================================================================================================== .. raw:: html constraint_name_definition check_constraint_definition constraint_characteristics
Referenced by:
====================================================================================================================== alter_domain_statement ====================================================================================================================== .. raw:: html ALTER DOMAIN schema_qualified_name alter_domain_action
         ::= 'ALTER' 'DOMAIN' schema_qualified_name alter_domain_action
Referenced by:
====================================================================================================================== alter_domain_action ====================================================================================================================== .. raw:: html set_domain_default_clause drop_domain_default_clause add_domain_constraint_definition drop_domain_constraint_definition
         ::= set_domain_default_clause
           | drop_domain_default_clause
           | add_domain_constraint_definition
           | drop_domain_constraint_definition
Referenced by:
====================================================================================================================== set_domain_default_clause ====================================================================================================================== .. raw:: html SET default_clause
         ::= 'SET' default_clause
Referenced by:
====================================================================================================================== drop_domain_default_clause ====================================================================================================================== .. raw:: html DROP DEFAULT
         ::= 'DROP' 'DEFAULT'
Referenced by:
====================================================================================================================== add_domain_constraint_definition ====================================================================================================================== .. raw:: html ADD domain_constraint
         ::= 'ADD' domain_constraint
Referenced by:
====================================================================================================================== drop_domain_constraint_definition ====================================================================================================================== .. raw:: html DROP CONSTRAINT schema_qualified_name
         ::= 'DROP' 'CONSTRAINT' schema_qualified_name
Referenced by:
====================================================================================================================== drop_domain_statement ====================================================================================================================== .. raw:: html DROP DOMAIN schema_qualified_name drop_behavior
         ::= 'DROP' 'DOMAIN' schema_qualified_name drop_behavior
Referenced by:
====================================================================================================================== character_set_definition ====================================================================================================================== .. raw:: html CREATE CHARACTER SET character_set_name AS character_set_source collate_clause
         ::= 'CREATE' 'CHARACTER' 'SET' character_set_name 'AS'? character_set_source collate_clause?
Referenced by:
====================================================================================================================== character_set_source ====================================================================================================================== .. raw:: html GET character_set_specification
         ::= 'GET' character_set_specification
Referenced by:
====================================================================================================================== drop_character_set_statement ====================================================================================================================== .. raw:: html DROP CHARACTER SET character_set_name
         ::= 'DROP' 'CHARACTER' 'SET' character_set_name
Referenced by:
====================================================================================================================== collation_definition ====================================================================================================================== .. raw:: html CREATE COLLATION schema_qualified_name FOR character_set_specification FROM schema_qualified_name pad_characteristic
         ::= 'CREATE' 'COLLATION' schema_qualified_name 'FOR' character_set_specification 'FROM' schema_qualified_name pad_characteristic?
Referenced by:
====================================================================================================================== pad_characteristic ====================================================================================================================== .. raw:: html NO PAD PAD SPACE
         ::= 'NO' 'PAD'
           | 'PAD' 'SPACE'
Referenced by:
====================================================================================================================== drop_collation_statement ====================================================================================================================== .. raw:: html DROP COLLATION schema_qualified_name drop_behavior
         ::= 'DROP' 'COLLATION' schema_qualified_name drop_behavior
Referenced by:
====================================================================================================================== transliteration_definition ====================================================================================================================== .. raw:: html CREATE TRANSLATION schema_qualified_name FOR source_character_set_specification TO target_character_set_specification FROM transliteration_source
Referenced by:
====================================================================================================================== source_character_set_specification ====================================================================================================================== .. raw:: html character_set_specification
         ::= character_set_specification
Referenced by:
====================================================================================================================== target_character_set_specification ====================================================================================================================== .. raw:: html character_set_specification
         ::= character_set_specification
Referenced by:
====================================================================================================================== transliteration_source ====================================================================================================================== .. raw:: html schema_qualified_name transliteration_routine
         ::= schema_qualified_name
           | transliteration_routine
Referenced by:
====================================================================================================================== transliteration_routine ====================================================================================================================== .. raw:: html specific_routine_designator
         ::= specific_routine_designator
Referenced by:
====================================================================================================================== drop_transliteration_statement ====================================================================================================================== .. raw:: html DROP TRANSLATION schema_qualified_name
         ::= 'DROP' 'TRANSLATION' schema_qualified_name
Referenced by:
====================================================================================================================== assertion_definition ====================================================================================================================== .. raw:: html CREATE ASSERTION schema_qualified_name CHECK ( search_condition ) constraint_characteristics
         ::= 'CREATE' 'ASSERTION' schema_qualified_name 'CHECK' '(' search_condition ')' constraint_characteristics?
Referenced by:
====================================================================================================================== drop_assertion_statement ====================================================================================================================== .. raw:: html DROP ASSERTION schema_qualified_name drop_behavior
         ::= 'DROP' 'ASSERTION' schema_qualified_name drop_behavior?
Referenced by:
====================================================================================================================== trigger_definition ====================================================================================================================== .. raw:: html CREATE TRIGGER schema_qualified_name trigger_action_time trigger_event ON table_name REFERENCING transition_table_or_variable_list triggered_action
Referenced by:
====================================================================================================================== trigger_action_time ====================================================================================================================== .. raw:: html BEFORE AFTER INSTEAD OF
         ::= 'BEFORE'
           | 'AFTER'
           | 'INSTEAD' 'OF'
Referenced by:
====================================================================================================================== trigger_event ====================================================================================================================== .. raw:: html INSERT DELETE UPDATE OF trigger_column_list
         ::= 'INSERT'
           | 'DELETE'
           | 'UPDATE' ( 'OF' trigger_column_list )?
Referenced by:
====================================================================================================================== trigger_column_list ====================================================================================================================== .. raw:: html column_name_list
         ::= column_name_list
Referenced by:
====================================================================================================================== triggered_action ====================================================================================================================== .. raw:: html FOR EACH ROW STATEMENT triggered_when_clause triggered_SQL_statement
         ::= ( 'FOR' 'EACH' ( 'ROW' | 'STATEMENT' ) )? triggered_when_clause? triggered_SQL_statement
Referenced by:
====================================================================================================================== triggered_when_clause ====================================================================================================================== .. raw:: html WHEN ( search_condition )
         ::= 'WHEN' '(' search_condition ')'
Referenced by:
====================================================================================================================== triggered_SQL_statement ====================================================================================================================== .. raw:: html SQL_procedure_statement BEGIN ATOMIC SQL_procedure_statement ; END
         ::= SQL_procedure_statement
           | 'BEGIN' 'ATOMIC' ( SQL_procedure_statement ';' )+ 'END'
Referenced by:
====================================================================================================================== transition_table_or_variable_list ====================================================================================================================== .. raw:: html transition_table_or_variable
         ::= transition_table_or_variable+
Referenced by:
====================================================================================================================== transition_table_or_variable ====================================================================================================================== .. raw:: html OLD NEW ROW TABLE AS identifier
         ::= ( 'OLD' | 'NEW' ) ( 'ROW' | 'TABLE' )? 'AS'? identifier
Referenced by:
====================================================================================================================== drop_trigger_statement ====================================================================================================================== .. raw:: html DROP TRIGGER schema_qualified_name
         ::= 'DROP' 'TRIGGER' schema_qualified_name
Referenced by:
====================================================================================================================== user_defined_type_definition ====================================================================================================================== .. raw:: html CREATE TYPE user_defined_type_body
         ::= 'CREATE' 'TYPE' user_defined_type_body
Referenced by:
====================================================================================================================== user_defined_type_body ====================================================================================================================== .. raw:: html schema_resolved_user_defined_type_name subtype_clause AS representation user_defined_type_option_list method_specification_list
Referenced by:
====================================================================================================================== user_defined_type_option_list ====================================================================================================================== .. raw:: html user_defined_type_option
         ::= user_defined_type_option+
Referenced by:
====================================================================================================================== user_defined_type_option ====================================================================================================================== .. raw:: html instantiable_clause finality reference_type_specification cast_to_ref cast_to_type cast_to_distinct cast_to_source
         ::= instantiable_clause
           | finality
           | reference_type_specification
           | cast_to_ref
           | cast_to_type
           | cast_to_distinct
           | cast_to_source
Referenced by:
====================================================================================================================== subtype_clause ====================================================================================================================== .. raw:: html UNDER supertype_name
         ::= 'UNDER' supertype_name
Referenced by:
====================================================================================================================== supertype_name ====================================================================================================================== .. raw:: html path_resolved_user_defined_type_name
Referenced by:
====================================================================================================================== representation ====================================================================================================================== .. raw:: html predefined_type data_type member_list
         ::= predefined_type
           | data_type
           | member_list
Referenced by:
====================================================================================================================== member_list ====================================================================================================================== .. raw:: html ( member , )
         ::= '(' member ( ',' member )* ')'
Referenced by:
====================================================================================================================== member ====================================================================================================================== .. raw:: html attribute_definition
Referenced by:
====================================================================================================================== instantiable_clause ====================================================================================================================== .. raw:: html NOT INSTANTIABLE
         ::= 'NOT'? 'INSTANTIABLE'
Referenced by:
====================================================================================================================== finality ====================================================================================================================== .. raw:: html NOT FINAL
finality ::= 'NOT'? 'FINAL'
Referenced by:
====================================================================================================================== reference_type_specification ====================================================================================================================== .. raw:: html user_defined_representation derived_representation system_generated_representation
         ::= user_defined_representation
           | derived_representation
           | system_generated_representation
Referenced by:
====================================================================================================================== user_defined_representation ====================================================================================================================== .. raw:: html REF USING predefined_type
         ::= 'REF' 'USING' predefined_type
Referenced by:
====================================================================================================================== derived_representation ====================================================================================================================== .. raw:: html REF FROM list_of_attributes
         ::= 'REF' 'FROM' list_of_attributes
Referenced by:
====================================================================================================================== system_generated_representation ====================================================================================================================== .. raw:: html REF IS SYSTEM GENERATED
         ::= 'REF' 'IS' 'SYSTEM' 'GENERATED'
Referenced by:
====================================================================================================================== cast_to_ref ====================================================================================================================== .. raw:: html CAST ( SOURCE AS REF ) WITH identifier
         ::= 'CAST' '(' 'SOURCE' 'AS' 'REF' ')' 'WITH' identifier
Referenced by:
====================================================================================================================== cast_to_type ====================================================================================================================== .. raw:: html CAST ( REF AS SOURCE ) WITH identifier
         ::= 'CAST' '(' 'REF' 'AS' 'SOURCE' ')' 'WITH' identifier
Referenced by:
====================================================================================================================== list_of_attributes ====================================================================================================================== .. raw:: html ( identifier , )
         ::= '(' identifier ( ',' identifier )* ')'
Referenced by:
====================================================================================================================== cast_to_distinct ====================================================================================================================== .. raw:: html CAST ( SOURCE AS DISTINCT ) WITH identifier
         ::= 'CAST' '(' 'SOURCE' 'AS' 'DISTINCT' ')' 'WITH' identifier
Referenced by:
====================================================================================================================== cast_to_source ====================================================================================================================== .. raw:: html CAST ( DISTINCT AS SOURCE ) WITH identifier
         ::= 'CAST' '(' 'DISTINCT' 'AS' 'SOURCE' ')' 'WITH' identifier
Referenced by:
====================================================================================================================== method_specification_list ====================================================================================================================== .. raw:: html method_specification ,
         ::= method_specification ( ',' method_specification )*
Referenced by:
====================================================================================================================== method_specification ====================================================================================================================== .. raw:: html original_method_specification overriding_method_specification
         ::= original_method_specification
           | overriding_method_specification
Referenced by:
====================================================================================================================== original_method_specification ====================================================================================================================== .. raw:: html partial_method_specification SELF AS RESULT SELF AS LOCATOR method_characteristics
         ::= partial_method_specification ( 'SELF' 'AS' 'RESULT' )? ( 'SELF' 'AS' 'LOCATOR' )? method_characteristics?
Referenced by:
====================================================================================================================== overriding_method_specification ====================================================================================================================== .. raw:: html OVERRIDING partial_method_specification
         ::= 'OVERRIDING' partial_method_specification
Referenced by:
====================================================================================================================== partial_method_specification ====================================================================================================================== .. raw:: html INSTANCE STATIC CONSTRUCTOR METHOD identifier SQL_parameter_declaration_list returns_clause SPECIFIC specific_identifier
         ::= ( 'INSTANCE' | 'STATIC' | 'CONSTRUCTOR' )? 'METHOD' identifier SQL_parameter_declaration_list returns_clause ( 'SPECIFIC' specific_identifier )?
Referenced by:
====================================================================================================================== specific_identifier ====================================================================================================================== .. raw:: html schema_name . identifier
         ::= ( schema_name '.' )? identifier
Referenced by:
====================================================================================================================== method_characteristics ====================================================================================================================== .. raw:: html method_characteristic
         ::= method_characteristic+
Referenced by:
====================================================================================================================== method_characteristic ====================================================================================================================== .. raw:: html language_clause parameter_style_clause deterministic_characteristic SQL_data_access_indication null_call_clause
         ::= language_clause
           | parameter_style_clause
           | deterministic_characteristic
           | SQL_data_access_indication
           | null_call_clause
Referenced by:
====================================================================================================================== attribute_definition ====================================================================================================================== .. raw:: html identifier data_type attribute_default collate_clause
Referenced by:
====================================================================================================================== attribute_default ====================================================================================================================== .. raw:: html default_clause
         ::= default_clause
Referenced by:
====================================================================================================================== alter_type_statement ====================================================================================================================== .. raw:: html ALTER TYPE schema_resolved_user_defined_type_name alter_type_action
         ::= 'ALTER' 'TYPE' schema_resolved_user_defined_type_name alter_type_action
Referenced by:
====================================================================================================================== alter_type_action ====================================================================================================================== .. raw:: html add_attribute_definition drop_attribute_definition add_original_method_specification add_overriding_method_specification drop_method_specification
         ::= add_attribute_definition
           | drop_attribute_definition
           | add_original_method_specification
           | add_overriding_method_specification
           | drop_method_specification
Referenced by:
====================================================================================================================== add_attribute_definition ====================================================================================================================== .. raw:: html ADD ATTRIBUTE attribute_definition
         ::= 'ADD' 'ATTRIBUTE' attribute_definition
Referenced by:
====================================================================================================================== drop_attribute_definition ====================================================================================================================== .. raw:: html DROP ATTRIBUTE identifier RESTRICT
         ::= 'DROP' 'ATTRIBUTE' identifier 'RESTRICT'
Referenced by:
====================================================================================================================== add_original_method_specification ====================================================================================================================== .. raw:: html ADD original_method_specification
         ::= 'ADD' original_method_specification
Referenced by:
====================================================================================================================== add_overriding_method_specification ====================================================================================================================== .. raw:: html ADD overriding_method_specification
         ::= 'ADD' overriding_method_specification
Referenced by:
====================================================================================================================== drop_method_specification ====================================================================================================================== .. raw:: html DROP specific_method_specification_designator RESTRICT
         ::= 'DROP' specific_method_specification_designator 'RESTRICT'
Referenced by:
====================================================================================================================== specific_method_specification_designator ====================================================================================================================== .. raw:: html INSTANCE STATIC CONSTRUCTOR METHOD identifier data_type_list
         ::= ( 'INSTANCE' | 'STATIC' | 'CONSTRUCTOR' )? 'METHOD' identifier data_type_list
Referenced by:
====================================================================================================================== drop_data_type_statement ====================================================================================================================== .. raw:: html DROP TYPE schema_resolved_user_defined_type_name drop_behavior
         ::= 'DROP' 'TYPE' schema_resolved_user_defined_type_name drop_behavior
Referenced by:
====================================================================================================================== SQL_invoked_routine ====================================================================================================================== .. raw:: html schema_routine
         ::= schema_routine
Referenced by:
====================================================================================================================== schema_routine ====================================================================================================================== .. raw:: html schema_procedure schema_function
         ::= schema_procedure
           | schema_function
Referenced by:
====================================================================================================================== schema_procedure ====================================================================================================================== .. raw:: html CREATE SQL_invoked_procedure
         ::= 'CREATE' SQL_invoked_procedure
Referenced by:
====================================================================================================================== schema_function ====================================================================================================================== .. raw:: html CREATE or_replace SQL_invoked_function
         ::= 'CREATE' or_replace? SQL_invoked_function
Referenced by:
====================================================================================================================== SQL_invoked_procedure ====================================================================================================================== .. raw:: html PROCEDURE schema_qualified_name SQL_parameter_declaration_list routine_characteristics routine_body
Referenced by:
====================================================================================================================== SQL_invoked_function ====================================================================================================================== .. raw:: html function_specification method_specification_designator routine_body
Referenced by:
====================================================================================================================== SQL_parameter_declaration_list ====================================================================================================================== .. raw:: html ( SQL_parameter_declaration , )
         ::= '(' ( SQL_parameter_declaration ( ',' SQL_parameter_declaration )* )? ')'
Referenced by:
====================================================================================================================== SQL_parameter_declaration ====================================================================================================================== .. raw:: html parameter_mode identifier parameter_type RESULT DEFAULT parameter_default
         ::= parameter_mode? identifier? parameter_type 'RESULT'? ( 'DEFAULT' parameter_default )?
Referenced by:
====================================================================================================================== parameter_default ====================================================================================================================== .. raw:: html value_expression contextually_typed_value_specification
         ::= value_expression
Referenced by:
====================================================================================================================== parameter_mode ====================================================================================================================== .. raw:: html IN OUT INOUT
         ::= 'IN'
           | 'OUT'
           | 'INOUT'
Referenced by:
====================================================================================================================== parameter_type ====================================================================================================================== .. raw:: html data_type locator_indication
         ::= data_type locator_indication?
Referenced by:
====================================================================================================================== locator_indication ====================================================================================================================== .. raw:: html AS LOCATOR
         ::= 'AS' 'LOCATOR'
Referenced by:
====================================================================================================================== function_specification ====================================================================================================================== .. raw:: html FUNCTION schema_qualified_name SQL_parameter_declaration_list returns_clause routine_description routine_characteristics dispatch_clause
Referenced by:
====================================================================================================================== method_specification_designator ====================================================================================================================== .. raw:: html SPECIFIC METHOD specific_identifier INSTANCE STATIC CONSTRUCTOR METHOD identifier SQL_parameter_declaration_list returns_clause FOR schema_resolved_user_defined_type_name
         ::= 'SPECIFIC' 'METHOD' specific_identifier
           | ( 'INSTANCE' | 'STATIC' | 'CONSTRUCTOR' )? 'METHOD' identifier SQL_parameter_declaration_list returns_clause? 'FOR' schema_resolved_user_defined_type_name
Referenced by:
====================================================================================================================== routine_characteristics ====================================================================================================================== .. raw:: html routine_characteristic
         ::= routine_characteristic*
Referenced by:
====================================================================================================================== routine_characteristic ====================================================================================================================== .. raw:: html language_clause parameter_style_clause SPECIFIC schema_qualified_name deterministic_characteristic SQL_data_access_indication null_call_clause returned_result_sets_characteristic savepoint_level_indication
         ::= language_clause
           | parameter_style_clause
           | 'SPECIFIC' schema_qualified_name
           | deterministic_characteristic
           | SQL_data_access_indication
           | null_call_clause
           | returned_result_sets_characteristic
           | savepoint_level_indication
Referenced by:
====================================================================================================================== savepoint_level_indication ====================================================================================================================== .. raw:: html NEW OLD SAVEPOINT LEVEL
         ::= ( 'NEW' | 'OLD' ) 'SAVEPOINT' 'LEVEL'
Referenced by:
====================================================================================================================== returned_result_sets_characteristic ====================================================================================================================== .. raw:: html DYNAMIC RESULT SETS maximum_returned_result_sets
         ::= 'DYNAMIC' 'RESULT' 'SETS' maximum_returned_result_sets
Referenced by:
====================================================================================================================== parameter_style_clause ====================================================================================================================== .. raw:: html PARAMETER STYLE parameter_style
         ::= 'PARAMETER' 'STYLE' parameter_style
Referenced by:
====================================================================================================================== dispatch_clause ====================================================================================================================== .. raw:: html STATIC DISPATCH
         ::= 'STATIC' 'DISPATCH'
Referenced by:
====================================================================================================================== returns_clause ====================================================================================================================== .. raw:: html RETURNS returns_type
         ::= 'RETURNS' returns_type
Referenced by:
====================================================================================================================== returns_type ====================================================================================================================== .. raw:: html returns_data_type result_cast returns_table_type
         ::= returns_data_type result_cast?
           | returns_table_type
Referenced by:
====================================================================================================================== returns_table_type ====================================================================================================================== .. raw:: html TABLE table_function_column_list
         ::= 'TABLE' table_function_column_list
Referenced by:
====================================================================================================================== table_function_column_list ====================================================================================================================== .. raw:: html ( table_function_column_list_element , )
Referenced by:
====================================================================================================================== table_function_column_list_element ====================================================================================================================== .. raw:: html identifier data_type
         ::= identifier data_type
Referenced by:
====================================================================================================================== result_cast ====================================================================================================================== .. raw:: html CAST FROM result_cast_from_type
         ::= 'CAST' 'FROM' result_cast_from_type
Referenced by:
====================================================================================================================== result_cast_from_type ====================================================================================================================== .. raw:: html data_type locator_indication
         ::= data_type locator_indication?
Referenced by:
====================================================================================================================== returns_data_type ====================================================================================================================== .. raw:: html data_type locator_indication
         ::= data_type locator_indication?
Referenced by:
====================================================================================================================== routine_body ====================================================================================================================== .. raw:: html SQL_routine_spec external_body_reference
         ::= SQL_routine_spec
           | external_body_reference
Referenced by:
====================================================================================================================== SQL_routine_spec ====================================================================================================================== .. raw:: html rights_clause SQL_routine_body
         ::= rights_clause? SQL_routine_body
Referenced by:
====================================================================================================================== rights_clause ====================================================================================================================== .. raw:: html SQL SECURITY INVOKER DEFINER
         ::= 'SQL' 'SECURITY' ( 'INVOKER' | 'DEFINER' )
Referenced by:
====================================================================================================================== SQL_routine_body ====================================================================================================================== .. raw:: html SQL_procedure_statement
         ::= SQL_procedure_statement
Referenced by:
====================================================================================================================== external_body_reference ====================================================================================================================== .. raw:: html EXTERNAL NAME external_routine_name parameter_style_clause transform_group_specification external_security_clause
Referenced by:
====================================================================================================================== external_security_clause ====================================================================================================================== .. raw:: html EXTERNAL SECURITY DEFINER INVOKER IMPLEMENTATION DEFINED
         ::= 'EXTERNAL' 'SECURITY' ( 'DEFINER' | 'INVOKER' | 'IMPLEMENTATION' 'DEFINED' )
Referenced by:
====================================================================================================================== parameter_style ====================================================================================================================== .. raw:: html SQL GENERAL
         ::= 'SQL'
           | 'GENERAL'
Referenced by:
====================================================================================================================== deterministic_characteristic ====================================================================================================================== .. raw:: html NOT DETERMINISTIC
         ::= 'NOT'? 'DETERMINISTIC'
Referenced by:
====================================================================================================================== SQL_data_access_indication ====================================================================================================================== .. raw:: html NO CONTAINS SQL READS MODIFIES SQL DATA
         ::= ( 'NO' | 'CONTAINS' ) 'SQL'
           | ( 'READS' | 'MODIFIES' ) 'SQL' 'DATA'
Referenced by:
====================================================================================================================== null_call_clause ====================================================================================================================== .. raw:: html RETURNS NULL CALLED ON NULL INPUT
         ::= ( 'RETURNS' 'NULL' | 'CALLED' ) 'ON' 'NULL' 'INPUT'
Referenced by:
====================================================================================================================== maximum_returned_result_sets ====================================================================================================================== .. raw:: html unsigned_integer
         ::= unsigned_integer
Referenced by:
====================================================================================================================== transform_group_specification ====================================================================================================================== .. raw:: html TRANSFORM GROUP single_group_specification multiple_group_specification
         ::= 'TRANSFORM' 'GROUP' ( single_group_specification | multiple_group_specification )
Referenced by:
====================================================================================================================== single_group_specification ====================================================================================================================== .. raw:: html identifier
         ::= identifier
Referenced by:
====================================================================================================================== multiple_group_specification ====================================================================================================================== .. raw:: html group_specification ,
         ::= group_specification ( ',' group_specification )*
Referenced by:
====================================================================================================================== group_specification ====================================================================================================================== .. raw:: html identifier FOR TYPE path_resolved_user_defined_type_name
         ::= identifier 'FOR' 'TYPE' path_resolved_user_defined_type_name
Referenced by:
====================================================================================================================== alter_routine_statement ====================================================================================================================== .. raw:: html ALTER specific_routine_designator alter_routine_characteristics RESTRICT
         ::= 'ALTER' specific_routine_designator alter_routine_characteristics 'RESTRICT'
Referenced by:
====================================================================================================================== alter_routine_characteristics ====================================================================================================================== .. raw:: html alter_routine_characteristic
         ::= alter_routine_characteristic+
Referenced by:
====================================================================================================================== alter_routine_characteristic ====================================================================================================================== .. raw:: html language_clause parameter_style_clause SQL_data_access_indication null_call_clause returned_result_sets_characteristic NAME external_routine_name
         ::= language_clause
           | parameter_style_clause
           | SQL_data_access_indication
           | null_call_clause
           | returned_result_sets_characteristic
           | 'NAME' external_routine_name
Referenced by:
====================================================================================================================== drop_routine_statement ====================================================================================================================== .. raw:: html DROP specific_routine_designator drop_behavior
         ::= 'DROP' specific_routine_designator drop_behavior
Referenced by:
====================================================================================================================== user_defined_cast_definition ====================================================================================================================== .. raw:: html CREATE CAST ( source_data_type AS target_data_type ) WITH cast_function AS ASSIGNMENT
         ::= 'CREATE' 'CAST' '(' source_data_type 'AS' target_data_type ')' 'WITH' cast_function ( 'AS' 'ASSIGNMENT' )?
Referenced by:
====================================================================================================================== cast_function ====================================================================================================================== .. raw:: html specific_routine_designator
         ::= specific_routine_designator
Referenced by:
====================================================================================================================== source_data_type ====================================================================================================================== .. raw:: html data_type
         ::= data_type
Referenced by:
====================================================================================================================== target_data_type ====================================================================================================================== .. raw:: html data_type
         ::= data_type
Referenced by:
====================================================================================================================== drop_user_defined_cast_statement ====================================================================================================================== .. raw:: html DROP CAST ( source_data_type AS target_data_type ) drop_behavior
         ::= 'DROP' 'CAST' '(' source_data_type 'AS' target_data_type ')' drop_behavior
Referenced by:
====================================================================================================================== user_defined_ordering_definition ====================================================================================================================== .. raw:: html CREATE ORDERING FOR schema_resolved_user_defined_type_name ordering_form
         ::= 'CREATE' 'ORDERING' 'FOR' schema_resolved_user_defined_type_name ordering_form
Referenced by:
====================================================================================================================== ordering_form ====================================================================================================================== .. raw:: html equals_ordering_form full_ordering_form
         ::= equals_ordering_form
           | full_ordering_form
Referenced by:
====================================================================================================================== equals_ordering_form ====================================================================================================================== .. raw:: html EQUALS ONLY BY ordering_category
         ::= 'EQUALS' 'ONLY' 'BY' ordering_category
Referenced by:
====================================================================================================================== full_ordering_form ====================================================================================================================== .. raw:: html ORDER FULL BY ordering_category
         ::= 'ORDER' 'FULL' 'BY' ordering_category
Referenced by:
====================================================================================================================== ordering_category ====================================================================================================================== .. raw:: html relative_category map_category state_category
         ::= relative_category
           | map_category
           | state_category
Referenced by:
====================================================================================================================== relative_category ====================================================================================================================== .. raw:: html RELATIVE WITH relative_function_specification
         ::= 'RELATIVE' 'WITH' relative_function_specification
Referenced by:
====================================================================================================================== map_category ====================================================================================================================== .. raw:: html MAP WITH map_function_specification
         ::= 'MAP' 'WITH' map_function_specification
Referenced by:
====================================================================================================================== state_category ====================================================================================================================== .. raw:: html STATE schema_qualified_name
         ::= 'STATE' schema_qualified_name?
Referenced by:
====================================================================================================================== relative_function_specification ====================================================================================================================== .. raw:: html specific_routine_designator
         ::= specific_routine_designator
Referenced by:
====================================================================================================================== map_function_specification ====================================================================================================================== .. raw:: html specific_routine_designator
         ::= specific_routine_designator
Referenced by:
====================================================================================================================== drop_user_defined_ordering_statement ====================================================================================================================== .. raw:: html DROP ORDERING FOR schema_resolved_user_defined_type_name drop_behavior
         ::= 'DROP' 'ORDERING' 'FOR' schema_resolved_user_defined_type_name drop_behavior
Referenced by:
====================================================================================================================== transform_definition ====================================================================================================================== .. raw:: html CREATE TRANSFORM TRANSFORMS FOR schema_resolved_user_defined_type_name transform_group
         ::= 'CREATE' ( 'TRANSFORM' | 'TRANSFORMS' ) 'FOR' schema_resolved_user_defined_type_name transform_group+
Referenced by:
====================================================================================================================== transform_group ====================================================================================================================== .. raw:: html identifier ( transform_element_list )
         ::= identifier '(' transform_element_list ')'
Referenced by:
====================================================================================================================== transform_element_list ====================================================================================================================== .. raw:: html transform_element , transform_element
         ::= transform_element ( ',' transform_element )?
Referenced by:
====================================================================================================================== transform_element ====================================================================================================================== .. raw:: html to_sql from_sql
         ::= to_sql
           | from_sql
Referenced by:
====================================================================================================================== to_sql ====================================================================================================================== .. raw:: html TO SQL WITH to_sql_function
to_sql   ::= 'TO' 'SQL' 'WITH' to_sql_function
Referenced by:
====================================================================================================================== from_sql ====================================================================================================================== .. raw:: html FROM SQL WITH from_sql_function
from_sql ::= 'FROM' 'SQL' 'WITH' from_sql_function
Referenced by:
====================================================================================================================== to_sql_function ====================================================================================================================== .. raw:: html specific_routine_designator
         ::= specific_routine_designator
Referenced by:
====================================================================================================================== from_sql_function ====================================================================================================================== .. raw:: html specific_routine_designator
         ::= specific_routine_designator
Referenced by:
====================================================================================================================== alter_transform_statement ====================================================================================================================== .. raw:: html ALTER TRANSFORM TRANSFORMS FOR schema_resolved_user_defined_type_name alter_group
         ::= 'ALTER' ( 'TRANSFORM' | 'TRANSFORMS' ) 'FOR' schema_resolved_user_defined_type_name alter_group+
Referenced by:
====================================================================================================================== alter_group ====================================================================================================================== .. raw:: html identifier ( alter_transform_action_list )
         ::= identifier '(' alter_transform_action_list ')'
Referenced by:
====================================================================================================================== alter_transform_action_list ====================================================================================================================== .. raw:: html alter_transform_action ,
         ::= alter_transform_action ( ',' alter_transform_action )*
Referenced by:
====================================================================================================================== alter_transform_action ====================================================================================================================== .. raw:: html add_transform_element_list drop_transform_element_list
         ::= add_transform_element_list
           | drop_transform_element_list
Referenced by:
====================================================================================================================== add_transform_element_list ====================================================================================================================== .. raw:: html ADD ( transform_element_list )
         ::= 'ADD' '(' transform_element_list ')'
Referenced by:
====================================================================================================================== drop_transform_element_list ====================================================================================================================== .. raw:: html DROP ( transform_kind , transform_kind drop_behavior )
         ::= 'DROP' '(' transform_kind ( ',' transform_kind )? drop_behavior ')'
Referenced by:
====================================================================================================================== transform_kind ====================================================================================================================== .. raw:: html TO FROM SQL
         ::= ( 'TO' | 'FROM' ) 'SQL'
Referenced by:
====================================================================================================================== drop_transform_statement ====================================================================================================================== .. raw:: html DROP TRANSFORM TRANSFORMS transforms_to_be_dropped FOR schema_resolved_user_defined_type_name drop_behavior
         ::= 'DROP' ( 'TRANSFORM' | 'TRANSFORMS' ) transforms_to_be_dropped 'FOR' schema_resolved_user_defined_type_name drop_behavior
Referenced by:
====================================================================================================================== transforms_to_be_dropped ====================================================================================================================== .. raw:: html ALL transform_group_element
         ::= 'ALL'
           | transform_group_element
Referenced by:
====================================================================================================================== transform_group_element ====================================================================================================================== .. raw:: html identifier
         ::= identifier
Referenced by:
====================================================================================================================== sequence_generator_definition ====================================================================================================================== .. raw:: html CREATE SEQUENCE schema_qualified_name sequence_generator_options
         ::= 'CREATE' 'SEQUENCE' schema_qualified_name sequence_generator_options?
Referenced by:
====================================================================================================================== sequence_generator_options ====================================================================================================================== .. raw:: html sequence_generator_option
         ::= sequence_generator_option+
Referenced by:
====================================================================================================================== sequence_generator_option ====================================================================================================================== .. raw:: html sequence_generator_data_type_option common_sequence_generator_options
           | common_sequence_generator_options
Referenced by:
====================================================================================================================== common_sequence_generator_options ====================================================================================================================== .. raw:: html common_sequence_generator_option
         ::= common_sequence_generator_option+
Referenced by:
====================================================================================================================== common_sequence_generator_option ====================================================================================================================== .. raw:: html sequence_generator_start_with_option basic_sequence_generator_option
           | basic_sequence_generator_option
Referenced by:
====================================================================================================================== basic_sequence_generator_option ====================================================================================================================== .. raw:: html sequence_generator_increment_by_option sequence_generator_maxvalue_option sequence_generator_minvalue_option sequence_generator_cycle_option
           | sequence_generator_maxvalue_option
           | sequence_generator_minvalue_option
           | sequence_generator_cycle_option
Referenced by:
====================================================================================================================== sequence_generator_data_type_option ====================================================================================================================== .. raw:: html AS data_type
         ::= 'AS' data_type
Referenced by:
====================================================================================================================== sequence_generator_start_with_option ====================================================================================================================== .. raw:: html START WITH sequence_generator_start_value
         ::= 'START' 'WITH' sequence_generator_start_value
Referenced by:
====================================================================================================================== sequence_generator_start_value ====================================================================================================================== .. raw:: html signed_numeric_literal
         ::= signed_numeric_literal
Referenced by:
====================================================================================================================== sequence_generator_increment_by_option ====================================================================================================================== .. raw:: html INCREMENT BY sequence_generator_increment
         ::= 'INCREMENT' 'BY' sequence_generator_increment
Referenced by:
====================================================================================================================== sequence_generator_increment ====================================================================================================================== .. raw:: html signed_numeric_literal
         ::= signed_numeric_literal
Referenced by:
====================================================================================================================== sequence_generator_maxvalue_option ====================================================================================================================== .. raw:: html MAXVALUE sequence_generator_max_value NO MAXVALUE
         ::= 'MAXVALUE' sequence_generator_max_value
           | 'NO' 'MAXVALUE'
Referenced by:
====================================================================================================================== sequence_generator_max_value ====================================================================================================================== .. raw:: html signed_numeric_literal
         ::= signed_numeric_literal
Referenced by:
====================================================================================================================== sequence_generator_minvalue_option ====================================================================================================================== .. raw:: html MINVALUE sequence_generator_min_value NO MINVALUE
         ::= 'MINVALUE' sequence_generator_min_value
           | 'NO' 'MINVALUE'
Referenced by:
====================================================================================================================== sequence_generator_min_value ====================================================================================================================== .. raw:: html signed_numeric_literal
         ::= signed_numeric_literal
Referenced by:
====================================================================================================================== sequence_generator_cycle_option ====================================================================================================================== .. raw:: html NO CYCLE
         ::= 'NO'? 'CYCLE'
Referenced by:
====================================================================================================================== alter_sequence_generator_statement ====================================================================================================================== .. raw:: html ALTER SEQUENCE schema_qualified_name alter_sequence_generator_options
         ::= 'ALTER' 'SEQUENCE' schema_qualified_name alter_sequence_generator_options
Referenced by:
====================================================================================================================== alter_sequence_generator_options ====================================================================================================================== .. raw:: html alter_sequence_generator_option
         ::= alter_sequence_generator_option+
Referenced by:
====================================================================================================================== alter_sequence_generator_option ====================================================================================================================== .. raw:: html alter_sequence_generator_restart_option basic_sequence_generator_option
           | basic_sequence_generator_option
Referenced by:
====================================================================================================================== alter_sequence_generator_restart_option ====================================================================================================================== .. raw:: html RESTART WITH sequence_generator_restart_value
         ::= 'RESTART' ( 'WITH' sequence_generator_restart_value )?
Referenced by:
====================================================================================================================== sequence_generator_restart_value ====================================================================================================================== .. raw:: html signed_numeric_literal
         ::= signed_numeric_literal
Referenced by:
====================================================================================================================== drop_sequence_generator_statement ====================================================================================================================== .. raw:: html DROP SEQUENCE schema_qualified_name drop_behavior
         ::= 'DROP' 'SEQUENCE' schema_qualified_name drop_behavior
Referenced by:
====================================================================================================================== grant_statement ====================================================================================================================== .. raw:: html grant_privilege_statement grant_role_statement
         ::= grant_privilege_statement
           | grant_role_statement
Referenced by:
====================================================================================================================== grant_privilege_statement ====================================================================================================================== .. raw:: html GRANT privileges TO grantee , WITH HIERARCHY OPTION WITH GRANT OPTION GRANTED BY grantor
         ::= 'GRANT' privileges 'TO' grantee ( ',' grantee )* ( 'WITH' 'HIERARCHY' 'OPTION' )? ( 'WITH' 'GRANT' 'OPTION' )? ( 'GRANTED' 'BY' grantor )?
Referenced by:
====================================================================================================================== privileges ====================================================================================================================== .. raw:: html object_privileges ON object_name
         ::= object_privileges 'ON' object_name
Referenced by:
====================================================================================================================== object_name ====================================================================================================================== .. raw:: html TABLE table_name DOMAIN COLLATION TRANSLATION SEQUENCE schema_qualified_name CHARACTER SET character_set_name TYPE schema_resolved_user_defined_type_name specific_routine_designator
         ::= 'TABLE'? table_name
           | ( 'DOMAIN' | 'COLLATION' | 'TRANSLATION' | 'SEQUENCE' ) schema_qualified_name
           | 'CHARACTER' 'SET' character_set_name
           | 'TYPE' schema_resolved_user_defined_type_name
           | specific_routine_designator
Referenced by:
====================================================================================================================== object_privileges ====================================================================================================================== .. raw:: html ALL PRIVILEGES action ,
         ::= 'ALL' 'PRIVILEGES'
           | action ( ',' action )*
Referenced by:
====================================================================================================================== action ====================================================================================================================== .. raw:: html SELECT ( privilege_column_list privilege_method_list ) DELETE INSERT UPDATE REFERENCES ( privilege_column_list ) USAGE TRIGGER UNDER EXECUTE
action   ::= 'SELECT' ( '(' ( privilege_column_list | privilege_method_list ) ')' )?
           | 'DELETE'
           | ( 'INSERT' | 'UPDATE' | 'REFERENCES' ) ( '(' privilege_column_list ')' )?
           | 'USAGE'
           | 'TRIGGER'
           | 'UNDER'
           | 'EXECUTE'
Referenced by:
====================================================================================================================== privilege_method_list ====================================================================================================================== .. raw:: html specific_routine_designator ,
Referenced by:
====================================================================================================================== privilege_column_list ====================================================================================================================== .. raw:: html column_name_list
         ::= column_name_list
Referenced by:
====================================================================================================================== grantee ====================================================================================================================== .. raw:: html PUBLIC identifier
grantee  ::= 'PUBLIC'
           | identifier
Referenced by:
====================================================================================================================== grantor ====================================================================================================================== .. raw:: html CURRENT_USER CURRENT_ROLE
grantor  ::= 'CURRENT_USER'
           | 'CURRENT_ROLE'
Referenced by:
====================================================================================================================== role_definition ====================================================================================================================== .. raw:: html CREATE ROLE identifier WITH ADMIN grantor
         ::= 'CREATE' 'ROLE' identifier ( 'WITH' 'ADMIN' grantor )?
Referenced by:
====================================================================================================================== grant_role_statement ====================================================================================================================== .. raw:: html GRANT identifier , TO grantee , WITH ADMIN OPTION GRANTED BY grantor
         ::= 'GRANT' identifier ( ',' identifier )* 'TO' grantee ( ',' grantee )* ( 'WITH' 'ADMIN' 'OPTION' )? ( 'GRANTED' 'BY' grantor )?
Referenced by:
====================================================================================================================== drop_role_statement ====================================================================================================================== .. raw:: html DROP ROLE identifier
         ::= 'DROP' 'ROLE' identifier
Referenced by:
====================================================================================================================== revoke_statement ====================================================================================================================== .. raw:: html revoke_privilege_statement revoke_role_statement
         ::= revoke_privilege_statement
           | revoke_role_statement
Referenced by:
====================================================================================================================== revoke_privilege_statement ====================================================================================================================== .. raw:: html REVOKE revoke_option_extension privileges FROM grantee , GRANTED BY grantor drop_behavior
         ::= 'REVOKE' revoke_option_extension? privileges 'FROM' grantee ( ',' grantee )* ( 'GRANTED' 'BY' grantor )? drop_behavior
Referenced by:
====================================================================================================================== revoke_option_extension ====================================================================================================================== .. raw:: html GRANT HIERARCHY OPTION FOR
         ::= ( 'GRANT' | 'HIERARCHY' ) 'OPTION' 'FOR'
Referenced by:
====================================================================================================================== revoke_role_statement ====================================================================================================================== .. raw:: html REVOKE ADMIN OPTION FOR identifier , FROM grantee , GRANTED BY grantor drop_behavior
         ::= 'REVOKE' ( 'ADMIN' 'OPTION' 'FOR' )? identifier ( ',' identifier )* 'FROM' grantee ( ',' grantee )* ( 'GRANTED' 'BY' grantor )? drop_behavior
Referenced by:
====================================================================================================================== SQL_client_module_definition ====================================================================================================================== .. raw:: html module_name_clause language_clause module_authorization_clause module_path_specification module_transform_group_specification module_collations temporary_table_declaration module_contents
Not referenced by any.
====================================================================================================================== module_authorization_clause ====================================================================================================================== .. raw:: html SCHEMA schema_name AUTHORIZATION identifier FOR STATIC ONLY AND DYNAMIC AUTHORIZATION identifier FOR STATIC ONLY AND DYNAMIC
         ::= 'SCHEMA' schema_name ( 'AUTHORIZATION' identifier ( 'FOR' 'STATIC' ( 'ONLY' | 'AND' 'DYNAMIC' ) )? )?
           | 'AUTHORIZATION' identifier ( 'FOR' 'STATIC' ( 'ONLY' | 'AND' 'DYNAMIC' ) )?
Referenced by:
====================================================================================================================== module_path_specification ====================================================================================================================== .. raw:: html path_specification
         ::= path_specification
Referenced by:
====================================================================================================================== module_transform_group_specification ====================================================================================================================== .. raw:: html transform_group_specification
         ::= transform_group_specification
Referenced by:
====================================================================================================================== module_collations ====================================================================================================================== .. raw:: html module_collation_specification
         ::= module_collation_specification+
Referenced by:
====================================================================================================================== module_collation_specification ====================================================================================================================== .. raw:: html COLLATION schema_qualified_name FOR character_set_specification_list
         ::= 'COLLATION' schema_qualified_name ( 'FOR' character_set_specification_list )?
Referenced by:
====================================================================================================================== character_set_specification_list ====================================================================================================================== .. raw:: html character_set_specification ,
Referenced by:
====================================================================================================================== module_contents ====================================================================================================================== .. raw:: html declare_cursor dynamic_declare_cursor externally_invoked_procedure
         ::= declare_cursor
           | dynamic_declare_cursor
           | externally_invoked_procedure
Referenced by:
====================================================================================================================== module_name_clause ====================================================================================================================== .. raw:: html MODULE identifier module_character_set_specification
         ::= 'MODULE' identifier? module_character_set_specification?
Referenced by:
====================================================================================================================== module_character_set_specification ====================================================================================================================== .. raw:: html NAMES ARE character_set_specification
         ::= 'NAMES' 'ARE' character_set_specification
Referenced by:
====================================================================================================================== externally_invoked_procedure ====================================================================================================================== .. raw:: html PROCEDURE identifier host_parameter_declaration_list ; SQL_procedure_statement ;
         ::= 'PROCEDURE' identifier host_parameter_declaration_list ';' SQL_procedure_statement ';'
Referenced by:
====================================================================================================================== host_parameter_declaration_list ====================================================================================================================== .. raw:: html ( host_parameter_declaration , )
         ::= '(' host_parameter_declaration ( ',' host_parameter_declaration )* ')'
Referenced by:
====================================================================================================================== host_parameter_declaration ====================================================================================================================== .. raw:: html host_parameter_name host_parameter_data_type SQLSTATE
           | 'SQLSTATE'
Referenced by:
====================================================================================================================== host_parameter_data_type ====================================================================================================================== .. raw:: html data_type locator_indication
         ::= data_type locator_indication?
Referenced by:
====================================================================================================================== SQL_procedure_statement ====================================================================================================================== .. raw:: html SQL_executable_statement
         ::= SQL_executable_statement
Referenced by:
====================================================================================================================== SQL_executable_statement ====================================================================================================================== .. raw:: html SQL_schema_statement SQL_data_statement SQL_control_statement SQL_transaction_statement SQL_connection_statement SQL_session_statement SQL_diagnostics_statement SQL_dynamic_statement
         ::= SQL_schema_statement
           | SQL_data_statement
           | SQL_control_statement
           | SQL_transaction_statement
           | SQL_connection_statement
           | SQL_session_statement
           | SQL_diagnostics_statement
           | SQL_dynamic_statement
Referenced by:
====================================================================================================================== SQL_schema_statement ====================================================================================================================== .. raw:: html SQL_schema_definition_statement SQL_schema_manipulation_statement
         ::= SQL_schema_definition_statement
           | SQL_schema_manipulation_statement
Referenced by:
====================================================================================================================== SQL_schema_definition_statement ====================================================================================================================== .. raw:: html schema_definition table_definition view_definition SQL_invoked_routine grant_statement role_definition domain_definition character_set_definition collation_definition transliteration_definition assertion_definition trigger_definition user_defined_type_definition user_defined_cast_definition user_defined_ordering_definition transform_definition sequence_generator_definition
         ::= schema_definition
           | table_definition
           | view_definition
           | SQL_invoked_routine
           | grant_statement
           | role_definition
           | domain_definition
           | character_set_definition
           | collation_definition
           | transliteration_definition
           | assertion_definition
           | trigger_definition
           | user_defined_type_definition
           | user_defined_cast_definition
           | user_defined_ordering_definition
           | transform_definition
           | sequence_generator_definition
Referenced by:
====================================================================================================================== SQL_schema_manipulation_statement ====================================================================================================================== .. raw:: html drop_schema_statement alter_table_statement drop_table_statement drop_view_statement alter_routine_statement drop_routine_statement drop_user_defined_cast_statement revoke_statement drop_role_statement alter_domain_statement drop_domain_statement drop_character_set_statement drop_collation_statement drop_transliteration_statement drop_assertion_statement drop_trigger_statement alter_type_statement drop_data_type_statement drop_user_defined_ordering_statement alter_transform_statement drop_transform_statement alter_sequence_generator_statement drop_sequence_generator_statement
         ::= drop_schema_statement
           | alter_table_statement
           | drop_table_statement
           | drop_view_statement
           | alter_routine_statement
           | drop_routine_statement
           | drop_user_defined_cast_statement
           | revoke_statement
           | drop_role_statement
           | alter_domain_statement
           | drop_domain_statement
           | drop_character_set_statement
           | drop_collation_statement
           | drop_transliteration_statement
           | drop_assertion_statement
           | drop_trigger_statement
           | alter_type_statement
           | drop_data_type_statement
           | drop_user_defined_ordering_statement
           | alter_transform_statement
           | drop_transform_statement
           | alter_sequence_generator_statement
           | drop_sequence_generator_statement
Referenced by:
====================================================================================================================== SQL_data_statement ====================================================================================================================== .. raw:: html open_statement fetch_statement close_statement select_statement_single_row SQL_data_change_statement
         ::= open_statement
           | fetch_statement
           | close_statement
           | select_statement_single_row
           | SQL_data_change_statement
Referenced by:
====================================================================================================================== SQL_data_change_statement ====================================================================================================================== .. raw:: html delete_statement_positioned delete_statement_searched insert_statement update_statement_positioned update_statement_searched truncate_table_statement merge_statement
         ::= delete_statement_positioned
           | delete_statement_searched
           | insert_statement
           | update_statement_positioned
           | update_statement_searched
           | truncate_table_statement
           | merge_statement
Referenced by:
====================================================================================================================== SQL_control_statement ====================================================================================================================== .. raw:: html call_statement return_statement
         ::= call_statement
           | return_statement
Referenced by:
====================================================================================================================== SQL_transaction_statement ====================================================================================================================== .. raw:: html start_transaction_statement set_transaction_statement set_constraints_mode_statement savepoint_statement release_savepoint_statement commit_statement rollback_statement
         ::= start_transaction_statement
           | set_transaction_statement
           | set_constraints_mode_statement
           | savepoint_statement
           | release_savepoint_statement
           | commit_statement
           | rollback_statement
Referenced by:
====================================================================================================================== SQL_connection_statement ====================================================================================================================== .. raw:: html connect_statement set_connection_statement disconnect_statement
         ::= connect_statement
           | set_connection_statement
           | disconnect_statement
Referenced by:
====================================================================================================================== SQL_session_statement ====================================================================================================================== .. raw:: html set_session_user_identifier_statement set_role_statement set_local_time_zone_statement set_session_characteristics_statement set_catalog_statement set_schema_statement set_names_statement set_path_statement set_transform_group_statement set_session_collation_statement
           | set_role_statement
           | set_local_time_zone_statement
           | set_catalog_statement
           | set_schema_statement
           | set_names_statement
           | set_path_statement
           | set_transform_group_statement
           | set_session_collation_statement
Referenced by:
====================================================================================================================== SQL_diagnostics_statement ====================================================================================================================== .. raw:: html get_diagnostics_statement
         ::= get_diagnostics_statement
Referenced by:
====================================================================================================================== SQL_dynamic_statement ====================================================================================================================== .. raw:: html SQL_descriptor_statement prepare_statement deallocate_prepared_statement describe_statement execute_statement execute_immediate_statement SQL_dynamic_data_statement
         ::= SQL_descriptor_statement
           | prepare_statement
           | deallocate_prepared_statement
           | describe_statement
           | execute_statement
           | execute_immediate_statement
           | SQL_dynamic_data_statement
Referenced by:
====================================================================================================================== SQL_dynamic_data_statement ====================================================================================================================== .. raw:: html allocate_cursor_statement dynamic_open_statement dynamic_fetch_statement dynamic_close_statement dynamic_delete_statement_positioned dynamic_update_statement_positioned
         ::= allocate_cursor_statement
           | dynamic_open_statement
           | dynamic_fetch_statement
           | dynamic_close_statement
           | dynamic_delete_statement_positioned
           | dynamic_update_statement_positioned
Referenced by:
====================================================================================================================== SQL_descriptor_statement ====================================================================================================================== .. raw:: html allocate_descriptor_statement deallocate_descriptor_statement set_descriptor_statement get_descriptor_statement
         ::= allocate_descriptor_statement
           | deallocate_descriptor_statement
           | set_descriptor_statement
           | get_descriptor_statement
Referenced by:
====================================================================================================================== declare_cursor ====================================================================================================================== .. raw:: html DECLARE cursor_name cursor_properties FOR cursor_specification
         ::= 'DECLARE' cursor_name cursor_properties 'FOR' cursor_specification
Referenced by:
====================================================================================================================== cursor_properties ====================================================================================================================== .. raw:: html cursor_sensitivity cursor_scrollability CURSOR cursor_holdability cursor_returnability
Referenced by:
====================================================================================================================== cursor_sensitivity ====================================================================================================================== .. raw:: html SENSITIVE INSENSITIVE ASENSITIVE
         ::= 'SENSITIVE'
           | 'INSENSITIVE'
           | 'ASENSITIVE'
Referenced by:
====================================================================================================================== cursor_scrollability ====================================================================================================================== .. raw:: html NO SCROLL
         ::= 'NO'? 'SCROLL'
Referenced by:
====================================================================================================================== cursor_holdability ====================================================================================================================== .. raw:: html WITH WITHOUT HOLD
         ::= ( 'WITH' | 'WITHOUT' ) 'HOLD'
Referenced by:
====================================================================================================================== cursor_returnability ====================================================================================================================== .. raw:: html WITH WITHOUT RETURN
         ::= ( 'WITH' | 'WITHOUT' ) 'RETURN'
Referenced by:
====================================================================================================================== cursor_specification ====================================================================================================================== .. raw:: html query_expression updatability_clause
         ::= query_expression updatability_clause?
Referenced by:
====================================================================================================================== updatability_clause ====================================================================================================================== .. raw:: html FOR READ ONLY UPDATE OF column_name_list
         ::= 'FOR' ( 'READ' 'ONLY' | 'UPDATE' ( 'OF' column_name_list )? )
Referenced by:
====================================================================================================================== open_statement ====================================================================================================================== .. raw:: html OPEN cursor_name
         ::= 'OPEN' cursor_name
Referenced by:
====================================================================================================================== fetch_statement ====================================================================================================================== .. raw:: html FETCH fetch_orientation FROM cursor_name INTO fetch_target_list
         ::= 'FETCH' ( fetch_orientation? 'FROM' )? cursor_name 'INTO' fetch_target_list
Referenced by:
====================================================================================================================== fetch_orientation ====================================================================================================================== .. raw:: html NEXT PRIOR FIRST LAST ABSOLUTE RELATIVE simple_value_specification
         ::= 'NEXT'
           | 'PRIOR'
           | 'FIRST'
           | 'LAST'
           | ( 'ABSOLUTE' | 'RELATIVE' ) simple_value_specification
Referenced by:
====================================================================================================================== fetch_target_list ====================================================================================================================== .. raw:: html target_specification ,
         ::= target_specification ( ',' target_specification )*
Referenced by:
====================================================================================================================== close_statement ====================================================================================================================== .. raw:: html CLOSE cursor_name
         ::= 'CLOSE' cursor_name
Referenced by:
====================================================================================================================== select_statement_single_row ====================================================================================================================== .. raw:: html SELECT set_quantifier select_list INTO select_target_list table_expression
         ::= 'SELECT' set_quantifier? select_list ( 'INTO' select_target_list )? table_expression?
Referenced by:
====================================================================================================================== select_target_list ====================================================================================================================== .. raw:: html target_specification ,
         ::= target_specification ( ',' target_specification )*
Referenced by:
====================================================================================================================== delete_statement_positioned ====================================================================================================================== .. raw:: html DELETE FROM target_table AS identifier WHERE CURRENT OF cursor_name
         ::= 'DELETE' 'FROM' target_table ( 'AS'? identifier )? 'WHERE' 'CURRENT' 'OF' cursor_name
Referenced by:
====================================================================================================================== target_table ====================================================================================================================== .. raw:: html table_name ONLY ( table_name )
         ::= table_name
           | 'ONLY' '(' table_name ')'
Referenced by:
====================================================================================================================== delete_statement_searched ====================================================================================================================== .. raw:: html DELETE FROM target_table AS identifier WHERE search_condition
         ::= 'DELETE' 'FROM' target_table ( 'AS'? identifier )? ( 'WHERE' search_condition )?
Referenced by:
====================================================================================================================== truncate_table_statement ====================================================================================================================== .. raw:: html TRUNCATE TABLE target_table identity_column_restart_option
         ::= 'TRUNCATE' 'TABLE' target_table identity_column_restart_option?
Referenced by:
====================================================================================================================== identity_column_restart_option ====================================================================================================================== .. raw:: html CONTINUE RESTART IDENTITY
         ::= ( 'CONTINUE' | 'RESTART' ) 'IDENTITY'
Referenced by:
====================================================================================================================== insert_statement ====================================================================================================================== .. raw:: html INSERT INTO insertion_target insert_columns_and_source
         ::= 'INSERT' 'INTO' insertion_target insert_columns_and_source
Referenced by:
====================================================================================================================== insertion_target ====================================================================================================================== .. raw:: html table_name
         ::= table_name
Referenced by:
====================================================================================================================== insert_columns_and_source ====================================================================================================================== .. raw:: html from_subquery from_constructor from_default
         ::= from_subquery
           | from_constructor
           | from_default
Referenced by:
====================================================================================================================== from_subquery ====================================================================================================================== .. raw:: html ( insert_column_list ) override_clause query_expression
         ::= ( '(' insert_column_list ')' )? override_clause? query_expression
Referenced by:
====================================================================================================================== from_constructor ====================================================================================================================== .. raw:: html ( insert_column_list ) override_clause contextually_typed_table_value_constructor
Referenced by:
====================================================================================================================== override_clause ====================================================================================================================== .. raw:: html OVERRIDING USER SYSTEM VALUE
         ::= 'OVERRIDING' ( 'USER' | 'SYSTEM' ) 'VALUE'
Referenced by:
====================================================================================================================== from_default ====================================================================================================================== .. raw:: html DEFAULT VALUES
         ::= 'DEFAULT' 'VALUES'
Referenced by:
====================================================================================================================== insert_column_list ====================================================================================================================== .. raw:: html column_name_list
         ::= column_name_list
Referenced by:
====================================================================================================================== merge_statement ====================================================================================================================== .. raw:: html MERGE INTO target_table AS identifier USING table_reference ON search_condition merge_operation_specification
         ::= 'MERGE' 'INTO' target_table ( 'AS'? identifier )? 'USING' table_reference 'ON' search_condition merge_operation_specification
Referenced by:
====================================================================================================================== merge_operation_specification ====================================================================================================================== .. raw:: html merge_when_clause
         ::= merge_when_clause+
Referenced by:
====================================================================================================================== merge_when_clause ====================================================================================================================== .. raw:: html merge_when_matched_clause merge_when_not_matched_clause
         ::= merge_when_matched_clause
           | merge_when_not_matched_clause
Referenced by:
====================================================================================================================== merge_when_matched_clause ====================================================================================================================== .. raw:: html WHEN MATCHED AND search_condition THEN merge_update_or_delete_specification
         ::= 'WHEN' 'MATCHED' ( 'AND' search_condition )? 'THEN' merge_update_or_delete_specification
Referenced by:
====================================================================================================================== merge_update_or_delete_specification ====================================================================================================================== .. raw:: html merge_update_specification DELETE
         ::= merge_update_specification
           | 'DELETE'
Referenced by:
====================================================================================================================== merge_when_not_matched_clause ====================================================================================================================== .. raw:: html WHEN NOT MATCHED AND search_condition THEN merge_insert_specification
         ::= 'WHEN' 'NOT' 'MATCHED' ( 'AND' search_condition )? 'THEN' merge_insert_specification
Referenced by:
====================================================================================================================== merge_update_specification ====================================================================================================================== .. raw:: html UPDATE SET set_clause_list
         ::= 'UPDATE' 'SET' set_clause_list
Referenced by:
====================================================================================================================== merge_insert_specification ====================================================================================================================== .. raw:: html INSERT ( insert_column_list ) override_clause VALUES merge_insert_value_list
         ::= 'INSERT' ( '(' insert_column_list ')' )? override_clause? 'VALUES' merge_insert_value_list
Referenced by:
====================================================================================================================== merge_insert_value_list ====================================================================================================================== .. raw:: html ( merge_insert_value_element , )
         ::= '(' merge_insert_value_element ( ',' merge_insert_value_element )* ')'
Referenced by:
====================================================================================================================== merge_insert_value_element ====================================================================================================================== .. raw:: html value_expression contextually_typed_value_specification
         ::= value_expression
Referenced by:
====================================================================================================================== update_statement_positioned ====================================================================================================================== .. raw:: html UPDATE target_table AS identifier SET set_clause_list WHERE CURRENT OF cursor_name
         ::= 'UPDATE' target_table ( 'AS'? identifier )? 'SET' set_clause_list 'WHERE' 'CURRENT' 'OF' cursor_name
Referenced by:
====================================================================================================================== update_statement_searched ====================================================================================================================== .. raw:: html UPDATE target_table AS identifier SET set_clause_list WHERE search_condition
         ::= 'UPDATE' target_table ( 'AS'? identifier )? 'SET' set_clause_list ( 'WHERE' search_condition )?
Referenced by:
====================================================================================================================== set_clause_list ====================================================================================================================== .. raw:: html set_clause ,
         ::= set_clause ( ',' set_clause )*
Referenced by:
====================================================================================================================== set_clause ====================================================================================================================== .. raw:: html multiple_column_assignment set_target = update_source
         ::= multiple_column_assignment
           | set_target '=' update_source
Referenced by:
====================================================================================================================== set_target ====================================================================================================================== .. raw:: html update_target mutated_set_clause
         ::= update_target
           | mutated_set_clause
Referenced by:
====================================================================================================================== multiple_column_assignment ====================================================================================================================== .. raw:: html set_target_list = assigned_row
         ::= set_target_list '=' assigned_row
Referenced by:
====================================================================================================================== set_target_list ====================================================================================================================== .. raw:: html ( set_target , )
         ::= '(' set_target ( ',' set_target )* ')'
Referenced by:
====================================================================================================================== assigned_row ====================================================================================================================== .. raw:: html contextually_typed_row_value_expression
Referenced by:
====================================================================================================================== update_target ====================================================================================================================== .. raw:: html identifier left_bracket_or_trigraph simple_value_specification right_bracket_or_trigraph
Referenced by:
====================================================================================================================== mutated_set_clause ====================================================================================================================== .. raw:: html identifier . identifier
         ::= identifier ( '.' identifier )+
Referenced by:
====================================================================================================================== mutated_target ====================================================================================================================== .. raw:: html identifier mutated_set_clause
         ::= identifier
           | mutated_set_clause
Not referenced by any.
====================================================================================================================== update_source ====================================================================================================================== .. raw:: html value_expression contextually_typed_value_specification
         ::= value_expression
Referenced by:
====================================================================================================================== temporary_table_declaration ====================================================================================================================== .. raw:: html DECLARE LOCAL TEMPORARY TABLE table_name table_element_list ON COMMIT table_commit_action ROWS
         ::= 'DECLARE' 'LOCAL' 'TEMPORARY' 'TABLE' table_name table_element_list ( 'ON' 'COMMIT' table_commit_action 'ROWS' )?
Referenced by:
====================================================================================================================== call_statement ====================================================================================================================== .. raw:: html CALL routine_invocation
         ::= 'CALL' routine_invocation
Referenced by:
====================================================================================================================== return_statement ====================================================================================================================== .. raw:: html RETURN return_value
         ::= 'RETURN' return_value
Referenced by:
====================================================================================================================== return_value ====================================================================================================================== .. raw:: html value_expression NULL
         ::= value_expression
           | 'NULL'
Referenced by:
====================================================================================================================== start_transaction_statement ====================================================================================================================== .. raw:: html START TRANSACTION transaction_characteristics
         ::= 'START' 'TRANSACTION' transaction_characteristics?
Referenced by:
====================================================================================================================== set_transaction_statement ====================================================================================================================== .. raw:: html SET LOCAL TRANSACTION transaction_characteristics
         ::= 'SET' 'LOCAL'? 'TRANSACTION' transaction_characteristics?
Referenced by:
====================================================================================================================== transaction_characteristics ====================================================================================================================== .. raw:: html transaction_mode ,
         ::= transaction_mode ( ',' transaction_mode )*
Referenced by:
====================================================================================================================== transaction_mode ====================================================================================================================== .. raw:: html isolation_level transaction_access_mode diagnostics_size
         ::= isolation_level
           | transaction_access_mode
           | diagnostics_size
Referenced by:
====================================================================================================================== transaction_access_mode ====================================================================================================================== .. raw:: html READ ONLY WRITE
         ::= 'READ' ( 'ONLY' | 'WRITE' )
Referenced by:
====================================================================================================================== isolation_level ====================================================================================================================== .. raw:: html ISOLATION LEVEL level_of_isolation
         ::= 'ISOLATION' 'LEVEL' level_of_isolation
Referenced by:
====================================================================================================================== level_of_isolation ====================================================================================================================== .. raw:: html READ UNCOMMITTED COMMITTED REPEATABLE READ SERIALIZABLE
         ::= 'READ' ( 'UNCOMMITTED' | 'COMMITTED' )
           | 'REPEATABLE' 'READ'
           | 'SERIALIZABLE'
Referenced by:
====================================================================================================================== diagnostics_size ====================================================================================================================== .. raw:: html DIAGNOSTICS SIZE simple_value_specification
         ::= 'DIAGNOSTICS' 'SIZE' simple_value_specification
Referenced by:
====================================================================================================================== set_constraints_mode_statement ====================================================================================================================== .. raw:: html SET CONSTRAINTS constraint_name_list DEFERRED IMMEDIATE
         ::= 'SET' 'CONSTRAINTS' constraint_name_list ( 'DEFERRED' | 'IMMEDIATE' )
Referenced by:
====================================================================================================================== constraint_name_list ====================================================================================================================== .. raw:: html ALL schema_qualified_name ,
         ::= 'ALL'
           | schema_qualified_name ( ',' schema_qualified_name )*
Referenced by:
====================================================================================================================== savepoint_statement ====================================================================================================================== .. raw:: html SAVEPOINT savepoint_specifier
         ::= 'SAVEPOINT' savepoint_specifier
Referenced by:
====================================================================================================================== savepoint_specifier ====================================================================================================================== .. raw:: html identifier
         ::= identifier
Referenced by:
====================================================================================================================== release_savepoint_statement ====================================================================================================================== .. raw:: html RELEASE SAVEPOINT savepoint_specifier
         ::= 'RELEASE' 'SAVEPOINT' savepoint_specifier
Referenced by:
====================================================================================================================== commit_statement ====================================================================================================================== .. raw:: html COMMIT WORK AND NO CHAIN
         ::= 'COMMIT' 'WORK'? ( 'AND' 'NO'? 'CHAIN' )?
Referenced by:
====================================================================================================================== rollback_statement ====================================================================================================================== .. raw:: html ROLLBACK WORK AND NO CHAIN savepoint_clause
         ::= 'ROLLBACK' 'WORK'? ( 'AND' 'NO'? 'CHAIN' )? savepoint_clause?
Referenced by:
====================================================================================================================== savepoint_clause ====================================================================================================================== .. raw:: html TO SAVEPOINT savepoint_specifier
         ::= 'TO' 'SAVEPOINT' savepoint_specifier
Referenced by:
====================================================================================================================== connect_statement ====================================================================================================================== .. raw:: html CONNECT TO connection_target
         ::= 'CONNECT' 'TO' connection_target
Referenced by:
====================================================================================================================== connection_target ====================================================================================================================== .. raw:: html simple_value_specification AS simple_value_specification USER simple_value_specification DEFAULT
           | 'DEFAULT'
Referenced by:
====================================================================================================================== set_connection_statement ====================================================================================================================== .. raw:: html SET CONNECTION connection_object
         ::= 'SET' 'CONNECTION' connection_object
Referenced by:
====================================================================================================================== connection_object ====================================================================================================================== .. raw:: html DEFAULT simple_value_specification
         ::= 'DEFAULT'
           | simple_value_specification
Referenced by:
====================================================================================================================== disconnect_statement ====================================================================================================================== .. raw:: html DISCONNECT disconnect_object
         ::= 'DISCONNECT' disconnect_object
Referenced by:
====================================================================================================================== disconnect_object ====================================================================================================================== .. raw:: html connection_object ALL CURRENT
         ::= connection_object
           | 'ALL'
           | 'CURRENT'
Referenced by:
====================================================================================================================== set_session_characteristics_statement ====================================================================================================================== .. raw:: html SET SESSION CHARACTERISTICS AS session_characteristic_list
         ::= 'SET' 'SESSION' 'CHARACTERISTICS' 'AS' session_characteristic_list
Referenced by:
====================================================================================================================== session_characteristic_list ====================================================================================================================== .. raw:: html session_characteristic ,
         ::= session_characteristic ( ',' session_characteristic )*
Referenced by:
====================================================================================================================== session_characteristic ====================================================================================================================== .. raw:: html session_transaction_characteristics
Referenced by:
====================================================================================================================== session_transaction_characteristics ====================================================================================================================== .. raw:: html TRANSACTION transaction_mode ,
         ::= 'TRANSACTION' transaction_mode ( ',' transaction_mode )*
Referenced by:
====================================================================================================================== set_session_user_identifier_statement ====================================================================================================================== .. raw:: html SET SESSION AUTHORIZATION value_specification
         ::= 'SET' 'SESSION' 'AUTHORIZATION' value_specification
Referenced by:
====================================================================================================================== set_role_statement ====================================================================================================================== .. raw:: html SET ROLE role_specification
         ::= 'SET' 'ROLE' role_specification
Referenced by:
====================================================================================================================== role_specification ====================================================================================================================== .. raw:: html value_specification NONE
         ::= value_specification
           | 'NONE'
Referenced by:
====================================================================================================================== set_local_time_zone_statement ====================================================================================================================== .. raw:: html SET TIME ZONE set_time_zone_value
         ::= 'SET' 'TIME' 'ZONE' set_time_zone_value
Referenced by:
====================================================================================================================== set_time_zone_value ====================================================================================================================== .. raw:: html interval_value_expression LOCAL
         ::= interval_value_expression
           | 'LOCAL'
Referenced by:
====================================================================================================================== set_catalog_statement ====================================================================================================================== .. raw:: html SET catalog_name_characteristic
         ::= 'SET' catalog_name_characteristic
Referenced by:
====================================================================================================================== catalog_name_characteristic ====================================================================================================================== .. raw:: html CATALOG value_specification
         ::= 'CATALOG' value_specification
Referenced by:
====================================================================================================================== set_schema_statement ====================================================================================================================== .. raw:: html SET schema_name_characteristic
         ::= 'SET' schema_name_characteristic
Referenced by:
====================================================================================================================== schema_name_characteristic ====================================================================================================================== .. raw:: html SCHEMA value_specification
         ::= 'SCHEMA' value_specification
Referenced by:
====================================================================================================================== set_names_statement ====================================================================================================================== .. raw:: html SET character_set_name_characteristic
         ::= 'SET' character_set_name_characteristic
Referenced by:
====================================================================================================================== character_set_name_characteristic ====================================================================================================================== .. raw:: html NAMES value_specification
         ::= 'NAMES' value_specification
Referenced by:
====================================================================================================================== set_path_statement ====================================================================================================================== .. raw:: html SET SQL_path_characteristic
         ::= 'SET' SQL_path_characteristic
Referenced by:
====================================================================================================================== SQL_path_characteristic ====================================================================================================================== .. raw:: html PATH value_specification
         ::= 'PATH' value_specification
Referenced by:
====================================================================================================================== set_transform_group_statement ====================================================================================================================== .. raw:: html SET transform_group_characteristic
         ::= 'SET' transform_group_characteristic
Referenced by:
====================================================================================================================== transform_group_characteristic ====================================================================================================================== .. raw:: html DEFAULT TRANSFORM GROUP TRANSFORM GROUP FOR TYPE path_resolved_user_defined_type_name value_specification
         ::= ( 'DEFAULT' 'TRANSFORM' 'GROUP' | 'TRANSFORM' 'GROUP' 'FOR' 'TYPE' path_resolved_user_defined_type_name ) value_specification
Referenced by:
====================================================================================================================== set_session_collation_statement ====================================================================================================================== .. raw:: html SET COLLATION collation_specification NO COLLATION FOR character_set_specification_list
         ::= 'SET' ( 'COLLATION' collation_specification | 'NO' 'COLLATION' ) ( 'FOR' character_set_specification_list )?
Referenced by:
====================================================================================================================== collation_specification ====================================================================================================================== .. raw:: html value_specification
         ::= value_specification
Referenced by:
====================================================================================================================== allocate_descriptor_statement ====================================================================================================================== .. raw:: html ALLOCATE SQL DESCRIPTOR descriptor_name WITH MAX simple_value_specification
         ::= 'ALLOCATE' 'SQL'? 'DESCRIPTOR' descriptor_name ( 'WITH' 'MAX' simple_value_specification )?
Referenced by:
====================================================================================================================== deallocate_descriptor_statement ====================================================================================================================== .. raw:: html DEALLOCATE SQL DESCRIPTOR descriptor_name
         ::= 'DEALLOCATE' 'SQL'? 'DESCRIPTOR' descriptor_name
Referenced by:
====================================================================================================================== get_descriptor_statement ====================================================================================================================== .. raw:: html GET SQL DESCRIPTOR descriptor_name get_descriptor_information
         ::= 'GET' 'SQL'? 'DESCRIPTOR' descriptor_name get_descriptor_information
Referenced by:
====================================================================================================================== get_descriptor_information ====================================================================================================================== .. raw:: html get_header_information , VALUE simple_value_specification get_item_information ,
         ::= get_header_information ( ',' get_header_information )*
Referenced by:
====================================================================================================================== get_header_information ====================================================================================================================== .. raw:: html simple_target_specification_1 = header_item_name
Referenced by:
====================================================================================================================== header_item_name ====================================================================================================================== .. raw:: html COUNT KEY_TYPE DYNAMIC_FUNCTION DYNAMIC_FUNCTION_CODE TOP_LEVEL_COUNT
         ::= 'COUNT'
           | 'KEY_TYPE'
           | 'DYNAMIC_FUNCTION'
           | 'DYNAMIC_FUNCTION_CODE'
           | 'TOP_LEVEL_COUNT'
Referenced by:
====================================================================================================================== get_item_information ====================================================================================================================== .. raw:: html simple_target_specification_2 = descriptor_item_name
Referenced by:
====================================================================================================================== simple_target_specification_1 ====================================================================================================================== .. raw:: html simple_target_specification
         ::= simple_target_specification
Referenced by:
====================================================================================================================== simple_target_specification_2 ====================================================================================================================== .. raw:: html simple_target_specification
         ::= simple_target_specification
Referenced by:
====================================================================================================================== descriptor_item_name ====================================================================================================================== .. raw:: html CARDINALITY CHARACTER_SET_CATALOG CHARACTER_SET_NAME CHARACTER_SET_SCHEMA COLLATION_CATALOG COLLATION_NAME COLLATION_SCHEMA DATA DATETIME_INTERVAL_CODE DATETIME_INTERVAL_PRECISION DEGREE INDICATOR KEY_MEMBER LENGTH LEVEL NAME NULLABLE OCTET_LENGTH PARAMETER_MODE PARAMETER_ORDINAL_POSITION PARAMETER_SPECIFIC_CATALOG PARAMETER_SPECIFIC_NAME PARAMETER_SPECIFIC_SCHEMA PRECISION RETURNED_CARDINALITY RETURNED_LENGTH RETURNED_OCTET_LENGTH SCALE SCOPE_CATALOG SCOPE_NAME SCOPE_SCHEMA TYPE UNNAMED USER_DEFINED_TYPE_CATALOG USER_DEFINED_TYPE_NAME USER_DEFINED_TYPE_SCHEMA USER_DEFINED_TYPE_CODE
         ::= 'CARDINALITY'
           | 'CHARACTER_SET_CATALOG'
           | 'CHARACTER_SET_NAME'
           | 'CHARACTER_SET_SCHEMA'
           | 'COLLATION_CATALOG'
           | 'COLLATION_NAME'
           | 'COLLATION_SCHEMA'
           | 'DATA'
           | 'DATETIME_INTERVAL_CODE'
           | 'DATETIME_INTERVAL_PRECISION'
           | 'DEGREE'
           | 'INDICATOR'
           | 'KEY_MEMBER'
           | 'LENGTH'
           | 'LEVEL'
           | 'NAME'
           | 'NULLABLE'
           | 'OCTET_LENGTH'
           | 'PARAMETER_MODE'
           | 'PARAMETER_ORDINAL_POSITION'
           | 'PARAMETER_SPECIFIC_CATALOG'
           | 'PARAMETER_SPECIFIC_NAME'
           | 'PARAMETER_SPECIFIC_SCHEMA'
           | 'PRECISION'
           | 'RETURNED_CARDINALITY'
           | 'RETURNED_LENGTH'
           | 'RETURNED_OCTET_LENGTH'
           | 'SCALE'
           | 'SCOPE_CATALOG'
           | 'SCOPE_NAME'
           | 'SCOPE_SCHEMA'
           | 'TYPE'
           | 'UNNAMED'
           | 'USER_DEFINED_TYPE_CATALOG'
           | 'USER_DEFINED_TYPE_NAME'
           | 'USER_DEFINED_TYPE_SCHEMA'
           | 'USER_DEFINED_TYPE_CODE'
Referenced by:
====================================================================================================================== set_descriptor_statement ====================================================================================================================== .. raw:: html SET SQL DESCRIPTOR descriptor_name set_descriptor_information
         ::= 'SET' 'SQL'? 'DESCRIPTOR' descriptor_name set_descriptor_information
Referenced by:
====================================================================================================================== set_descriptor_information ====================================================================================================================== .. raw:: html set_header_information , VALUE simple_value_specification set_item_information ,
         ::= set_header_information ( ',' set_header_information )*
Referenced by:
====================================================================================================================== set_header_information ====================================================================================================================== .. raw:: html header_item_name = simple_value_specification
Referenced by:
====================================================================================================================== set_item_information ====================================================================================================================== .. raw:: html descriptor_item_name = simple_value_specification
Referenced by:
====================================================================================================================== prepare_statement ====================================================================================================================== .. raw:: html PREPARE SQL_identifier attributes_specification FROM simple_value_specification
Referenced by:
====================================================================================================================== attributes_specification ====================================================================================================================== .. raw:: html ATTRIBUTES simple_value_specification
         ::= 'ATTRIBUTES' simple_value_specification
Referenced by:
====================================================================================================================== preparable_statement ====================================================================================================================== .. raw:: html preparable_SQL_data_statement preparable_SQL_schema_statement preparable_SQL_transaction_statement preparable_SQL_control_statement preparable_SQL_session_statement preparable_implementation_defined_statement
         ::= preparable_SQL_data_statement
           | preparable_SQL_schema_statement
           | preparable_SQL_transaction_statement
           | preparable_SQL_control_statement
           | preparable_SQL_session_statement
Not referenced by any.
====================================================================================================================== preparable_SQL_data_statement ====================================================================================================================== .. raw:: html delete_statement_searched dynamic_single_row_select_statement insert_statement dynamic_select_statement update_statement_searched truncate_table_statement merge_statement preparable_dynamic_delete_statement_positioned preparable_dynamic_update_statement_positioned
         ::= delete_statement_searched
           | dynamic_single_row_select_statement
           | insert_statement
           | dynamic_select_statement
           | update_statement_searched
           | truncate_table_statement
           | merge_statement
Referenced by:
====================================================================================================================== preparable_SQL_schema_statement ====================================================================================================================== .. raw:: html SQL_schema_statement
         ::= SQL_schema_statement
Referenced by:
====================================================================================================================== preparable_SQL_transaction_statement ====================================================================================================================== .. raw:: html SQL_transaction_statement
         ::= SQL_transaction_statement
Referenced by:
====================================================================================================================== preparable_SQL_control_statement ====================================================================================================================== .. raw:: html SQL_control_statement
         ::= SQL_control_statement
Referenced by:
====================================================================================================================== preparable_SQL_session_statement ====================================================================================================================== .. raw:: html SQL_session_statement
         ::= SQL_session_statement
Referenced by:
====================================================================================================================== dynamic_select_statement ====================================================================================================================== .. raw:: html cursor_specification
         ::= cursor_specification
Referenced by:
====================================================================================================================== preparable_implementation_defined_statement ====================================================================================================================== .. raw:: html character_string_literal
         ::= character_string_literal
Referenced by:
====================================================================================================================== cursor_attributes ====================================================================================================================== .. raw:: html cursor_attribute
         ::= cursor_attribute+
Not referenced by any.
====================================================================================================================== cursor_attribute ====================================================================================================================== .. raw:: html cursor_sensitivity cursor_scrollability cursor_holdability cursor_returnability
         ::= cursor_sensitivity
           | cursor_scrollability
           | cursor_holdability
           | cursor_returnability
Referenced by:
====================================================================================================================== deallocate_prepared_statement ====================================================================================================================== .. raw:: html DEALLOCATE PREPARE SQL_identifier
         ::= 'DEALLOCATE' 'PREPARE' SQL_identifier
Referenced by:
====================================================================================================================== describe_statement ====================================================================================================================== .. raw:: html describe_input_statement describe_output_statement
         ::= describe_input_statement
           | describe_output_statement
Referenced by:
====================================================================================================================== describe_input_statement ====================================================================================================================== .. raw:: html DESCRIBE INPUT SQL_identifier using_descriptor nesting_option
         ::= 'DESCRIBE' 'INPUT' SQL_identifier using_descriptor nesting_option?
Referenced by:
====================================================================================================================== describe_output_statement ====================================================================================================================== .. raw:: html DESCRIBE OUTPUT described_object using_descriptor nesting_option
         ::= 'DESCRIBE' 'OUTPUT'? described_object using_descriptor nesting_option?
Referenced by:
====================================================================================================================== nesting_option ====================================================================================================================== .. raw:: html WITH WITHOUT NESTING
         ::= ( 'WITH' | 'WITHOUT' ) 'NESTING'
Referenced by:
====================================================================================================================== using_descriptor ====================================================================================================================== .. raw:: html USING SQL DESCRIPTOR descriptor_name
         ::= 'USING' 'SQL'? 'DESCRIPTOR' descriptor_name
Referenced by:
====================================================================================================================== described_object ====================================================================================================================== .. raw:: html SQL_identifier CURSOR extended_cursor_name STRUCTURE
         ::= SQL_identifier
           | 'CURSOR' extended_cursor_name 'STRUCTURE'
Referenced by:
====================================================================================================================== input_using_clause ====================================================================================================================== .. raw:: html using_arguments using_input_descriptor
         ::= using_arguments
           | using_input_descriptor
Referenced by:
====================================================================================================================== using_arguments ====================================================================================================================== .. raw:: html USING using_argument ,
         ::= 'USING' using_argument ( ',' using_argument )*
Referenced by:
====================================================================================================================== using_argument ====================================================================================================================== .. raw:: html general_value_specification
         ::= general_value_specification
Referenced by:
====================================================================================================================== using_input_descriptor ====================================================================================================================== .. raw:: html using_descriptor
         ::= using_descriptor
Referenced by:
====================================================================================================================== output_using_clause ====================================================================================================================== .. raw:: html into_arguments into_descriptor
         ::= into_arguments
           | into_descriptor
Referenced by:
====================================================================================================================== into_arguments ====================================================================================================================== .. raw:: html INTO into_argument ,
         ::= 'INTO' into_argument ( ',' into_argument )*
Referenced by:
====================================================================================================================== into_argument ====================================================================================================================== .. raw:: html target_specification
         ::= target_specification
Referenced by:
====================================================================================================================== into_descriptor ====================================================================================================================== .. raw:: html INTO SQL DESCRIPTOR descriptor_name
         ::= 'INTO' 'SQL'? 'DESCRIPTOR' descriptor_name
Referenced by:
====================================================================================================================== execute_statement ====================================================================================================================== .. raw:: html EXECUTE SQL_identifier result_using_clause parameter_using_clause
Referenced by:
====================================================================================================================== result_using_clause ====================================================================================================================== .. raw:: html output_using_clause
         ::= output_using_clause
Referenced by:
====================================================================================================================== parameter_using_clause ====================================================================================================================== .. raw:: html input_using_clause
         ::= input_using_clause
Referenced by:
====================================================================================================================== execute_immediate_statement ====================================================================================================================== .. raw:: html EXECUTE IMMEDIATE simple_value_specification
         ::= 'EXECUTE' 'IMMEDIATE' simple_value_specification
Referenced by:
====================================================================================================================== dynamic_declare_cursor ====================================================================================================================== .. raw:: html DECLARE cursor_name cursor_properties FOR identifier
         ::= 'DECLARE' cursor_name cursor_properties 'FOR' identifier
Referenced by:
====================================================================================================================== allocate_cursor_statement ====================================================================================================================== .. raw:: html ALLOCATE extended_cursor_name cursor_intent
         ::= 'ALLOCATE' extended_cursor_name cursor_intent
Referenced by:
====================================================================================================================== cursor_intent ====================================================================================================================== .. raw:: html statement_cursor result_set_cursor
         ::= statement_cursor
           | result_set_cursor
Referenced by:
====================================================================================================================== statement_cursor ====================================================================================================================== .. raw:: html cursor_properties FOR extended_identifier
         ::= cursor_properties 'FOR' extended_identifier
Referenced by:
====================================================================================================================== result_set_cursor ====================================================================================================================== .. raw:: html CURSOR FOR PROCEDURE specific_routine_designator
         ::= 'CURSOR'? 'FOR' 'PROCEDURE' specific_routine_designator
Referenced by:
====================================================================================================================== dynamic_open_statement ====================================================================================================================== .. raw:: html OPEN dynamic_cursor_name input_using_clause
         ::= 'OPEN' dynamic_cursor_name input_using_clause?
Referenced by:
====================================================================================================================== dynamic_fetch_statement ====================================================================================================================== .. raw:: html FETCH fetch_orientation FROM dynamic_cursor_name output_using_clause
         ::= 'FETCH' ( fetch_orientation? 'FROM' )? dynamic_cursor_name output_using_clause
Referenced by:
====================================================================================================================== dynamic_single_row_select_statement ====================================================================================================================== .. raw:: html query_specification
         ::= query_specification
Referenced by:
====================================================================================================================== dynamic_close_statement ====================================================================================================================== .. raw:: html CLOSE dynamic_cursor_name
         ::= 'CLOSE' dynamic_cursor_name
Referenced by:
====================================================================================================================== dynamic_delete_statement_positioned ====================================================================================================================== .. raw:: html DELETE FROM target_table WHERE CURRENT OF dynamic_cursor_name
         ::= 'DELETE' 'FROM' target_table 'WHERE' 'CURRENT' 'OF' dynamic_cursor_name
Referenced by:
====================================================================================================================== dynamic_update_statement_positioned ====================================================================================================================== .. raw:: html UPDATE target_table SET set_clause_list WHERE CURRENT OF dynamic_cursor_name
         ::= 'UPDATE' target_table 'SET' set_clause_list 'WHERE' 'CURRENT' 'OF' dynamic_cursor_name
Referenced by:
====================================================================================================================== preparable_dynamic_delete_statement_positioned ====================================================================================================================== .. raw:: html DELETE FROM target_table WHERE CURRENT OF preparable_dynamic_cursor_name
         ::= 'DELETE' ( 'FROM' target_table )? 'WHERE' 'CURRENT' 'OF' preparable_dynamic_cursor_name
Referenced by:
====================================================================================================================== preparable_dynamic_cursor_name ====================================================================================================================== .. raw:: html scope_option cursor_name
         ::= scope_option? cursor_name
Referenced by:
====================================================================================================================== preparable_dynamic_update_statement_positioned ====================================================================================================================== .. raw:: html UPDATE target_table SET set_clause_list WHERE CURRENT OF preparable_dynamic_cursor_name
         ::= 'UPDATE' target_table? 'SET' set_clause_list 'WHERE' 'CURRENT' 'OF' preparable_dynamic_cursor_name
Referenced by:
====================================================================================================================== direct_SQL_statement ====================================================================================================================== .. raw:: html directly_executable_statement ;
         ::= directly_executable_statement ';'
Referenced by:
====================================================================================================================== directly_executable_statement ====================================================================================================================== .. raw:: html direct_SQL_data_statement SQL_schema_statement SQL_transaction_statement SQL_connection_statement SQL_session_statement direct_implementation_defined_statement use_statement
         ::= direct_SQL_data_statement
           | SQL_schema_statement
           | SQL_transaction_statement
           | SQL_connection_statement
           | SQL_session_statement
           | use_statement
Referenced by:
====================================================================================================================== direct_SQL_data_statement ====================================================================================================================== .. raw:: html delete_statement_searched direct_select_statement_multiple_rows insert_statement update_statement_searched truncate_table_statement merge_statement temporary_table_declaration
         ::= delete_statement_searched
           | insert_statement
           | update_statement_searched
           | truncate_table_statement
           | merge_statement
           | temporary_table_declaration
Referenced by:
====================================================================================================================== direct_implementation_defined_statement ====================================================================================================================== .. raw:: html character_string_literal
         ::= character_string_literal
Referenced by:
====================================================================================================================== direct_select_statement_multiple_rows ====================================================================================================================== .. raw:: html cursor_specification
         ::= cursor_specification
Referenced by:
====================================================================================================================== get_diagnostics_statement ====================================================================================================================== .. raw:: html GET DIAGNOSTICS SQL_diagnostics_information
         ::= 'GET' 'DIAGNOSTICS' SQL_diagnostics_information
Referenced by:
====================================================================================================================== SQL_diagnostics_information ====================================================================================================================== .. raw:: html statement_information condition_information all_information
         ::= statement_information
           | condition_information
           | all_information
Referenced by:
====================================================================================================================== statement_information ====================================================================================================================== .. raw:: html statement_information_item ,
Referenced by:
====================================================================================================================== statement_information_item ====================================================================================================================== .. raw:: html simple_target_specification = statement_information_item_name
Referenced by:
====================================================================================================================== statement_information_item_name ====================================================================================================================== .. raw:: html NUMBER MORE COMMAND_FUNCTION COMMAND_FUNCTION_CODE DYNAMIC_FUNCTION DYNAMIC_FUNCTION_CODE ROW_COUNT TRANSACTIONS_COMMITTED TRANSACTIONS_ROLLED_BACK TRANSACTION_ACTIVE
         ::= 'NUMBER'
           | 'MORE'
           | 'COMMAND_FUNCTION'
           | 'COMMAND_FUNCTION_CODE'
           | 'DYNAMIC_FUNCTION'
           | 'DYNAMIC_FUNCTION_CODE'
           | 'ROW_COUNT'
           | 'TRANSACTIONS_COMMITTED'
           | 'TRANSACTIONS_ROLLED_BACK'
           | 'TRANSACTION_ACTIVE'
Referenced by:
====================================================================================================================== condition_information ====================================================================================================================== .. raw:: html CONDITION simple_value_specification condition_information_item ,
Referenced by:
====================================================================================================================== condition_information_item ====================================================================================================================== .. raw:: html simple_target_specification = condition_information_item_name
Referenced by:
====================================================================================================================== condition_information_item_name ====================================================================================================================== .. raw:: html CATALOG_NAME CLASS_ORIGIN COLUMN_NAME CONDITION_NUMBER CONNECTION_NAME CONSTRAINT_CATALOG CONSTRAINT_NAME CONSTRAINT_SCHEMA CURSOR_NAME MESSAGE_LENGTH MESSAGE_OCTET_LENGTH MESSAGE_TEXT PARAMETER_MODE PARAMETER_NAME PARAMETER_ORDINAL_POSITION RETURNED_SQLSTATE ROUTINE_CATALOG ROUTINE_NAME ROUTINE_SCHEMA SCHEMA_NAME SERVER_NAME SPECIFIC_NAME SUBCLASS_ORIGIN TABLE_NAME TRIGGER_CATALOG TRIGGER_NAME TRIGGER_SCHEMA
         ::= 'CATALOG_NAME'
           | 'CLASS_ORIGIN'
           | 'COLUMN_NAME'
           | 'CONDITION_NUMBER'
           | 'CONNECTION_NAME'
           | 'CONSTRAINT_CATALOG'
           | 'CONSTRAINT_NAME'
           | 'CONSTRAINT_SCHEMA'
           | 'CURSOR_NAME'
           | 'MESSAGE_LENGTH'
           | 'MESSAGE_OCTET_LENGTH'
           | 'MESSAGE_TEXT'
           | 'PARAMETER_MODE'
           | 'PARAMETER_NAME'
           | 'PARAMETER_ORDINAL_POSITION'
           | 'RETURNED_SQLSTATE'
           | 'ROUTINE_CATALOG'
           | 'ROUTINE_NAME'
           | 'ROUTINE_SCHEMA'
           | 'SCHEMA_NAME'
           | 'SERVER_NAME'
           | 'SPECIFIC_NAME'
           | 'SUBCLASS_ORIGIN'
           | 'TABLE_NAME'
           | 'TRIGGER_CATALOG'
           | 'TRIGGER_NAME'
           | 'TRIGGER_SCHEMA'
Referenced by:
====================================================================================================================== all_information ====================================================================================================================== .. raw:: html all_info_target = ALL all_qualifier
         ::= all_info_target '=' 'ALL' all_qualifier?
Referenced by:
====================================================================================================================== all_info_target ====================================================================================================================== .. raw:: html simple_target_specification
         ::= simple_target_specification
Referenced by:
====================================================================================================================== all_qualifier ====================================================================================================================== .. raw:: html STATEMENT CONDITION simple_value_specification
         ::= 'STATEMENT'
           | 'CONDITION' simple_value_specification?
Referenced by:
====================================================================================================================== use_statement ====================================================================================================================== .. raw:: html USE identifier_chain
         ::= 'USE' identifier_chain
Referenced by:
====================================================================================================================== lambda ====================================================================================================================== .. raw:: html lambda_params lambda_body
Referenced by:
====================================================================================================================== lambda_body ====================================================================================================================== .. raw:: html -> value_expression
         ::= '->' value_expression
Referenced by:
====================================================================================================================== lambda_params ====================================================================================================================== .. raw:: html actual_identifier ( actual_identifier , )
         ::= actual_identifier
           | '(' ( actual_identifier ( ',' actual_identifier )* )? ')'
Referenced by:
====================================================================================================================== if_not_exists ====================================================================================================================== .. raw:: html IF NOT EXISTS
         ::= 'IF' 'NOT' 'EXISTS'
Referenced by:
====================================================================================================================== identifier_suffix_chain ====================================================================================================================== .. raw:: html @ : actual_identifier
         ::= ( ( '@' | ':' ) actual_identifier? )+
Referenced by:
====================================================================================================================== limit_clause ====================================================================================================================== .. raw:: html LIMIT unsigned_integer ALL
         ::= 'LIMIT' ( unsigned_integer | 'ALL' )
Referenced by:
====================================================================================================================== presto_generic_type ====================================================================================================================== .. raw:: html presto_array_type presto_map_type regular_identifier ( data_type , )
         ::= presto_array_type
           | presto_map_type
           | regular_identifier '(' data_type ( ',' data_type )* ')'
Referenced by:
====================================================================================================================== presto_array_type ====================================================================================================================== .. raw:: html ARRAY < data_type > ( data_type )
         ::= 'ARRAY' ( '<' data_type '>' | '(' data_type ')' )
Referenced by:
====================================================================================================================== presto_map_type ====================================================================================================================== .. raw:: html MAP < data_type , data_type > ( data_type , data_type )
         ::= 'MAP' ( '<' data_type ',' data_type '>' | '(' data_type ',' data_type ')' )
Referenced by:
====================================================================================================================== grouping_expression ====================================================================================================================== .. raw:: html value_expression
         ::= value_expression
Referenced by:
====================================================================================================================== count ====================================================================================================================== .. raw:: html COUNT ( "COUNT" ( set_quantifier value_expression * )
count    ::= ( 'COUNT' '(' | '"COUNT"' '(' set_quantifier? ( value_expression | '*' )? ) ')'
Referenced by:
====================================================================================================================== table_description ====================================================================================================================== .. raw:: html COMMENT character_string_literal
         ::= 'COMMENT' character_string_literal
Referenced by:
====================================================================================================================== routine_description ====================================================================================================================== .. raw:: html COMMENT character_string_literal
         ::= 'COMMENT' character_string_literal
Referenced by:
====================================================================================================================== column_description ====================================================================================================================== .. raw:: html COMMENT character_string_literal
         ::= 'COMMENT' character_string_literal
Referenced by:
====================================================================================================================== presto_aggregation_function ====================================================================================================================== .. raw:: html NUMERIC_HISTOGRAM HISTOGRAM APPROEX_PERCENTILE MAP_AGG SET_AGG MAP_UNION
         ::= 'NUMERIC_HISTOGRAM'
           | 'HISTOGRAM'
           | 'APPROEX_PERCENTILE'
           | 'MAP_AGG'
           | 'SET_AGG'
           | 'MAP_UNION'
Referenced by:
====================================================================================================================== presto_aggregations ====================================================================================================================== .. raw:: html presto_aggregation_function ( set_quantifier value_expression , )
Referenced by:
====================================================================================================================== try_cast ====================================================================================================================== .. raw:: html TRY_CAST ( cast_operand AS cast_target )
try_cast ::= 'TRY_CAST' '(' cast_operand 'AS' cast_target ')'
Referenced by:
====================================================================================================================== table_attributes ====================================================================================================================== .. raw:: html ( actual_identifier = value_expression , )
         ::= '(' actual_identifier '=' value_expression ( ',' actual_identifier '=' value_expression )* ')'
Referenced by:
====================================================================================================================== or_replace ====================================================================================================================== .. raw:: html OR REPLACE
         ::= 'OR' 'REPLACE'
Referenced by:
====================================================================================================================== udaf_filter ====================================================================================================================== .. raw:: html filter_clause
         ::= filter_clause
Referenced by:
====================================================================================================================== extra_args_to_agg ====================================================================================================================== .. raw:: html , value_expression
         ::= ( ',' value_expression )+
Referenced by:
====================================================================================================================== identifier_starting_with_underscore ====================================================================================================================== .. raw:: html _ regular_identifier
         ::= '_'+ regular_identifier?
Not referenced by any.
====================================================================================================================== generic_unicode ====================================================================================================================== .. raw:: html U&' [^'] '' '
         ::= "U&'" ( [^'] | "''" )* "'"
Not referenced by any.
====================================================================================================================== regular_identifier ====================================================================================================================== .. raw:: html identifier_body
         ::= identifier_body
Referenced by:
====================================================================================================================== identifier_body ====================================================================================================================== .. raw:: html identifier_start identifier_part
         ::= identifier_start identifier_part*
Referenced by:
====================================================================================================================== identifier_part ====================================================================================================================== .. raw:: html identifier_start identifier_extend
         ::= identifier_start
           | identifier_extend
Referenced by:
====================================================================================================================== identifier_start ====================================================================================================================== .. raw:: html [a-z]
         ::= [a-z]
Referenced by:
====================================================================================================================== identifier_extend ====================================================================================================================== .. raw:: html [0-9] _ [#xB7]
         ::= [0-9_#xB7]
Referenced by:
====================================================================================================================== large_object_length_token ====================================================================================================================== .. raw:: html digit multiplier
         ::= digit+ multiplier
Referenced by:
====================================================================================================================== multiplier ====================================================================================================================== .. raw:: html K M G T P
         ::= [KMGTP]
Referenced by:
====================================================================================================================== delimited_identifier ====================================================================================================================== .. raw:: html " delimited_identifier_body "
         ::= '"' delimited_identifier_body? '"'
Referenced by:
====================================================================================================================== delimited_identifier_body ====================================================================================================================== .. raw:: html delimited_identifier_part
         ::= delimited_identifier_part+
Referenced by:
====================================================================================================================== delimited_identifier_part ====================================================================================================================== .. raw:: html nondoublequote_character ""
         ::= nondoublequote_character
           | '""'
Referenced by:
====================================================================================================================== Unicode_delimited_identifier ====================================================================================================================== .. raw:: html U & " Unicode_delimiter_body " Unicode_escape_specifier
         ::= 'U' '&' '"' Unicode_delimiter_body '"' Unicode_escape_specifier?
Referenced by:
====================================================================================================================== Unicode_escape_specifier ====================================================================================================================== .. raw:: html UESCAPE ' Unicode_escape_character '
         ::= 'UESCAPE' "'" Unicode_escape_character "'"
Referenced by:
====================================================================================================================== Unicode_delimiter_body ====================================================================================================================== .. raw:: html Unicode_identifier_part
         ::= Unicode_identifier_part+
Referenced by:
====================================================================================================================== Unicode_identifier_part ====================================================================================================================== .. raw:: html delimited_identifier_part Unicode_escape_value
         ::= delimited_identifier_part
           | Unicode_escape_value
Referenced by:
====================================================================================================================== Unicode_escape_value ====================================================================================================================== .. raw:: html Unicode_4_digit_escape_value Unicode_6_digit_escape_value Unicode_character_escape_value
         ::= Unicode_4_digit_escape_value
           | Unicode_6_digit_escape_value
           | Unicode_character_escape_value
Referenced by:
====================================================================================================================== Unicode_4_digit_escape_value ====================================================================================================================== .. raw:: html Unicode_escape_character hexit hexit hexit hexit
Referenced by:
====================================================================================================================== Unicode_6_digit_escape_value ====================================================================================================================== .. raw:: html Unicode_escape_character + hexit hexit hexit hexit hexit hexit
Referenced by:
====================================================================================================================== Unicode_character_escape_value ====================================================================================================================== .. raw:: html Unicode_escape_character Unicode_escape_character
Referenced by:
====================================================================================================================== Unicode_escape_character ====================================================================================================================== .. raw:: html [^a-z0-9+'" #xA#x9]
         ::= [^a-z0-9+'" #xA#x9]
Referenced by:
====================================================================================================================== nondoublequote_character ====================================================================================================================== .. raw:: html [^"]
         ::= [^"]
Referenced by:
====================================================================================================================== white_space ====================================================================================================================== .. raw:: html newline [#x9]
         ::= newline
           | [ #x9]
Referenced by:
====================================================================================================================== newline ====================================================================================================================== .. raw:: html [#xA] [#xD]
newline  ::= [#xA#xD]+
Referenced by:
====================================================================================================================== comment ====================================================================================================================== .. raw:: html simple_comment
Not referenced by any.
====================================================================================================================== simple_comment ====================================================================================================================== .. raw:: html -- comment_character newline
         ::= '--' comment_character* newline?
Referenced by:
====================================================================================================================== comment_character ====================================================================================================================== .. raw:: html [^#xA#xD] '
         ::= [^#xA#xD]
           | "'"
Referenced by:
====================================================================================================================== skip_separator ====================================================================================================================== .. raw:: html white_space
         ::= white_space+
Not referenced by any.
====================================================================================================================== separator ====================================================================================================================== .. raw:: html white_space
         ::= white_space+
Referenced by:
====================================================================================================================== digit ====================================================================================================================== .. raw:: html [0-9]
digit    ::= [0-9]
Referenced by:
====================================================================================================================== character_representation ====================================================================================================================== .. raw:: html nonquote_character ''
         ::= nonquote_character
           | "''"
Referenced by:
====================================================================================================================== nonquote_character ====================================================================================================================== .. raw:: html [^']
         ::= [^']
Referenced by:
====================================================================================================================== quoted_string ====================================================================================================================== .. raw:: html ' character_representation '
         ::= "'" character_representation* "'"
Referenced by:
====================================================================================================================== national_character_string_literal ====================================================================================================================== .. raw:: html N ' character_representation ' separator
         ::= 'N' "'" character_representation* "'" ( separator "'" character_representation* "'" )*
Referenced by:
====================================================================================================================== unicode_literal ====================================================================================================================== .. raw:: html U & ' Unicode_representation ' separator Unicode_escape_specifier
         ::= 'U' '&' "'" Unicode_representation* "'" ( separator "'" Unicode_representation* "'" )* Unicode_escape_specifier
Referenced by:
====================================================================================================================== Unicode_representation ====================================================================================================================== .. raw:: html character_representation Unicode_escape_value
         ::= character_representation
           | Unicode_escape_value
Referenced by:
====================================================================================================================== binary_string_literal ====================================================================================================================== .. raw:: html X ' hexit hexit ' separator
         ::= 'X' "'" ' '* ( hexit ' '* hexit ' '* )* "'" ( separator "'" ' '* ( hexit ' '* hexit ' '* )* "'" )*
Referenced by:
====================================================================================================================== hexit ====================================================================================================================== .. raw:: html [a-f] [0-9]
hexit    ::= [a-f0-9]
Referenced by:
====================================================================================================================== unsigned_integer ====================================================================================================================== .. raw:: html digit
         ::= digit+
Referenced by:
====================================================================================================================== float_literal ====================================================================================================================== .. raw:: html unsigned_integer . unsigned_integer . unsigned_integer
         ::= unsigned_integer '.' unsigned_integer?
           | '.' unsigned_integer
Referenced by:
====================================================================================================================== approximate_numeric_literal ====================================================================================================================== .. raw:: html mantissa E exponent
         ::= mantissa 'E' exponent
Referenced by:
====================================================================================================================== mantissa ====================================================================================================================== .. raw:: html unsigned_integer float_literal
           | float_literal
Referenced by:
====================================================================================================================== exponent ====================================================================================================================== .. raw:: html signed_integer
Referenced by:
====================================================================================================================== signed_integer ====================================================================================================================== .. raw:: html + [#x2D] unsigned_integer
         ::= [+#x2D]? unsigned_integer
Referenced by:
====================================================================================================================== SQL_language_identifier ====================================================================================================================== .. raw:: html SQL_language_identifier_start SQL_language_identifier_part
Referenced by:
====================================================================================================================== simple_Latin_letter ====================================================================================================================== .. raw:: html [a-z]
         ::= [a-z]
Referenced by:
====================================================================================================================== SQL_language_identifier_start ====================================================================================================================== .. raw:: html simple_Latin_letter
         ::= simple_Latin_letter
Referenced by:
====================================================================================================================== SQL_language_identifier_part ====================================================================================================================== .. raw:: html simple_Latin_letter digit _
         ::= simple_Latin_letter
           | digit
           | '_'
Referenced by:
====================================================================================================================== illegal_input_char ====================================================================================================================== .. raw:: html .
         ::= .
Not referenced by any.
====================================================================================================================== EOF ====================================================================================================================== .. raw:: html $
EOF      ::= $
Referenced by: