SQL Syntax 5.4-SNAPSHOT¶
The EBNF and Railroad Diagrams for 0.2-SNAPSHOT.
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¶