Supported SQL Syntax
Contents
Supported SQL Syntax#
The EBNF and Railroad Diagrams for the supported SQL Syntax.
CompilationUnit#
::= direct_SQL_statement* EOF |
Not referenced by any.
|
non_reserved_word#
::= 'A'
| 'ABSOLUTE'
| 'ACTION'
| 'ADA'
| 'ADD'
| 'ADMIN'
| 'AFTER'
| 'ALWAYS'
| 'ASC'
| 'ASSERTION'
| 'ASSIGNMENT'
| 'ATTRIBUTE'
| 'ATTRIBUTES'
| 'BEFORE'
| 'BERNOULLI'
| 'BREADTH'
| 'C'
| 'CASCADE'
| 'CATALOG'
| 'CATALOG_NAME'
| 'CHAIN'
| '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#
::= '['
| '??(' |
right_bracket_or_trigraph#
::= ']'
| '??)' |
literal#
Referenced by:
|
signed_numeric_literal#
::= ( '+' | '-' )? unsigned_numeric_literal |
unsigned_literal#
Referenced by:
|
unsigned_numeric_literal#
Referenced by:
|
exact_numeric_literal#
::= unsigned_integer
|
Referenced by:
|
general_literal#
Referenced by:
|
character_string_literal#
::= ( '_' character_set_specification )? quoted_string+ |
Unicode_character_string_literal#
::= ( '_' character_set_specification )? unicode_literal |
Referenced by:
|
datetime_literal#
::= date_literal
|
Referenced by:
|
date_literal#
::= 'DATE' character_string_literal |
Referenced by:
|
time_literal#
::= 'TIME' character_string_literal |
Referenced by:
|
timestamp_literal#
::= 'TIMESTAMP' character_string_literal |
Referenced by:
|
interval_literal#
::= 'INTERVAL' ( '+' | '-' )? character_string_literal interval_qualifier |
Referenced by:
|
boolean_literal#
::= 'TRUE'
| 'FALSE'
| 'UNKNOWN' |
Referenced by:
|
identifier#
actual_identifier#
table_name#
::= identifier_chain |
schema_name#
::= identifier_chain |
catalog_name#
::= identifier |
Not referenced by any.
|
schema_qualified_name#
local_or_schema_qualified_name#
::= identifier_chain |
Not referenced by any.
|
local_or_schema_qualifier#
::= 'MODULE'
|
Not referenced by any.
|
cursor_name#
::= identifier_chain |
host_parameter_name#
::= ':' identifier |
external_routine_name#
::= identifier
|
Referenced by:
|
character_set_name#
::= ( schema_name '.' )? SQL_language_identifier |
schema_resolved_user_defined_type_name#
user_defined_type_name#
::= identifier_chain |
SQL_identifier#
::= identifier
|
extended_identifier#
Referenced by:
|
dynamic_cursor_name#
::= cursor_name
|
extended_cursor_name#
Referenced by:
|
descriptor_name#
::= identifier
|
extended_descriptor_name#
Referenced by:
|
scope_option#
::= 'GLOBAL'
| 'LOCAL' |
data_type#
predefined_type#
::= ( character_string_type ( 'CHARACTER' 'SET' character_set_specification )? | national_character_string_type ) collate_clause?
| 'BOOLEAN'
|
character_string_type#
::= ( 'CHARACTER' | 'CHAR' ) ( 'VARYING'? '(' character_length ')' )?
| 'VARCHAR' ( '(' character_length ')' )?
|
Referenced by:
|
character_large_object_type#
::= ( ( 'CHARACTER' | 'CHAR' ) 'LARGE' 'OBJECT' | 'CLOB' ) ( '(' character_large_object_length ')' )? |
Referenced by:
|
national_character_string_type#
::= ( 'NATIONAL' ( 'CHARACTER' | 'CHAR' ) | 'NCHAR' ) ( 'VARYING'? '(' character_length ')' )?
|
Referenced by:
|
national_character_large_object_type#
::= ( ( 'NATIONAL' 'CHARACTER' | 'NCHAR' ) 'LARGE' 'OBJECT' | 'NCLOB' ) (
'(' character_large_object_length ')' )? |
Referenced by:
|
binary_string_type#
::= 'BINARY' ( 'VARYING'? '(' unsigned_integer ')' )?
| 'VARBINARY' ( '(' unsigned_integer ')' )?
|
Referenced by:
|
binary_large_object_string_type#
::= ( 'BINARY' 'LARGE' 'OBJECT' | 'BLOB' ) ( '(' large_object_length ')' )? |
Referenced by:
|
numeric_type#
Referenced by:
|
exact_numeric_type#
::= ( 'NUMERIC' | 'DECIMAL' | 'DEC' ) ( '(' unsigned_integer ( ',' unsigned_integer )? ')' )?
| 'SMALLINT'
| 'INTEGER'
| 'INT'
| 'BIGINT' |
Referenced by:
|
approximate_numeric_type#
::= 'FLOAT' ( '(' unsigned_integer ')' )?
| 'REAL'
| 'DOUBLE' 'PRECISION'? |
Referenced by:
|
character_length#
large_object_length#
Referenced by:
|
character_large_object_length#
char_length_units#
::= 'CHARACTERS'
| 'OCTETS' |
datetime_type#
::= 'DATE'
| ( 'TIME' | 'TIMESTAMP' ) ( '(' unsigned_integer ')' )? with_or_without_time_zone? |
Referenced by:
|
with_or_without_time_zone#
::= ( 'WITH' | 'WITHOUT' ) 'TIME' 'ZONE' |
Referenced by:
|
interval_type#
::= 'INTERVAL' interval_qualifier |
Referenced by:
|
row_type#
row_type ::= 'ROW' row_type_body |
Referenced by:
|
row_type_body#
::= '(' field_definition ( ',' field_definition )* ')' |
Referenced by:
|
reference_type#
::= 'REF' '(' referenced_type ')' scope_clause? |
Referenced by:
|
scope_clause#
::= 'SCOPE' table_name |
referenced_type#
Referenced by:
|
path_resolved_user_defined_type_name#
Referenced by:
|
collection_type#
::= array_type
| 'MULTISET' |
Referenced by:
|
array_type#
Referenced by:
|
field_definition#
::= identifier data_type |
Referenced by:
|
value_expression_primary#
parenthesized_value_expression#
Referenced by:
|
nonparenthesized_value_expression_primary#
primary_suffix#
::= field_reference
|
collection_value_constructor#
Referenced by:
|
value_specification#
::= literal
|
unsigned_value_specification#
::= unsigned_literal
|
Referenced by:
|
general_value_specification#
::= identifier_chain
| 'CURRENT_USER'
| 'USER'
| '?'
| '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 |
simple_value_specification#
target_specification#
simple_target_specification#
::= identifier_chain
|
target_array_element_specification#
Referenced by:
|
current_collation_specification#
::= 'COLLATION' 'FOR' '(' string_value_expression ')' |
Referenced by:
|
contextually_typed_value_specification#
| 'DEFAULT' |
implicitly_typed_value_specification#
::= 'NULL'
|
empty_specification#
::= ( 'ARRAY' | 'MULTISET' ) left_bracket_or_trigraph right_bracket_or_trigraph |
Referenced by:
|
identifier_chain#
::= identifier ( '.' identifier )* |
column_reference#
::= identifier_chain
| 'MODULE' '.' identifier '.' identifier |
set_function_specification#
Referenced by:
|
grouping_operation#
::= 'GROUPING' '(' column_reference ( ',' column_reference )* ')' |
Referenced by:
|
window_function#
::= 'OVER' window_name_or_specification |
Referenced by:
|
window_function_type#
::= ( rank_function_type | 'ROW_NUMBER' ) '(' ')'
|
Referenced by:
|
rank_function_type#
::= 'RANK'
| 'DENSE_RANK'
| 'PERCENT_RANK'
| 'CUME_DIST' |
Referenced by:
|
ntile_function#
::= 'NTILE' '(' number_of_tiles ')' |
Referenced by:
|
number_of_tiles#
::= value_expression
| '?' |
Referenced by:
|
lead_or_lag_function#
::= lead_or_lag '(' value_expression ( ',' value_expression ( ',' value_expression )? )? ')' null_treatment? |
Referenced by:
|
lead_or_lag#
::= 'LEAD'
| 'LAG' |
Referenced by:
|
null_treatment#
::= ( 'RESPECT' | 'IGNORE' ) 'NULLS' |
first_or_last_value_function#
Referenced by:
|
first_or_last_value#
::= 'FIRST_VALUE'
| 'LAST_VALUE' |
Referenced by:
|
nth_value_function#
Referenced by:
|
nth_row#
| '?' |
Referenced by:
|
from_first_or_last#
::= 'FROM' ( 'FIRST' | 'LAST' ) |
Referenced by:
|
window_name_or_specification#
Referenced by:
|
in_line_window_specification#
Referenced by:
|
case_expression#
Referenced by:
|
case_abbreviation#
::= ( 'NULLIF' '(' value_expression ',' | 'COALESCE' '(' ( value_expression ',' )+ ) value_expression ')' |
Referenced by:
|
case_specification#
::= simple_case
|
Referenced by:
|
simple_case#
Referenced by:
|
searched_case#
::= 'CASE' searched_when_clause+ else_clause? 'END' |
Referenced by:
|
simple_when_clause#
::= 'WHEN' when_operand_list 'THEN' result |
Referenced by:
|
searched_when_clause#
::= 'WHEN' search_condition 'THEN' result |
Referenced by:
|
else_clause#
::= 'ELSE' result |
Referenced by:
|
case_operand#
Referenced by:
|
when_operand_list#
::= when_operand ( ',' when_operand )* |
Referenced by:
|
when_operand#
Referenced by:
|
result#
| 'NULL' |
Referenced by:
|
cast_specification#
::= 'CAST' '(' cast_operand 'AS' cast_target ')'
| try_cast |
Referenced by:
|
cast_operand#
::= value_expression
|
Referenced by:
|
cast_target#
::= data_type
|
Referenced by:
|
next_value_expression#
::= 'NEXT' 'VALUE' 'FOR' schema_qualified_name |
Referenced by:
|
field_reference#
::= '.' identifier |
Referenced by:
|
subtype_treatment#
::= 'TREAT' '(' value_expression 'AS' target_subtype ')' |
Referenced by:
|
target_subtype#
Referenced by:
|
method_invocation#
Referenced by:
|
direct_invocation#
Referenced by:
|
generalized_invocation#
::= '.' identifier SQL_argument_list? |
Referenced by:
|
static_method_invocation#
::= '::' identifier SQL_argument_list? |
Referenced by:
|
new_specification#
Referenced by:
|
new_invocation#
Not referenced by any.
|
attribute_or_method_reference#
::= lambda_body |
Referenced by:
|
dereference_operation#
::= reference_value_expression '->' identifier |
Not referenced by any.
|
reference_resolution#
::= 'DEREF' '(' reference_value_expression ')' |
Referenced by:
|
array_element_reference#
Referenced by:
|
multiset_element_reference#
::= 'ELEMENT' '(' multiset_value_expression ')' |
Referenced by:
|
value_expression#
common_value_expression#
user_defined_type_value_expression#
Referenced by:
|
reference_value_expression#
collection_value_expression#
numeric_value_expression#
term#
Referenced by:
|
factor#
factor ::= ( '+' | '-' )? numeric_primary |
Referenced by:
|
numeric_primary#
Referenced by:
|
numeric_value_function#
Referenced by:
|
position_expression#
Referenced by:
|
regex_occurrences_function#
::= '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#
::= '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#
::= 'START'
| 'AFTER' |
Referenced by:
|
character_position_expression#
::= 'POSITION' '(' character_value_expression 'IN' character_value_expression ( 'USING' char_length_units )? ')' |
Referenced by:
|
binary_position_expression#
::= 'POSITION' '(' binary_value_expression 'IN' binary_value_expression ')' |
Referenced by:
|
length_expression#
Referenced by:
|
char_length_expression#
::= ( 'CHAR_LENGTH' | 'CHARACTER_LENGTH' ) '(' character_value_expression ( 'USING' char_length_units )? ')' |
Referenced by:
|
octet_length_expression#
::= 'OCTET_LENGTH' '(' string_value_expression ')' |
Referenced by:
|
extract_expression#
::= 'EXTRACT' '(' extract_field 'FROM' extract_source ')' |
Referenced by:
|
extract_field#
Referenced by:
|
time_zone_field#
::= 'TIMEZONE_HOUR'
| 'TIMEZONE_MINUTE' |
Referenced by:
|
extract_source#
Referenced by:
|
cardinality_expression#
::= 'CARDINALITY' '(' collection_value_expression ')' |
Referenced by:
|
max_cardinality_expression#
::= 'MAX_CARDINALITY' '(' array_value_expression ')' |
Referenced by:
|
absolute_value_expression#
::= 'ABS' '(' numeric_value_expression ')' |
Referenced by:
|
modulus_expression#
::= 'MOD' '(' numeric_value_expression ',' numeric_value_expression ')' |
Referenced by:
|
natural_logarithm#
::= 'LN' '(' numeric_value_expression ')' |
Referenced by:
|
exponential_function#
::= 'EXP' '(' numeric_value_expression ')' |
Referenced by:
|
power_function#
::= 'POWER' '(' numeric_value_expression ',' numeric_value_expression ')' |
Referenced by:
|
square_root#
::= 'SQRT' '(' numeric_value_expression ')' |
Referenced by:
|
floor_function#
::= 'FLOOR' '(' numeric_value_expression ')' |
Referenced by:
|
ceiling_function#
::= ( 'CEIL' | 'CEILING' ) '(' numeric_value_expression ')' |
Referenced by:
|
width_bucket_function#
::= 'WIDTH_BUCKET' '(' numeric_value_expression ',' numeric_value_expression ( ',' numeric_value_expression ',' numeric_value_expression )? ')' |
Referenced by:
|
string_value_expression#
character_value_expression#
concatenation#
::= '||' character_factor |
Referenced by:
|
character_factor#
Referenced by:
|
character_primary#
Referenced by:
|
binary_value_expression#
binary_primary#
Referenced by:
|
binary_concatenation#
::= '||' binary_primary |
Referenced by:
|
string_value_function#
Referenced by:
|
character_value_function#
| fold
|
Referenced by:
|
character_substring_function#
::= 'SUBSTRING' '(' character_value_expression 'FROM' numeric_value_expression ( 'FOR' numeric_value_expression )? ( 'USING' char_length_units )? ')' |
Referenced by:
|
regular_expression_substring_function#
::= 'SUBSTRING' '(' character_value_expression 'SIMILAR' character_value_expression 'ESCAPE' character_value_expression ')' |
Referenced by:
|
regex_substring_function#
::= '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#
fold ::= ( 'UPPER' | 'LOWER' ) '(' character_value_expression ')' |
Referenced by:
|
transcoding#
::= 'CONVERT' '(' character_value_expression 'USING' schema_qualified_name ')' |
Referenced by:
|
character_transliteration#
::= 'TRANSLATE' '(' character_value_expression 'USING' schema_qualified_name ')' |
Referenced by:
|
regex_transliteration#
::= '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#
::= 'ALL'
|
Referenced by:
|
trim_function#
::= 'TRIM' '(' trim_operands ')' |
Referenced by:
|
trim_operands#
Referenced by:
|
trim_specification#
::= 'LEADING'
| 'TRAILING'
| 'BOTH' |
Referenced by:
|
character_overlay_function#
::= 'OVERLAY' '(' character_value_expression 'PLACING' character_value_expression 'FROM' numeric_value_expression ( 'FOR' numeric_value_expression )? ( 'USING' char_length_units )? ')' |
Referenced by:
|
normalize_function#
::= 'NORMALIZE' '(' character_value_expression ( ',' normal_form ( ',' normalize_function_result_length )? )? ')' |
Referenced by:
|
normal_form#
::= 'NFC'
| 'NFD'
| 'NFKC'
| 'NFKD' |
Referenced by:
|
normalize_function_result_length#
::= character_length
|
Referenced by:
|
specific_type_method#
::= '.' 'SPECIFICTYPE' ( '(' ')' )? |
Referenced by:
|
binary_value_function#
Referenced by:
|
binary_substring_function#
::= 'SUBSTRING' '(' binary_value_expression 'FROM' numeric_value_expression ( 'FOR' numeric_value_expression )? ')' |
Referenced by:
|
binary_trim_function#
::= 'TRIM' '(' binary_trim_operands ')' |
Referenced by:
|
binary_trim_operands#
Referenced by:
|
binary_overlay_function#
::= 'OVERLAY' '(' binary_value_expression 'PLACING' binary_value_expression 'FROM' numeric_value_expression ( 'FOR' numeric_value_expression )? ')' |
Referenced by:
|
datetime_value_expression#
::= datetime_term
|
datetime_term#
::= datetime_factor |
Referenced by:
|
datetime_factor#
Referenced by:
|
datetime_primary#
Referenced by:
|
time_zone#
::= 'AT' time_zone_specifier |
Referenced by:
|
time_zone_specifier#
::= 'LOCAL'
| 'TIME' 'ZONE' interval_primary |
Referenced by:
|
datetime_value_function#
::= 'CURRENT_DATE'
|
Referenced by:
|
current_time_value_function#
::= 'CURRENT_TIME' ( '(' unsigned_integer ')' )? |
Referenced by:
|
current_local_time_value_function#
::= 'LOCALTIME' ( '(' unsigned_integer ')' )? |
Referenced by:
|
current_timestamp_value_function#
::= 'CURRENT_TIMESTAMP' ( '(' unsigned_integer ')' )? |
Referenced by:
|
current_local_timestamp_value_function#
::= 'LOCALTIMESTAMP' ( '(' unsigned_integer ')' )? |
Referenced by:
|
interval_value_expression#
::= interval_term
|
interval_term#
::= interval_factor ( ( '*' | '/' ) factor )? |
Referenced by:
|
interval_factor#
::= ( '+' | '-' )? interval_primary |
Referenced by:
|
interval_primary#
Referenced by:
|
interval_value_function#
Referenced by:
|
interval_absolute_value_function#
::= 'ABS' '(' interval_value_expression ')' |
Referenced by:
|
boolean_value_expression#
::= boolean_term ( 'OR' boolean_term )* |
boolean_term#
::= boolean_factor ( 'AND' boolean_factor )* |
Referenced by:
|
boolean_factor#
::= 'NOT'? boolean_test |
Referenced by:
|
boolean_test#
::= boolean_primary ( 'IS' 'NOT'? truth_value )? |
Referenced by:
|
truth_value#
::= 'TRUE'
| 'FALSE'
| 'UNKNOWN' |
Referenced by:
|
boolean_primary#
::= predicate
|
Referenced by:
|
boolean_predicand#
Referenced by:
|
parenthesized_boolean_value_expression#
::= '(' boolean_value_expression ')' |
Referenced by:
|
array_value_expression#
::= array_primary ( '||' array_primary )* |
array_value_expression_1#
Not referenced by any.
|
array_primary#
Referenced by:
|
array_value_function#
Referenced by:
|
trim_array_function#
::= 'TRIM_ARRAY' '(' array_value_expression ',' numeric_value_expression ')' |
Referenced by:
|
array_value_constructor#
Referenced by:
|
array_value_constructor_by_enumeration#
Referenced by:
|
array_element_list#
::= array_element ( ',' array_element )* |
Referenced by:
|
array_element#
::= value_expression |
Referenced by:
|
array_value_constructor_by_query#
::= 'ARRAY' subquery |
Referenced by:
|
multiset_value_expression#
::= multiset_term ( 'MULTISET' ( 'UNION' | 'EXCEPT' ) ( 'ALL' | 'DISTINCT' )? multiset_term )? |
multiset_term#
::= multiset_primary ( 'MULTISET' 'INTERSECT' ( 'ALL' | 'DISTINCT' )? multiset_primary )? |
Referenced by:
|
multiset_primary#
Referenced by:
|
multiset_set_function#
::= 'SET' '(' multiset_value_expression ')' |
Referenced by:
|
multiset_value_constructor#
Referenced by:
|
multiset_value_constructor_by_enumeration#
Referenced by:
|
multiset_element_list#
::= multiset_element ( ',' multiset_element )* |
Referenced by:
|
multiset_element#
::= value_expression |
Referenced by:
|
multiset_value_constructor_by_query#
::= 'MULTISET' subquery |
Referenced by:
|
table_value_constructor_by_query#
::= 'TABLE' subquery |
Referenced by:
|
row_value_constructor#
Referenced by:
|
explicit_row_value_constructor#
::= ( 'ROW' '(' row_value_constructor_element_list | '(' row_value_constructor_element ( ',' row_value_constructor_element_list )? ) ')'
| subquery |
row_value_constructor_element_list#
Referenced by:
|
row_value_constructor_element#
::= value_expression |
contextually_typed_row_value_constructor#
Referenced by:
|
contextually_typed_row_value_constructor_element_list#
Referenced by:
|
contextually_typed_row_value_constructor_element#
row_value_constructor_predicand#
Referenced by:
|
row_value_expression#
Referenced by:
|
table_row_value_expression#
Referenced by:
|
contextually_typed_row_value_expression#
Referenced by:
|
row_value_predicand#
row_value_special_case#
table_value_constructor#
::= 'VALUES' row_value_expression_list |
Referenced by:
|
row_value_expression_list#
::= table_row_value_expression ( ',' table_row_value_expression )* |
Referenced by:
|
contextually_typed_table_value_constructor#
::= 'VALUES' contextually_typed_row_value_expression_list |
Referenced by:
|
contextually_typed_row_value_expression_list#
Referenced by:
|
table_expression#
Referenced by:
|
from_clause#
::= 'FROM' table_reference_list |
Referenced by:
|
table_reference_list#
::= table_reference ( ',' table_reference )* |
Referenced by:
|
table_reference#
::= table_factor joined_table* |
table_factor#
Referenced by:
|
sample_clause#
Referenced by:
|
sample_method#
::= 'BERNOULLI'
| 'SYSTEM' |
Referenced by:
|
repeatable_clause#
::= 'REPEATABLE' '(' repeat_argument ')' |
Referenced by:
|
sample_percentage#
Referenced by:
|
repeat_argument#
Referenced by:
|
table_primary#
Referenced by:
|
alias#
Referenced by:
|
system_version_specification#
::= ( '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#
::= 'ONLY' '(' table_or_query_name ')' |
Referenced by:
|
lateral_derived_table#
::= 'LATERAL' subquery |
Referenced by:
|
collection_derived_table#
::= 'UNNEST' '(' collection_value_expression ( ',' collection_value_expression )* ')' ( 'WITH' 'ORDINALITY' )? |
Referenced by:
|
table_function_derived_table#
::= 'TABLE' '(' collection_value_expression ')' |
Referenced by:
|
derived_table#
::= query_expression
| subquery |
Referenced by:
|
table_or_query_name#
::= table_name
|
Referenced by:
|
column_name_list#
::= identifier ( ',' identifier )* |
Referenced by:
|
data_change_delta_table#
::= result_option 'TABLE' '(' data_change_statement ')' |
Referenced by:
|
data_change_statement#
Referenced by:
|
result_option#
::= 'FINAL'
| 'NEW'
| 'OLD' |
Referenced by:
|
parenthesized_joined_table#
Referenced by:
|
joined_table#
::= cross_join
|
Referenced by:
|
cross_join#
::= 'CROSS' 'JOIN' table_factor |
Referenced by:
|
qualified_join#
Referenced by:
|
partitioned_join_table#
::= 'PARTITION' 'BY' partitioned_join_column_reference_list |
Referenced by:
|
partitioned_join_column_reference_list#
::= '(' partitioned_join_column_reference ( ',' partitioned_join_column_reference )* ')' |
Referenced by:
|
partitioned_join_column_reference#
::= column_reference |
Referenced by:
|
natural_join#
Referenced by:
|
join_specification#
::= join_condition
|
Referenced by:
|
join_condition#
::= 'ON' search_condition |
Referenced by:
|
named_columns_join#
::= 'USING' '(' join_column_list ')' |
Referenced by:
|
join_type#
::= 'INNER'
| outer_join_type 'OUTER'? |
Referenced by:
|
outer_join_type#
::= 'LEFT'
| 'RIGHT'
| 'FULL' |
Referenced by:
|
join_column_list#
::= column_name_list |
Referenced by:
|
where_clause#
::= 'WHERE' search_condition |
Referenced by:
|
group_by_clause#
::= 'GROUP' 'BY' set_quantifier? grouping_element_list |
Referenced by:
|
grouping_element_list#
::= grouping_element ( ',' grouping_element )* |
Referenced by:
|
grouping_element#
::= rollup_list
|
Referenced by:
|
ordinary_grouping_set#
| '(' grouping_column_reference_list ')' |
Referenced by:
|
grouping_column_reference#
Referenced by:
|
grouping_column_reference_list#
::= grouping_column_reference ( ',' grouping_column_reference )* |
Referenced by:
|
rollup_list#
::= 'ROLLUP' '(' ordinary_grouping_set_list ')' |
Referenced by:
|
ordinary_grouping_set_list#
::= ordinary_grouping_set ( ',' ordinary_grouping_set )* |
Referenced by:
|
cube_list#
::= 'CUBE' '(' ordinary_grouping_set_list ')' |
Referenced by:
|
grouping_sets_specification#
::= 'GROUPING' 'SETS' '(' grouping_set_list ')' |
Referenced by:
|
grouping_set_list#
::= grouping_set ( ',' grouping_set )* |
Referenced by:
|
grouping_set#
::= rollup_list
|
Referenced by:
|
empty_grouping_set#
::= '(' ')' |
Referenced by:
|
having_clause#
::= 'HAVING' search_condition |
Referenced by:
|
window_clause#
::= 'WINDOW' window_definition_list |
Referenced by:
|
window_definition_list#
::= window_definition ( ',' window_definition )* |
Referenced by:
|
window_definition#
::= identifier 'AS' window_specification |
Referenced by:
|
window_specification#
::= '(' window_specification_details? ')' |
Referenced by:
|
window_specification_details#
Referenced by:
|
existing_identifier#
::= identifier |
Referenced by:
|
window_partition_clause#
::= 'PARTITION' 'BY' window_partition_column_reference_list |
Referenced by:
|
window_partition_column_reference_list#
Referenced by:
|
window_partition_column_reference#
Referenced by:
|
window_order_clause#
::= 'ORDER' 'BY' sort_specification_list |
Referenced by:
|
window_frame_clause#
Referenced by:
|
window_frame_units#
::= 'ROWS'
| 'RANGE' |
Referenced by:
|
window_frame_extent#
Referenced by:
|
window_frame_start#
::= 'UNBOUNDED' 'PRECEDING'
| 'CURRENT' 'ROW'
|
Referenced by:
|
window_frame_preceding#
::= value_expression 'PRECEDING' |
Referenced by:
|
window_frame_between#
::= 'BETWEEN' window_frame_bound 'AND' window_frame_bound |
Referenced by:
|
window_frame_bound#
| 'UNBOUNDED' 'FOLLOWING'
|
Referenced by:
|
window_frame_following#
::= value_expression 'FOLLOWING' |
Referenced by:
|
window_frame_exclusion#
::= 'EXCLUDE' ( 'CURRENT' 'ROW' | 'GROUP' | 'TIES' | 'NO' 'OTHERS' ) |
Referenced by:
|
query_specification#
Referenced by:
|
select_list#
Referenced by:
|
select_sublist#
Referenced by:
|
qualified_asterisk#
::= asterisked_identifier_chain '.' '*'
|
Not referenced by any.
|
asterisked_identifier_chain#
::= identifier ( '.' identifier )* |
Referenced by:
|
derived_column#
Referenced by:
|
as_clause#
::= 'AS'? identifier |
Referenced by:
|
all_fields_reference#
::= value_expression_primary '.' '*' ( 'AS' '(' all_fields_column_name_list ')' )? |
Referenced by:
|
all_fields_column_name_list#
::= column_name_list |
Referenced by:
|
query_expression#
with_clause#
::= 'WITH' 'RECURSIVE'? with_list |
Referenced by:
|
with_list#
::= with_list_element ( ',' with_list_element )* |
Referenced by:
|
with_list_element#
Referenced by:
|
query_expression_body#
Referenced by:
|
query_term#
Referenced by:
|
query_primary#
::= '(' query_expression_body order_by_clause? ( limit_clause | result_offset_clause? fetch_first_clause? )? ')'
|
Referenced by:
|
simple_table#
Referenced by:
|
explicit_table#
::= 'TABLE' table_or_query_name |
Referenced by:
|
corresponding_spec#
::= 'CORRESPONDING' ( 'BY' '(' column_name_list ')' )? |
Referenced by:
|
order_by_clause#
::= 'ORDER' 'BY' sort_specification_list |
Referenced by:
|
result_offset_clause#
::= 'OFFSET' simple_value_specification ( 'ROW' | 'ROWS' ) |
Referenced by:
|
fetch_first_clause#
::= 'FETCH' ( 'FIRST' | 'NEXT' ) simple_value_specification? ( 'ROW' | 'ROWS' ) 'ONLY' |
Referenced by:
|
search_or_cycle_clause#
Referenced by:
|
search_clause#
::= 'SEARCH' recursive_search_order 'SET' identifier |
Referenced by:
|
recursive_search_order#
::= ( 'DEPTH' | 'BREADTH' ) 'FIRST' 'BY' column_name_list |
Referenced by:
|
cycle_clause#
::= 'CYCLE' cycle_column_list 'SET' identifier 'TO' value_expression 'DEFAULT' value_expression 'USING' identifier |
Referenced by:
|
cycle_column_list#
::= identifier ( ',' identifier )* |
Referenced by:
|
subquery#
predicate#
comparison_predicate#
Referenced by:
|
comparison_predicate_part_2#
Referenced by:
|
comp_op#
comp_op ::= '='
| '<>'
| '<'
| '>'
| '<='
| '>='
| '!=' |
between_predicate#
Referenced by:
|
between_predicate_part_2#
::= 'NOT'? 'BETWEEN' ( 'ASYMMETRIC' | 'SYMMETRIC' )? row_value_predicand 'AND' row_value_predicand |
Referenced by:
|
in_predicate#
Referenced by:
|
in_predicate_part_2#
::= 'NOT'? 'IN' in_predicate_value |
Referenced by:
|
in_predicate_value#
::= '(' in_value_list ')'
| subquery |
Referenced by:
|
in_value_list#
::= row_value_expression ( ',' row_value_expression )* |
Referenced by:
|
like_predicate#
Referenced by:
|
character_like_predicate#
Referenced by:
|
character_like_predicate_part_2#
::= 'NOT'? 'LIKE' character_value_expression ( 'ESCAPE' character_value_expression )? |
Referenced by:
|
octet_like_predicate#
Referenced by:
|
octet_like_predicate_part_2#
::= 'NOT'? 'LIKE' binary_value_expression ( 'ESCAPE' binary_value_expression )? |
Referenced by:
|
similar_predicate#
Referenced by:
|
similar_predicate_part_2#
::= 'NOT'? 'SIMILAR' 'TO' character_value_expression ( 'ESCAPE' character_value_expression )? |
Referenced by:
|
regex_like_predicate#
Referenced by:
|
regex_like_predicate_part_2#
::= 'NOT'? 'LIKE_REGEX' character_value_expression ( 'FLAG' character_value_expression )? |
Referenced by:
|
null_predicate#
Referenced by:
|
null_predicate_part_2#
::= 'IS' 'NOT'? 'NULL' |
Referenced by:
|
quantified_comparison_predicate#
Referenced by:
|
quantified_comparison_predicate_part_2#
Referenced by:
|
exists_predicate#
::= 'EXISTS' subquery |
Referenced by:
|
unique_predicate#
::= 'UNIQUE' subquery |
Referenced by:
|
normalized_predicate#
Referenced by:
|
normalized_predicate_part_2#
::= 'IS' 'NOT'? normal_form? 'NORMALIZED' |
Referenced by:
|
match_predicate#
Referenced by:
|
match_predicate_part_2#
::= 'MATCH' 'UNIQUE'? ( 'SIMPLE' | 'PARTIAL' | 'FULL' )? subquery |
Referenced by:
|
overlaps_predicate#
Referenced by:
|
overlaps_predicate_part_1#
Referenced by:
|
overlaps_predicate_part_2#
::= 'OVERLAPS' row_value_predicand_2 |
Referenced by:
|
row_value_predicand_1#
Referenced by:
|
row_value_predicand_2#
Referenced by:
|
distinct_predicate#
Referenced by:
|
distinct_predicate_part_2#
::= 'IS' 'NOT'? 'DISTINCT' 'FROM' row_value_predicand_4 |
Referenced by:
|
row_value_predicand_3#
Not referenced by any.
|
row_value_predicand_4#
Referenced by:
|
member_predicate#
Referenced by:
|
member_predicate_part_2#
::= 'NOT'? 'MEMBER' 'OF'? multiset_value_expression |
Referenced by:
|
submultiset_predicate#
Referenced by:
|
submultiset_predicate_part_2#
::= 'NOT'? 'SUBMULTISET' 'OF'? multiset_value_expression |
Referenced by:
|
set_predicate#
Referenced by:
|
set_predicate_part_2#
::= 'IS' 'NOT'? 'A' 'SET' |
Referenced by:
|
type_predicate#
Referenced by:
|
type_predicate_part_2#
::= 'IS' 'NOT'? 'OF' '(' type_list ')' |
Referenced by:
|
type_list#
Referenced by:
|
user_defined_type_specification#
Referenced by:
|
inclusive_user_defined_type_specification#
Referenced by:
|
exclusive_user_defined_type_specification#
::= 'ONLY' path_resolved_user_defined_type_name |
Referenced by:
|
search_condition#
interval_qualifier#
::= start_field 'TO' end_field
|
start_field#
::= non_second_primary_datetime_field ( '(' interval_leading_field_precision ')' )? |
Referenced by:
|
end_field#
| 'SECOND' ( '(' interval_fractional_seconds_precision ')' )? |
Referenced by:
|
single_datetime_field#
::= start_field
| 'SECOND' ( '(' interval_leading_field_precision ( ',' interval_fractional_seconds_precision )? ')' )? |
Referenced by:
|
primary_datetime_field#
| 'SECOND' |
Referenced by:
|
non_second_primary_datetime_field#
::= 'YEAR'
| 'MONTH'
| 'DAY'
| 'HOUR'
| 'MINUTE' |
Referenced by:
|
interval_fractional_seconds_precision#
::= unsigned_integer |
Referenced by:
|
interval_leading_field_precision#
::= unsigned_integer |
Referenced by:
|
language_clause#
::= 'LANGUAGE' language_name |
language_name#
::= 'ADA'
| 'C'
| 'COBOL'
| 'FORTRAN'
| 'M'
| 'MUMPS'
| 'PASCAL'
| 'PLI'
| 'SQL' |
Referenced by:
|
path_specification#
::= 'PATH' schema_name_list |
Referenced by:
|
schema_name_list#
::= schema_name ( ',' schema_name )* |
Referenced by:
|
routine_invocation#
Referenced by:
|
routine_name#
::= ( schema_name '.' )? identifier |
Referenced by:
|
SQL_argument_list#
::= '(' ( SQL_argument ( ',' SQL_argument )* )? ')' |
SQL_argument#
::= lambda
|
Referenced by:
|
generalized_expression#
::= 'AS' path_resolved_user_defined_type_name |
Referenced by:
|
named_argument_specification#
::= identifier '=>' named_argument_SQL_argument |
Referenced by:
|
named_argument_SQL_argument#
::= value_expression
|
Referenced by:
|
character_set_specification#
standard_character_set_name#
Referenced by:
|
implementation_defined_character_set_name#
Referenced by:
|
user_defined_character_set_name#
Referenced by:
|
specific_routine_designator#
::= 'SPECIFIC' routine_type schema_qualified_name
|
routine_type#
::= 'ROUTINE'
| 'FUNCTION'
| 'PROCEDURE'
| ( 'INSTANCE' | 'STATIC' | 'CONSTRUCTOR' )? 'METHOD' |
Referenced by:
|
member_name#
Referenced by:
|
member_name_alternatives#
Referenced by:
|
data_type_list#
Referenced by:
|
collate_clause#
::= 'COLLATE' schema_qualified_name |
constraint_name_definition#
::= 'CONSTRAINT' schema_qualified_name |
constraint_characteristics#
::= ( constraint_check_time ( 'NOT'? 'DEFERRABLE' )? | 'NOT'? 'DEFERRABLE' constraint_check_time? ) constraint_enforcement?
|
constraint_check_time#
::= 'INITIALLY' ( 'DEFERRED' | 'IMMEDIATE' ) |
Referenced by:
|
constraint_enforcement#
::= 'NOT'? 'ENFORCED' |
Referenced by:
|
aggregate_function#
::= ( 'COUNT' '(' '*' ')' | count | general_set_function | binary_set_function | ordered_set_function | array_aggregate_function | presto_aggregations ) filter_clause? |
Referenced by:
|
general_set_function#
Referenced by:
|
set_function_type#
Referenced by:
|
computational_operation#
::= 'AVG'
| 'MAX'
| 'MIN'
| 'SUM'
| 'EVERY'
| 'ANY'
| 'SOME'
| 'COUNT'
| 'STDDEV_POP'
| 'STDDEV_SAMP'
| 'VAR_SAMP'
| 'VAR_POP'
| 'COLLECT'
| 'FUSION'
| 'INTERSECTION' |
Referenced by:
|
set_quantifier#
::= 'DISTINCT'
| 'ALL' |
filter_clause#
::= 'FILTER' '(' 'WHERE' search_condition ')' |
Referenced by:
|
binary_set_function#
Referenced by:
|
binary_set_function_type#
::= '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#
Referenced by:
|
independent_variable_expression#
Referenced by:
|
ordered_set_function#
Referenced by:
|
hypothetical_set_function#
Referenced by:
|
within_group_specification#
::= 'WITHIN' 'GROUP' '(' 'ORDER' 'BY' sort_specification_list ')' |
Referenced by:
|
hypothetical_set_function_value_expression_list#
::= value_expression ( ',' value_expression )* |
Referenced by:
|
inverse_distribution_function#
Referenced by:
|
inverse_distribution_function_argument#
Referenced by:
|
inverse_distribution_function_type#
::= 'PERCENTILE_CONT'
| 'PERCENTILE_DISC' |
Referenced by:
|
array_aggregate_function#
::= 'ARRAY_AGG' '(' 'DISTINCT'? value_expression ( 'ORDER' 'BY' sort_specification_list )? ')' |
Referenced by:
|
sort_specification_list#
::= sort_specification ( ',' sort_specification )* |
sort_specification#
Referenced by:
|
sort_key#
Referenced by:
|
ordering_specification#
::= 'ASC'
| 'DESC' |
Referenced by:
|
null_ordering#
::= 'NULLS' ( 'FIRST' | 'LAST' ) |
Referenced by:
|
schema_definition#
::= 'CREATE' 'SCHEMA' if_not_exists? schema_name_clause schema_character_set_or_path? schema_element* |
Referenced by:
|
schema_character_set_or_path#
Referenced by:
|
schema_name_clause#
::= schema_name ( 'AUTHORIZATION' identifier )?
| 'AUTHORIZATION' identifier |
Referenced by:
|
schema_character_set_specification#
::= 'DEFAULT' 'CHARACTER' 'SET' character_set_specification |
Referenced by:
|
schema_path_specification#
Referenced by:
|
schema_element#
::= table_definition
|
Referenced by:
|
drop_schema_statement#
::= 'DROP' 'SCHEMA' schema_name drop_behavior |
Referenced by:
|
drop_behavior#
table_definition#
::= '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#
Referenced by:
|
table_scope#
::= global_or_local 'TEMPORARY' |
Referenced by:
|
global_or_local#
::= 'GLOBAL'
| 'LOCAL' |
Referenced by:
|
system_versioning_clause#
::= 'SYSTEM' 'VERSIONING' retention_period_specification? |
Referenced by:
|
retention_period_specification#
::= 'KEEP' 'VERSIONS' ( 'FOREVER' | 'FOR' length_of_time time_unit ) |
Referenced by:
|
length_of_time#
::= unsigned_integer |
Referenced by:
|
time_unit#
::= 'SECOND'
| 'SECONDS'
| 'MINUTE'
| 'MINUTES'
| 'HOUR'
| 'HOURS'
| 'DAY'
| 'DAYS'
| 'MONTH'
| 'MONTHS'
| 'YEAR'
| 'YEARS' |
Referenced by:
|
table_commit_action#
::= 'PRESERVE'
| 'DELETE' |
Referenced by:
|
table_element_list#
::= '(' table_element ( ',' table_element )* ')' |
Referenced by:
|
table_element#
Referenced by:
|
typed_table_clause#
Referenced by:
|
typed_table_element_list#
::= '(' typed_table_element ( ',' typed_table_element )* ')' |
Referenced by:
|
typed_table_element#
::= column_options
|
Referenced by:
|
self_referencing_column_specification#
::= 'REF' 'IS' identifier reference_generation? |
Referenced by:
|
reference_generation#
::= ( 'SYSTEM' | 'USER' ) 'GENERATED'
| 'DERIVED' |
Referenced by:
|
column_options#
::= identifier 'WITH' 'OPTIONS' column_option_list |
Referenced by:
|
column_option_list#
Referenced by:
|
subtable_clause#
::= 'UNDER' supertable_clause |
Referenced by:
|
supertable_clause#
::= supertable_name |
Referenced by:
|
supertable_name#
::= table_name |
Referenced by:
|
like_clause#
::= 'LIKE' table_name like_options? |
Referenced by:
|
like_options#
::= like_option+ |
Referenced by:
|
like_option#
::= identity_option
| 'INCLUDING' 'PROPERTIES' |
Referenced by:
|
identity_option#
::= ( 'INCLUDING' | 'EXCLUDING' ) 'IDENTITY' |
Referenced by:
|
column_default_option#
::= ( 'INCLUDING' | 'EXCLUDING' ) 'DEFAULTS' |
Referenced by:
|
generation_option#
::= ( 'INCLUDING' | 'EXCLUDING' ) 'GENERATED' |
Referenced by:
|
as_subquery_clause#
::= ( '(' column_name_list ')' )? ( 'WITH' table_attributes )? 'AS' ( subquery | query_expression ) with_or_without_data? |
Referenced by:
|
with_or_without_data#
::= 'WITH' 'NO'? 'DATA' |
Referenced by:
|
column_definition#
data_type_or_schema_qualified_name#
::= data_type
|
Referenced by:
|
system_version_start_column_specification#
::= timestamp_generation_rule 'AS' 'SYSTEM' 'VERSION' 'START' |
Referenced by:
|
system_version_end_column_specification#
::= timestamp_generation_rule 'AS' 'SYSTEM' 'VERSION' 'END' |
Referenced by:
|
timestamp_generation_rule#
::= 'GENERATED' 'ALWAYS' |
column_constraint_definition#
Referenced by:
|
column_constraint#
::= 'NOT' 'NULL'
|
Referenced by:
|
identity_column_specification#
::= 'GENERATED' ( 'ALWAYS' | 'BY' 'DEFAULT' ) 'AS' 'IDENTITY' ( '(' common_sequence_generator_options ')' )? |
Referenced by:
|
generation_clause#
::= generation_rule 'AS' generation_expression |
Referenced by:
|
generation_rule#
::= 'GENERATED' 'ALWAYS' |
Referenced by:
|
generation_expression#
::= '(' value_expression ')' |
Referenced by:
|
default_clause#
::= 'DEFAULT' default_option |
default_option#
::= literal
| 'USER'
| 'CURRENT_USER'
| 'CURRENT_ROLE'
| 'SESSION_USER'
| 'SYSTEM_USER'
| 'CURRENT_CATALOG'
| 'CURRENT_SCHEMA'
| 'CURRENT_PATH'
|
Referenced by:
|
table_constraint_definition#
table_constraint#
Referenced by:
|
unique_constraint_definition#
::= unique_specification '(' unique_column_list ')'
| 'UNIQUE' 'VALUE' |
Referenced by:
|
unique_specification#
::= 'UNIQUE'
| 'PRIMARY' 'KEY' |
Referenced by:
|
unique_column_list#
::= column_name_list |
Referenced by:
|
referential_constraint_definition#
::= 'FOREIGN' 'KEY' '(' referencing_columns ')' references_specification |
Referenced by:
|
references_specification#
Referenced by:
|
match_type#
::= 'FULL'
| 'PARTIAL'
| 'SIMPLE' |
Referenced by:
|
referencing_columns#
Referenced by:
|
referenced_table_and_columns#
::= table_name ( '(' reference_column_list ')' )? |
Referenced by:
|
reference_column_list#
::= column_name_list |
Referenced by:
|
referential_triggered_action#
::= update_rule delete_rule?
|
Referenced by:
|
update_rule#
::= 'ON' 'UPDATE' referential_action |
Referenced by:
|
delete_rule#
::= 'ON' 'DELETE' referential_action |
Referenced by:
|
referential_action#
::= 'CASCADE'
| 'SET' ( 'NULL' | 'DEFAULT' )
| 'RESTRICT'
| 'NO' 'ACTION' |
Referenced by:
|
check_constraint_definition#
::= 'CHECK' '(' search_condition ')' |
Referenced by:
|
alter_table_statement#
::= 'ALTER' 'TABLE' table_name alter_table_action |
Referenced by:
|
alter_table_action#
Referenced by:
|
add_column_definition#
::= 'ADD' 'COLUMN'? column_definition |
Referenced by:
|
alter_column_definition#
::= 'ALTER' 'COLUMN'? identifier alter_column_action |
Referenced by:
|
alter_column_action#
Referenced by:
|
set_column_default_clause#
::= 'SET' default_clause |
Referenced by:
|
drop_column_default_clause#
::= 'DROP' 'DEFAULT' |
Referenced by:
|
set_column_not_null_clause#
::= 'SET' 'NOT' 'NULL' |
Referenced by:
|
drop_column_not_null_clause#
::= 'DROP' 'NOT' 'NULL' |
Referenced by:
|
add_column_scope_clause#
::= 'ADD' scope_clause |
Referenced by:
|
drop_column_scope_clause#
::= 'DROP' 'SCOPE' drop_behavior |
Referenced by:
|
alter_column_data_type_clause#
::= 'SET' 'DATA' 'TYPE' data_type |
Referenced by:
|
alter_identity_column_specification#
Referenced by:
|
set_identity_column_generation_clause#
::= 'SET' 'GENERATED' ( 'ALWAYS' | 'BY' 'DEFAULT' ) |
Referenced by:
|
alter_identity_column_option#
| 'SET' basic_sequence_generator_option |
Referenced by:
|
drop_identity_property_clause#
::= 'DROP' 'IDENTITY' |
Referenced by:
|
drop_column_generation_expression_clause#
::= 'DROP' 'EXPRESSION' |
Referenced by:
|
drop_column_definition#
::= 'DROP' 'COLUMN'? identifier drop_behavior |
Referenced by:
|
add_table_constraint_definition#
::= 'ADD' table_constraint_definition |
Referenced by:
|
alter_table_constraint_definition#
::= 'ALTER' 'CONSTRAINT' schema_qualified_name constraint_enforcement |
Referenced by:
|
drop_table_constraint_definition#
::= 'DROP' 'CONSTRAINT' schema_qualified_name drop_behavior |
Referenced by:
|
add_system_versioning_clause#
Referenced by:
|
add_system_version_column_list#
::= 'ADD' 'COLUMN'? column_definition_1 'ADD' 'COLUMN'? column_definition_2 |
Referenced by:
|
column_definition_1#
Referenced by:
|
column_definition_2#
Referenced by:
|
alter_system_versioning_clause#
::= 'ALTER' 'SYSTEM' 'VERSIONING' retention_period_specification |
Referenced by:
|
drop_system_versioning_clause#
::= 'DROP' 'SYSTEM' 'VERSIONING' drop_behavior |
Referenced by:
|
drop_table_statement#
::= 'DROP' 'TABLE' ( 'IF' 'EXISTS' )? table_name drop_behavior? |
Referenced by:
|
view_definition#
::= 'CREATE' or_replace? 'RECURSIVE'? 'VIEW' table_name view_specification 'AS' query_expression ( 'WITH' levels_clause? 'CHECK' 'OPTION' )? |
Referenced by:
|
view_specification#
Referenced by:
|
regular_view_specification#
::= ( '(' view_column_list ')' )? |
Referenced by:
|
referenceable_view_specification#
Referenced by:
|
subview_clause#
::= 'UNDER' table_name |
Referenced by:
|
view_element_list#
::= '(' view_element ( ',' view_element )* ')' |
Referenced by:
|
view_element#
Referenced by:
|
view_column_option#
::= identifier 'WITH' 'OPTIONS' scope_clause |
Referenced by:
|
levels_clause#
::= 'CASCADED'
| 'LOCAL' |
Referenced by:
|
view_column_list#
::= column_name_list |
Referenced by:
|
drop_view_statement#
::= 'DROP' 'VIEW' table_name drop_behavior |
Referenced by:
|
domain_definition#
::= 'CREATE' 'DOMAIN' schema_qualified_name 'AS'? predefined_type default_clause? domain_constraint* collate_clause? |
Referenced by:
|
domain_constraint#
Referenced by:
|
alter_domain_statement#
::= 'ALTER' 'DOMAIN' schema_qualified_name alter_domain_action |
Referenced by:
|
alter_domain_action#
Referenced by:
|
set_domain_default_clause#
::= 'SET' default_clause |
Referenced by:
|
drop_domain_default_clause#
::= 'DROP' 'DEFAULT' |
Referenced by:
|
add_domain_constraint_definition#
::= 'ADD' domain_constraint |
Referenced by:
|
drop_domain_constraint_definition#
::= 'DROP' 'CONSTRAINT' schema_qualified_name |
Referenced by:
|
drop_domain_statement#
::= 'DROP' 'DOMAIN' schema_qualified_name drop_behavior |
Referenced by:
|
character_set_definition#
Referenced by:
|
character_set_source#
::= 'GET' character_set_specification |
Referenced by:
|
drop_character_set_statement#
::= 'DROP' 'CHARACTER' 'SET' character_set_name |
Referenced by:
|
collation_definition#
::= 'CREATE' 'COLLATION' schema_qualified_name 'FOR' character_set_specification 'FROM' schema_qualified_name pad_characteristic? |
Referenced by:
|
pad_characteristic#
::= 'NO' 'PAD'
| 'PAD' 'SPACE' |
Referenced by:
|
drop_collation_statement#
::= 'DROP' 'COLLATION' schema_qualified_name drop_behavior |
Referenced by:
|
transliteration_definition#
::= 'CREATE' 'TRANSLATION' schema_qualified_name 'FOR' source_character_set_specification 'TO' target_character_set_specification 'FROM' transliteration_source |
Referenced by:
|
source_character_set_specification#
Referenced by:
|
target_character_set_specification#
Referenced by:
|
transliteration_source#
Referenced by:
|
transliteration_routine#
Referenced by:
|
drop_transliteration_statement#
::= 'DROP' 'TRANSLATION' schema_qualified_name |
Referenced by:
|
assertion_definition#
::= 'CREATE' 'ASSERTION' schema_qualified_name 'CHECK' '(' search_condition ')' constraint_characteristics? |
Referenced by:
|
drop_assertion_statement#
::= 'DROP' 'ASSERTION' schema_qualified_name drop_behavior? |
Referenced by:
|
trigger_definition#
::= '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#
::= 'BEFORE'
| 'AFTER'
| 'INSTEAD' 'OF' |
Referenced by:
|
trigger_event#
::= 'INSERT'
| 'DELETE'
| 'UPDATE' ( 'OF' trigger_column_list )? |
Referenced by:
|
trigger_column_list#
::= column_name_list |
Referenced by:
|
triggered_action#
::= ( 'FOR' 'EACH' ( 'ROW' | 'STATEMENT' ) )? triggered_when_clause? triggered_SQL_statement |
Referenced by:
|
triggered_when_clause#
::= 'WHEN' '(' search_condition ')' |
Referenced by:
|
triggered_SQL_statement#
| 'BEGIN' 'ATOMIC' ( SQL_procedure_statement ';' )+ 'END' |
Referenced by:
|
transition_table_or_variable_list#
Referenced by:
|
transition_table_or_variable#
::= ( 'OLD' | 'NEW' ) ( 'ROW' | 'TABLE' )? 'AS'? identifier |
Referenced by:
|
drop_trigger_statement#
::= 'DROP' 'TRIGGER' schema_qualified_name |
Referenced by:
|
user_defined_type_definition#
::= 'CREATE' 'TYPE' user_defined_type_body |
Referenced by:
|
user_defined_type_body#
Referenced by:
|
user_defined_type_option_list#
Referenced by:
|
user_defined_type_option#
| finality
|
Referenced by:
|
subtype_clause#
::= 'UNDER' supertype_name |
Referenced by:
|
supertype_name#
Referenced by:
|
representation#
::= predefined_type
|
Referenced by:
|
member_list#
Referenced by:
|
member#
Referenced by:
|
instantiable_clause#
::= 'NOT'? 'INSTANTIABLE' |
Referenced by:
|
finality#
finality ::= 'NOT'? 'FINAL' |
Referenced by:
|
reference_type_specification#
Referenced by:
|
user_defined_representation#
::= 'REF' 'USING' predefined_type |
Referenced by:
|
derived_representation#
::= 'REF' 'FROM' list_of_attributes |
Referenced by:
|
system_generated_representation#
::= 'REF' 'IS' 'SYSTEM' 'GENERATED' |
Referenced by:
|
cast_to_ref#
::= 'CAST' '(' 'SOURCE' 'AS' 'REF' ')' 'WITH' identifier |
Referenced by:
|
cast_to_type#
::= 'CAST' '(' 'REF' 'AS' 'SOURCE' ')' 'WITH' identifier |
Referenced by:
|
list_of_attributes#
::= '(' identifier ( ',' identifier )* ')' |
Referenced by:
|
cast_to_distinct#
::= 'CAST' '(' 'SOURCE' 'AS' 'DISTINCT' ')' 'WITH' identifier |
Referenced by:
|
cast_to_source#
::= 'CAST' '(' 'DISTINCT' 'AS' 'SOURCE' ')' 'WITH' identifier |
Referenced by:
|
method_specification_list#
::= method_specification ( ',' method_specification )* |
Referenced by:
|
method_specification#
Referenced by:
|
original_method_specification#
::= partial_method_specification ( 'SELF' 'AS' 'RESULT' )? ( 'SELF' 'AS' 'LOCATOR' )? method_characteristics? |
Referenced by:
|
overriding_method_specification#
::= 'OVERRIDING' partial_method_specification |
Referenced by:
|
partial_method_specification#
::= ( 'INSTANCE' | 'STATIC' | 'CONSTRUCTOR' )? 'METHOD' identifier SQL_parameter_declaration_list returns_clause ( 'SPECIFIC' specific_identifier )? |
Referenced by:
|
specific_identifier#
::= ( schema_name '.' )? identifier |
Referenced by:
|
method_characteristics#
Referenced by:
|
method_characteristic#
::= language_clause
|
Referenced by:
|
attribute_definition#
Referenced by:
|
attribute_default#
::= default_clause |
Referenced by:
|
alter_type_statement#
::= 'ALTER' 'TYPE' schema_resolved_user_defined_type_name alter_type_action |
Referenced by:
|
alter_type_action#
Referenced by:
|
add_attribute_definition#
::= 'ADD' 'ATTRIBUTE' attribute_definition |
Referenced by:
|
drop_attribute_definition#
::= 'DROP' 'ATTRIBUTE' identifier 'RESTRICT' |
Referenced by:
|
add_original_method_specification#
::= 'ADD' original_method_specification |
Referenced by:
|
add_overriding_method_specification#
::= 'ADD' overriding_method_specification |
Referenced by:
|
drop_method_specification#
::= 'DROP' specific_method_specification_designator 'RESTRICT' |
Referenced by:
|
specific_method_specification_designator#
::= ( 'INSTANCE' | 'STATIC' | 'CONSTRUCTOR' )? 'METHOD' identifier data_type_list |
Referenced by:
|
drop_data_type_statement#
::= 'DROP' 'TYPE' schema_resolved_user_defined_type_name drop_behavior |
Referenced by:
|
SQL_invoked_routine#
::= schema_routine |
Referenced by:
|
schema_routine#
::= schema_procedure
|
Referenced by:
|
schema_procedure#
::= 'CREATE' SQL_invoked_procedure |
Referenced by:
|
schema_function#
::= 'CREATE' or_replace? SQL_invoked_function |
Referenced by:
|
SQL_invoked_procedure#
Referenced by:
|
SQL_invoked_function#
Referenced by:
|
SQL_parameter_declaration_list#
::= '(' ( SQL_parameter_declaration ( ',' SQL_parameter_declaration )* )? ')' |
SQL_parameter_declaration#
Referenced by:
|
parameter_default#
::= value_expression
|
Referenced by:
|
parameter_mode#
::= 'IN'
| 'OUT'
| 'INOUT' |
Referenced by:
|
parameter_type#
Referenced by:
|
locator_indication#
::= 'AS' 'LOCATOR' |
function_specification#
Referenced by:
|
method_specification_designator#
::= '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#
Referenced by:
|
routine_characteristic#
::= language_clause
| 'SPECIFIC' schema_qualified_name
|
Referenced by:
|
savepoint_level_indication#
::= ( 'NEW' | 'OLD' ) 'SAVEPOINT' 'LEVEL' |
Referenced by:
|
returned_result_sets_characteristic#
::= 'DYNAMIC' 'RESULT' 'SETS' maximum_returned_result_sets |
Referenced by:
|
parameter_style_clause#
::= 'PARAMETER' 'STYLE' parameter_style |
dispatch_clause#
::= 'STATIC' 'DISPATCH' |
Referenced by:
|
returns_clause#
::= 'RETURNS' returns_type |
returns_type#
Referenced by:
|
returns_table_type#
::= 'TABLE' table_function_column_list |
Referenced by:
|
table_function_column_list#
::= '(' table_function_column_list_element ( ',' table_function_column_list_element )* ')' |
Referenced by:
|
table_function_column_list_element#
::= identifier data_type |
Referenced by:
|
result_cast#
::= 'CAST' 'FROM' result_cast_from_type |
Referenced by:
|
result_cast_from_type#
Referenced by:
|
returns_data_type#
Referenced by:
|
routine_body#
::= SQL_routine_spec
|
Referenced by:
|
SQL_routine_spec#
Referenced by:
|
rights_clause#
::= 'SQL' 'SECURITY' ( 'INVOKER' | 'DEFINER' ) |
Referenced by:
|
SQL_routine_body#
Referenced by:
|
external_body_reference#
::= 'EXTERNAL' ( 'NAME' external_routine_name )? parameter_style_clause? transform_group_specification? external_security_clause? |
Referenced by:
|
external_security_clause#
::= 'EXTERNAL' 'SECURITY' ( 'DEFINER' | 'INVOKER' | 'IMPLEMENTATION' 'DEFINED'
) |
Referenced by:
|
parameter_style#
::= 'SQL'
| 'GENERAL' |
Referenced by:
|
deterministic_characteristic#
::= 'NOT'? 'DETERMINISTIC' |
Referenced by:
|
SQL_data_access_indication#
::= ( 'NO' | 'CONTAINS' ) 'SQL'
| ( 'READS' | 'MODIFIES' ) 'SQL' 'DATA' |
null_call_clause#
::= ( 'RETURNS' 'NULL' | 'CALLED' ) 'ON' 'NULL' 'INPUT' |
maximum_returned_result_sets#
::= unsigned_integer |
Referenced by:
|
transform_group_specification#
::= 'TRANSFORM' 'GROUP' ( single_group_specification | multiple_group_specification ) |
Referenced by:
|
single_group_specification#
::= identifier |
Referenced by:
|
multiple_group_specification#
::= group_specification ( ',' group_specification )* |
Referenced by:
|
group_specification#
::= identifier 'FOR' 'TYPE' path_resolved_user_defined_type_name |
Referenced by:
|
alter_routine_statement#
::= 'ALTER' specific_routine_designator alter_routine_characteristics 'RESTRICT' |
Referenced by:
|
alter_routine_characteristics#
Referenced by:
|
alter_routine_characteristic#
::= language_clause
| 'NAME' external_routine_name |
Referenced by:
|
drop_routine_statement#
::= 'DROP' specific_routine_designator drop_behavior |
Referenced by:
|
user_defined_cast_definition#
::= 'CREATE' 'CAST' '(' source_data_type 'AS' target_data_type ')' 'WITH' cast_function ( 'AS' 'ASSIGNMENT' )? |
Referenced by:
|
cast_function#
Referenced by:
|
source_data_type#
::= data_type |
Referenced by:
|
target_data_type#
::= data_type |
Referenced by:
|
drop_user_defined_cast_statement#
Referenced by:
|
user_defined_ordering_definition#
::= 'CREATE' 'ORDERING' 'FOR' schema_resolved_user_defined_type_name ordering_form |
Referenced by:
|
ordering_form#
Referenced by:
|
equals_ordering_form#
::= 'EQUALS' 'ONLY' 'BY' ordering_category |
Referenced by:
|
full_ordering_form#
::= 'ORDER' 'FULL' 'BY' ordering_category |
Referenced by:
|
ordering_category#
Referenced by:
|
relative_category#
::= 'RELATIVE' 'WITH' relative_function_specification |
Referenced by:
|
map_category#
::= 'MAP' 'WITH' map_function_specification |
Referenced by:
|
state_category#
::= 'STATE' schema_qualified_name? |
Referenced by:
|
relative_function_specification#
Referenced by:
|
map_function_specification#
Referenced by:
|
drop_user_defined_ordering_statement#
::= 'DROP' 'ORDERING' 'FOR' schema_resolved_user_defined_type_name drop_behavior |
Referenced by:
|
transform_definition#
::= 'CREATE' ( 'TRANSFORM' | 'TRANSFORMS' ) 'FOR' schema_resolved_user_defined_type_name transform_group+ |
Referenced by:
|
transform_group#
::= identifier '(' transform_element_list ')' |
Referenced by:
|
transform_element_list#
::= transform_element ( ',' transform_element )? |
Referenced by:
|
transform_element#
::= to_sql
| from_sql |
Referenced by:
|
to_sql#
to_sql ::= 'TO' 'SQL' 'WITH' to_sql_function |
Referenced by:
|
from_sql#
from_sql ::= 'FROM' 'SQL' 'WITH' from_sql_function |
Referenced by:
|
to_sql_function#
Referenced by:
|
from_sql_function#
Referenced by:
|
alter_transform_statement#
::= 'ALTER' ( 'TRANSFORM' | 'TRANSFORMS' ) 'FOR' schema_resolved_user_defined_type_name alter_group+ |
Referenced by:
|
alter_group#
::= identifier '(' alter_transform_action_list ')' |
Referenced by:
|
alter_transform_action_list#
::= alter_transform_action ( ',' alter_transform_action )* |
Referenced by:
|
alter_transform_action#
Referenced by:
|
add_transform_element_list#
::= 'ADD' '(' transform_element_list ')' |
Referenced by:
|
drop_transform_element_list#
Referenced by:
|
transform_kind#
::= ( 'TO' | 'FROM' ) 'SQL' |
Referenced by:
|
drop_transform_statement#
::= 'DROP' ( 'TRANSFORM' | 'TRANSFORMS' ) transforms_to_be_dropped 'FOR' schema_resolved_user_defined_type_name drop_behavior |
Referenced by:
|
transforms_to_be_dropped#
::= 'ALL'
|
Referenced by:
|
transform_group_element#
::= identifier |
Referenced by:
|
sequence_generator_definition#
::= 'CREATE' 'SEQUENCE' schema_qualified_name sequence_generator_options? |
Referenced by:
|
sequence_generator_options#
Referenced by:
|
sequence_generator_option#
Referenced by:
|
common_sequence_generator_options#
Referenced by:
|
common_sequence_generator_option#
Referenced by:
|
basic_sequence_generator_option#
sequence_generator_data_type_option#
::= 'AS' data_type |
Referenced by:
|
sequence_generator_start_with_option#
::= 'START' 'WITH' sequence_generator_start_value |
Referenced by:
|
sequence_generator_start_value#
Referenced by:
|
sequence_generator_increment_by_option#
::= 'INCREMENT' 'BY' sequence_generator_increment |
Referenced by:
|
sequence_generator_increment#
Referenced by:
|
sequence_generator_maxvalue_option#
::= 'MAXVALUE' sequence_generator_max_value
| 'NO' 'MAXVALUE' |
Referenced by:
|
sequence_generator_max_value#
Referenced by:
|
sequence_generator_minvalue_option#
::= 'MINVALUE' sequence_generator_min_value
| 'NO' 'MINVALUE' |
Referenced by:
|
sequence_generator_min_value#
Referenced by:
|
sequence_generator_cycle_option#
::= 'NO'? 'CYCLE' |
Referenced by:
|
alter_sequence_generator_statement#
::= 'ALTER' 'SEQUENCE' schema_qualified_name alter_sequence_generator_options |
Referenced by:
|
alter_sequence_generator_options#
Referenced by:
|
alter_sequence_generator_option#
Referenced by:
|
alter_sequence_generator_restart_option#
::= 'RESTART' ( 'WITH' sequence_generator_restart_value )? |
Referenced by:
|
sequence_generator_restart_value#
Referenced by:
|
drop_sequence_generator_statement#
::= 'DROP' 'SEQUENCE' schema_qualified_name drop_behavior |
Referenced by:
|
grant_statement#
Referenced by:
|
grant_privilege_statement#
::= 'GRANT' privileges 'TO' grantee ( ',' grantee )* ( 'WITH' 'HIERARCHY' 'OPTION' )? ( 'WITH' 'GRANT' 'OPTION' )? ( 'GRANTED' 'BY'
grantor )? |
Referenced by:
|
privileges#
::= object_privileges 'ON' object_name |
Referenced by:
|
object_name#
::= 'TABLE'? table_name
| ( 'DOMAIN' | 'COLLATION' | 'TRANSLATION' | 'SEQUENCE' ) schema_qualified_name
| 'CHARACTER' 'SET' character_set_name
|
Referenced by:
|
object_privileges#
::= 'ALL' 'PRIVILEGES'
|
Referenced by:
|
action#
| 'DELETE'
| ( 'INSERT' | 'UPDATE' | 'REFERENCES' ) ( '(' privilege_column_list ')' )?
| 'USAGE'
| 'TRIGGER'
| 'UNDER'
| 'EXECUTE' |
Referenced by:
|
privilege_method_list#
::= specific_routine_designator ( ',' specific_routine_designator )* |
Referenced by:
|
privilege_column_list#
::= column_name_list |
Referenced by:
|
grantee#
grantee ::= 'PUBLIC'
|
grantor#
grantor ::= 'CURRENT_USER'
| 'CURRENT_ROLE' |
role_definition#
::= 'CREATE' 'ROLE' identifier ( 'WITH' 'ADMIN' grantor )? |
Referenced by:
|
grant_role_statement#
::= 'GRANT' identifier ( ',' identifier )* 'TO' grantee ( ',' grantee )* ( 'WITH' 'ADMIN' 'OPTION' )? ( 'GRANTED' 'BY' grantor )? |
Referenced by:
|
drop_role_statement#
::= 'DROP' 'ROLE' identifier |
Referenced by:
|
revoke_statement#
Referenced by:
|
revoke_privilege_statement#
::= 'REVOKE' revoke_option_extension? privileges 'FROM' grantee ( ',' grantee )* ( 'GRANTED' 'BY' grantor )? drop_behavior |
Referenced by:
|
revoke_option_extension#
::= ( 'GRANT' | 'HIERARCHY' ) 'OPTION' 'FOR' |
Referenced by:
|
revoke_role_statement#
::= 'REVOKE' ( 'ADMIN' 'OPTION' 'FOR' )? identifier ( ',' identifier )* 'FROM' grantee ( ',' grantee )* ( 'GRANTED' 'BY' grantor )? drop_behavior |
Referenced by:
|
SQL_client_module_definition#
Not referenced by any.
|
module_path_specification#
Referenced by:
|
module_transform_group_specification#
Referenced by:
|
module_collations#
Referenced by:
|
module_collation_specification#
::= 'COLLATION' schema_qualified_name ( 'FOR' character_set_specification_list )? |
Referenced by:
|
character_set_specification_list#
::= character_set_specification ( ',' character_set_specification )* |
module_contents#
::= declare_cursor
|
Referenced by:
|
module_name_clause#
::= 'MODULE' identifier? module_character_set_specification? |
Referenced by:
|
module_character_set_specification#
::= 'NAMES' 'ARE' character_set_specification |
Referenced by:
|
externally_invoked_procedure#
Referenced by:
|
host_parameter_declaration_list#
::= '(' host_parameter_declaration ( ',' host_parameter_declaration )* ')' |
Referenced by:
|
host_parameter_declaration#
| 'SQLSTATE' |
Referenced by:
|
host_parameter_data_type#
Referenced by:
|
SQL_procedure_statement#
SQL_executable_statement#
Referenced by:
|
SQL_schema_statement#
SQL_schema_definition_statement#
Referenced by:
|
SQL_schema_manipulation_statement#
Referenced by:
|
SQL_data_statement#
::= open_statement
|
Referenced by:
|
SQL_data_change_statement#
Referenced by:
|
SQL_control_statement#
::= call_statement
|
Referenced by:
|
SQL_transaction_statement#
SQL_connection_statement#
Referenced by:
|
SQL_session_statement#
SQL_diagnostics_statement#
Referenced by:
|
SQL_dynamic_statement#
Referenced by:
|
SQL_dynamic_data_statement#
Referenced by:
|
SQL_descriptor_statement#
Referenced by:
|
declare_cursor#
Referenced by:
|
cursor_properties#
Referenced by:
|
cursor_sensitivity#
::= 'SENSITIVE'
| 'INSENSITIVE'
| 'ASENSITIVE' |
Referenced by:
|
cursor_scrollability#
::= 'NO'? 'SCROLL' |
Referenced by:
|
cursor_holdability#
::= ( 'WITH' | 'WITHOUT' ) 'HOLD' |
Referenced by:
|
cursor_returnability#
::= ( 'WITH' | 'WITHOUT' ) 'RETURN' |
Referenced by:
|
cursor_specification#
updatability_clause#
::= 'FOR' ( 'READ' 'ONLY' | 'UPDATE' ( 'OF' column_name_list )? ) |
Referenced by:
|
open_statement#
::= 'OPEN' cursor_name |
Referenced by:
|
fetch_statement#
Referenced by:
|
fetch_orientation#
::= 'NEXT'
| 'PRIOR'
| 'FIRST'
| 'LAST'
| ( 'ABSOLUTE' | 'RELATIVE' ) simple_value_specification |
Referenced by:
|
fetch_target_list#
::= target_specification ( ',' target_specification )* |
Referenced by:
|
close_statement#
::= 'CLOSE' cursor_name |
Referenced by:
|
select_statement_single_row#
Referenced by:
|
select_target_list#
::= target_specification ( ',' target_specification )* |
Referenced by:
|
delete_statement_positioned#
Referenced by:
|
target_table#
delete_statement_searched#
truncate_table_statement#
::= 'TRUNCATE' 'TABLE' target_table identity_column_restart_option? |
identity_column_restart_option#
::= ( 'CONTINUE' | 'RESTART' ) 'IDENTITY' |
Referenced by:
|
insert_statement#
::= 'INSERT' 'INTO' insertion_target insert_columns_and_source |
insertion_target#
::= table_name |
Referenced by:
|
insert_columns_and_source#
::= from_subquery
|
Referenced by:
|
from_subquery#
Referenced by:
|
from_constructor#
Referenced by:
|
override_clause#
::= 'OVERRIDING' ( 'USER' | 'SYSTEM' ) 'VALUE' |
Referenced by:
|
from_default#
::= 'DEFAULT' 'VALUES' |
Referenced by:
|
insert_column_list#
::= column_name_list |
Referenced by:
|
merge_statement#
::= 'MERGE' 'INTO' target_table ( 'AS'? identifier )? 'USING' table_reference 'ON' search_condition merge_operation_specification |
merge_operation_specification#
::= merge_when_clause+ |
Referenced by:
|
merge_when_clause#
Referenced by:
|
merge_when_matched_clause#
::= 'WHEN' 'MATCHED' ( 'AND' search_condition )? 'THEN' merge_update_or_delete_specification |
Referenced by:
|
merge_update_or_delete_specification#
| 'DELETE' |
Referenced by:
|
merge_when_not_matched_clause#
::= 'WHEN' 'NOT' 'MATCHED' ( 'AND' search_condition )? 'THEN' merge_insert_specification |
Referenced by:
|
merge_update_specification#
::= 'UPDATE' 'SET' set_clause_list |
Referenced by:
|
merge_insert_specification#
Referenced by:
|
merge_insert_value_list#
::= '(' merge_insert_value_element ( ',' merge_insert_value_element )* ')' |
Referenced by:
|
merge_insert_value_element#
::= value_expression
|
Referenced by:
|
update_statement_positioned#
::= 'UPDATE' target_table ( 'AS'? identifier )? 'SET' set_clause_list 'WHERE' 'CURRENT' 'OF' cursor_name |
Referenced by:
|
update_statement_searched#
set_clause_list#
::= set_clause ( ',' set_clause )* |
set_clause#
| set_target '=' update_source |
Referenced by:
|
set_target#
::= update_target
|
Referenced by:
|
multiple_column_assignment#
::= set_target_list '=' assigned_row |
Referenced by:
|
set_target_list#
::= '(' set_target ( ',' set_target )* ')' |
Referenced by:
|
assigned_row#
Referenced by:
|
update_target#
Referenced by:
|
mutated_set_clause#
::= identifier ( '.' identifier )+ |
Referenced by:
|
mutated_target#
::= identifier
|
Not referenced by any.
|
update_source#
::= value_expression
|
Referenced by:
|
temporary_table_declaration#
::= 'DECLARE' 'LOCAL' 'TEMPORARY' 'TABLE' table_name table_element_list ( 'ON' 'COMMIT' table_commit_action 'ROWS' )? |
Referenced by:
|
call_statement#
::= 'CALL' routine_invocation |
Referenced by:
|
return_statement#
::= 'RETURN' return_value |
Referenced by:
|
return_value#
::= value_expression
| 'NULL' |
Referenced by:
|
start_transaction_statement#
::= 'START' 'TRANSACTION' transaction_characteristics? |
Referenced by:
|
set_transaction_statement#
::= 'SET' 'LOCAL'? 'TRANSACTION' transaction_characteristics? |
Referenced by:
|
transaction_characteristics#
::= transaction_mode ( ',' transaction_mode )* |
Referenced by:
|
transaction_mode#
::= isolation_level
|
transaction_access_mode#
::= 'READ' ( 'ONLY' | 'WRITE' ) |
Referenced by:
|
isolation_level#
::= 'ISOLATION' 'LEVEL' level_of_isolation |
Referenced by:
|
level_of_isolation#
::= 'READ' ( 'UNCOMMITTED' | 'COMMITTED' )
| 'REPEATABLE' 'READ'
| 'SERIALIZABLE' |
Referenced by:
|
diagnostics_size#
::= 'DIAGNOSTICS' 'SIZE' simple_value_specification |
Referenced by:
|
set_constraints_mode_statement#
::= 'SET' 'CONSTRAINTS' constraint_name_list ( 'DEFERRED' | 'IMMEDIATE' ) |
Referenced by:
|
constraint_name_list#
::= 'ALL'
| schema_qualified_name ( ',' schema_qualified_name )* |
Referenced by:
|
savepoint_statement#
::= 'SAVEPOINT' savepoint_specifier |
Referenced by:
|
savepoint_specifier#
::= identifier |
release_savepoint_statement#
::= 'RELEASE' 'SAVEPOINT' savepoint_specifier |
Referenced by:
|
commit_statement#
::= 'COMMIT' 'WORK'? ( 'AND' 'NO'? 'CHAIN' )? |
Referenced by:
|
rollback_statement#
::= 'ROLLBACK' 'WORK'? ( 'AND' 'NO'? 'CHAIN' )? savepoint_clause? |
Referenced by:
|
savepoint_clause#
::= 'TO' 'SAVEPOINT' savepoint_specifier |
Referenced by:
|
connect_statement#
::= 'CONNECT' 'TO' connection_target |
Referenced by:
|
connection_target#
::= simple_value_specification ( 'AS' simple_value_specification )? ( 'USER' simple_value_specification )?
| 'DEFAULT' |
Referenced by:
|
set_connection_statement#
::= 'SET' 'CONNECTION' connection_object |
Referenced by:
|
connection_object#
::= 'DEFAULT'
|
Referenced by:
|
disconnect_statement#
::= 'DISCONNECT' disconnect_object |
Referenced by:
|
disconnect_object#
| 'ALL'
| 'CURRENT' |
Referenced by:
|
set_session_characteristics_statement#
::= 'SET' 'SESSION' 'CHARACTERISTICS' 'AS' session_characteristic_list |
Referenced by:
|
session_characteristic_list#
::= session_characteristic ( ',' session_characteristic )* |
Referenced by:
|
session_characteristic#
Referenced by:
|
session_transaction_characteristics#
::= 'TRANSACTION' transaction_mode ( ',' transaction_mode )* |
Referenced by:
|
set_session_user_identifier_statement#
::= 'SET' 'SESSION' 'AUTHORIZATION' value_specification |
Referenced by:
|
set_role_statement#
::= 'SET' 'ROLE' role_specification |
Referenced by:
|
role_specification#
| 'NONE' |
Referenced by:
|
set_local_time_zone_statement#
::= 'SET' 'TIME' 'ZONE' set_time_zone_value |
Referenced by:
|
set_time_zone_value#
| 'LOCAL' |
Referenced by:
|
set_catalog_statement#
::= 'SET' catalog_name_characteristic |
Referenced by:
|
catalog_name_characteristic#
::= 'CATALOG' value_specification |
Referenced by:
|
set_schema_statement#
::= 'SET' schema_name_characteristic |
Referenced by:
|
schema_name_characteristic#
::= 'SCHEMA' value_specification |
Referenced by:
|
set_names_statement#
::= 'SET' character_set_name_characteristic |
Referenced by:
|
character_set_name_characteristic#
::= 'NAMES' value_specification |
Referenced by:
|
set_path_statement#
::= 'SET' SQL_path_characteristic |
Referenced by:
|
SQL_path_characteristic#
::= 'PATH' value_specification |
Referenced by:
|
set_transform_group_statement#
::= 'SET' transform_group_characteristic |
Referenced by:
|
transform_group_characteristic#
::= ( 'DEFAULT' 'TRANSFORM' 'GROUP' | 'TRANSFORM' 'GROUP' 'FOR' 'TYPE' path_resolved_user_defined_type_name ) value_specification |
Referenced by:
|
set_session_collation_statement#
::= 'SET' ( 'COLLATION' collation_specification | 'NO' 'COLLATION' ) ( 'FOR' character_set_specification_list )? |
Referenced by:
|
collation_specification#
Referenced by:
|
allocate_descriptor_statement#
::= 'ALLOCATE' 'SQL'? 'DESCRIPTOR' descriptor_name ( 'WITH' 'MAX' simple_value_specification )? |
Referenced by:
|
deallocate_descriptor_statement#
::= 'DEALLOCATE' 'SQL'? 'DESCRIPTOR' descriptor_name |
Referenced by:
|
get_descriptor_statement#
::= 'GET' 'SQL'? 'DESCRIPTOR' descriptor_name get_descriptor_information |
Referenced by:
|
get_descriptor_information#
::= get_header_information ( ',' get_header_information )*
|
Referenced by:
|
get_header_information#
Referenced by:
|
header_item_name#
::= 'COUNT'
| 'KEY_TYPE'
| 'DYNAMIC_FUNCTION'
| 'DYNAMIC_FUNCTION_CODE'
| 'TOP_LEVEL_COUNT' |
Referenced by:
|
get_item_information#
Referenced by:
|
simple_target_specification_1#
Referenced by:
|
simple_target_specification_2#
Referenced by:
|
descriptor_item_name#
::= '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#
::= 'SET' 'SQL'? 'DESCRIPTOR' descriptor_name set_descriptor_information |
Referenced by:
|
set_descriptor_information#
::= set_header_information ( ',' set_header_information )*
|
Referenced by:
|
set_header_information#
Referenced by:
|
set_item_information#
Referenced by:
|
prepare_statement#
Referenced by:
|
attributes_specification#
::= 'ATTRIBUTES' simple_value_specification |
Referenced by:
|
preparable_statement#
Not referenced by any.
|
preparable_SQL_data_statement#
Referenced by:
|
preparable_SQL_schema_statement#
Referenced by:
|
preparable_SQL_transaction_statement#
Referenced by:
|
preparable_SQL_control_statement#
Referenced by:
|
preparable_SQL_session_statement#
Referenced by:
|
dynamic_select_statement#
Referenced by:
|
preparable_implementation_defined_statement#
Referenced by:
|
cursor_attributes#
::= cursor_attribute+ |
Not referenced by any.
|
cursor_attribute#
Referenced by:
|
deallocate_prepared_statement#
::= 'DEALLOCATE' 'PREPARE' SQL_identifier |
Referenced by:
|
describe_statement#
Referenced by:
|
describe_input_statement#
Referenced by:
|
describe_output_statement#
Referenced by:
|
nesting_option#
::= ( 'WITH' | 'WITHOUT' ) 'NESTING' |
Referenced by:
|
using_descriptor#
::= 'USING' 'SQL'? 'DESCRIPTOR' descriptor_name |
described_object#
::= SQL_identifier
| 'CURSOR' extended_cursor_name 'STRUCTURE' |
Referenced by:
|
input_using_clause#
::= using_arguments
|
Referenced by:
|
using_arguments#
::= 'USING' using_argument ( ',' using_argument )* |
Referenced by:
|
using_argument#
Referenced by:
|
using_input_descriptor#
::= using_descriptor |
Referenced by:
|
output_using_clause#
::= into_arguments
|
Referenced by:
|
into_arguments#
::= 'INTO' into_argument ( ',' into_argument )* |
Referenced by:
|
into_argument#
Referenced by:
|
into_descriptor#
::= 'INTO' 'SQL'? 'DESCRIPTOR' descriptor_name |
Referenced by:
|
execute_statement#
Referenced by:
|
result_using_clause#
Referenced by:
|
parameter_using_clause#
Referenced by:
|
execute_immediate_statement#
::= 'EXECUTE' 'IMMEDIATE' simple_value_specification |
Referenced by:
|
dynamic_declare_cursor#
Referenced by:
|
allocate_cursor_statement#
::= 'ALLOCATE' extended_cursor_name cursor_intent |
Referenced by:
|
cursor_intent#
::= statement_cursor
|
Referenced by:
|
statement_cursor#
::= cursor_properties 'FOR' extended_identifier |
Referenced by:
|
result_set_cursor#
::= 'CURSOR'? 'FOR' 'PROCEDURE' specific_routine_designator |
Referenced by:
|
dynamic_open_statement#
::= 'OPEN' dynamic_cursor_name input_using_clause? |
Referenced by:
|
dynamic_fetch_statement#
Referenced by:
|
dynamic_single_row_select_statement#
Referenced by:
|
dynamic_close_statement#
::= 'CLOSE' dynamic_cursor_name |
Referenced by:
|
dynamic_delete_statement_positioned#
::= 'DELETE' 'FROM' target_table 'WHERE' 'CURRENT' 'OF' dynamic_cursor_name |
Referenced by:
|
dynamic_update_statement_positioned#
Referenced by:
|
preparable_dynamic_delete_statement_positioned#
::= 'DELETE' ( 'FROM' target_table )? 'WHERE' 'CURRENT' 'OF' preparable_dynamic_cursor_name |
Referenced by:
|
preparable_dynamic_cursor_name#
::= scope_option? cursor_name |
preparable_dynamic_update_statement_positioned#
::= 'UPDATE' target_table? 'SET' set_clause_list 'WHERE' 'CURRENT' 'OF' preparable_dynamic_cursor_name |
Referenced by:
|
direct_SQL_statement#
::= directly_executable_statement ';' |
Referenced by:
|
directly_executable_statement#
Referenced by:
|
direct_SQL_data_statement#
Referenced by:
|
direct_implementation_defined_statement#
Referenced by:
|
direct_select_statement_multiple_rows#
Referenced by:
|
get_diagnostics_statement#
::= 'GET' 'DIAGNOSTICS' SQL_diagnostics_information |
Referenced by:
|
SQL_diagnostics_information#
Referenced by:
|
statement_information#
::= statement_information_item ( ',' statement_information_item )* |
Referenced by:
|
statement_information_item#
Referenced by:
|
statement_information_item_name#
::= '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#
::= 'CONDITION' simple_value_specification condition_information_item ( ',' condition_information_item )* |
Referenced by:
|
condition_information_item#
Referenced by:
|
condition_information_item_name#
::= '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#
::= all_info_target '=' 'ALL' all_qualifier? |
Referenced by:
|
all_info_target#
Referenced by:
|
all_qualifier#
::= 'STATEMENT'
| 'CONDITION' simple_value_specification? |
Referenced by:
|
use_statement#
::= 'USE' identifier_chain |
Referenced by:
|
lambda#
Referenced by:
|
lambda_body#
::= '->' value_expression |
Referenced by:
|
lambda_params#
| '(' ( actual_identifier ( ',' actual_identifier )* )? ')' |
Referenced by:
|
if_not_exists#
::= 'IF' 'NOT' 'EXISTS' |
Referenced by:
|
identifier_suffix_chain#
::= ( ( '@' | ':' ) actual_identifier? )+ |
Referenced by:
|
limit_clause#
::= 'LIMIT' ( unsigned_integer | 'ALL' ) |
Referenced by:
|
presto_generic_type#
Referenced by:
|
presto_array_type#
Referenced by:
|
presto_map_type#
Referenced by:
|
grouping_expression#
::= value_expression |
Referenced by:
|
count#
Referenced by:
|
table_description#
::= 'COMMENT' character_string_literal |
Referenced by:
|
routine_description#
::= 'COMMENT' character_string_literal |
Referenced by:
|
column_description#
::= 'COMMENT' character_string_literal |
Referenced by:
|
presto_aggregation_function#
::= 'NUMERIC_HISTOGRAM'
| 'HISTOGRAM'
| 'APPROEX_PERCENTILE'
| 'MAP_AGG'
| 'SET_AGG'
| 'MAP_UNION' |
Referenced by:
|
presto_aggregations#
::= presto_aggregation_function '(' ( set_quantifier? value_expression ( ',' value_expression )* )? ')' |
Referenced by:
|
try_cast#
Referenced by:
|
table_attributes#
Referenced by:
|
or_replace#
::= 'OR' 'REPLACE' |
Referenced by:
|
udaf_filter#
::= filter_clause |
Referenced by:
|
extra_args_to_agg#
::= ( ',' value_expression )+ |
Referenced by:
|
identifier_starting_with_underscore#
::= '_'+ regular_identifier? |
Not referenced by any.
|
generic_unicode#
::= "U&'" ( [^'] | "''" )* "'" |
Not referenced by any.
|
regular_identifier#
::= identifier_body |
identifier_body#
Referenced by:
|
identifier_part#
::= identifier_start
|
Referenced by:
|
identifier_start#
::= [a-z] |
Referenced by:
|
identifier_extend#
::= [0-9_#xB7] |
Referenced by:
|
large_object_length_token#
::= digit+ multiplier |
Referenced by:
|
multiplier#
::= [KMGTP] |
Referenced by:
|
delimited_identifier#
::= '"' delimited_identifier_body? '"' |
Referenced by:
|
delimited_identifier_body#
Referenced by:
|
delimited_identifier_part#
| '""' |
Referenced by:
|
Unicode_delimited_identifier#
::= 'U' '&' '"' Unicode_delimiter_body '"' Unicode_escape_specifier? |
Referenced by:
|
Unicode_escape_specifier#
::= 'UESCAPE' "'" Unicode_escape_character "'" |
Referenced by:
|
Unicode_delimiter_body#
Referenced by:
|
Unicode_identifier_part#
Referenced by:
|
Unicode_escape_value#
Referenced by:
|
Unicode_4_digit_escape_value#
Referenced by:
|
Unicode_6_digit_escape_value#
Referenced by:
|
Unicode_character_escape_value#
Referenced by:
|
Unicode_escape_character#
::= [^a-z0-9+'" #xA#x9] |
nondoublequote_character#
::= [^"] |
Referenced by:
|
white_space#
::= newline
| [ #x9] |
Referenced by:
|
newline#
newline ::= [#xA#xD]+ |
Referenced by:
|
comment#
Not referenced by any.
|
simple_comment#
::= '--' comment_character* newline? |
Referenced by:
|
skip_separator#
::= white_space+ |
Not referenced by any.
|
separator#
::= white_space+ |
digit#
digit ::= [0-9] |
character_representation#
| "''" |
nonquote_character#
::= [^'] |
Referenced by:
|
quoted_string#
::= "'" character_representation* "'" |
Referenced by:
|
national_character_string_literal#
Referenced by:
|
unicode_literal#
::= 'U' '&' "'" Unicode_representation* "'" ( separator "'" Unicode_representation* "'" )* Unicode_escape_specifier |
Referenced by:
|
Unicode_representation#
Referenced by:
|
binary_string_literal#
Referenced by:
|
hexit#
hexit ::= [a-f0-9] |
unsigned_integer#
float_literal#
::= unsigned_integer '.' unsigned_integer?
| '.' unsigned_integer |
Referenced by:
|
approximate_numeric_literal#
Referenced by:
|
mantissa#
Referenced by:
|
exponent#
Referenced by:
|
signed_integer#
::= [+#x2D]? unsigned_integer |
Referenced by:
|
SQL_language_identifier#
Referenced by:
|
simple_Latin_letter#
::= [a-z] |
Referenced by:
|
SQL_language_identifier_start#
Referenced by:
|
SQL_language_identifier_part#
| digit
| '_' |
Referenced by:
|
illegal_input_char#
::= . |
Not referenced by any.
|
EOF#
EOF ::= $ |
Referenced by:
|
comment_character#