createindex_stmt | |
normal_relation_factor | |
index_using_algorithm | |
relation_factor | |
bit_expr | bit_exprbit_expr/bit_exprbit_exprCNNOPbit_exprunary_expr |
index_option | |
opt_partition_option | |
relation_name | |
unary_expr | |
column_name | |
visibility_option | |
partition_option_inner | |
column_partition_option | |
simple_expr | |
subpartition_option | |
compress_option | |
range_partition_element | |
list_partition_element | |
vertical_column_name | |
collation_name | |
obj_access_ref | |
expr_const | |
select_with_parens | |
column_definition_ref | |
case_expr | |
sql_function | |
cursor_attribute_expr | |
window_function | )OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)COUNT(ALLbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)COUNT(DISTINCTbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)APPROX_COUNT_DISTINCT(bit_expr,bit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)APPROX_COUNT_DISTINCT_SYNOPSIS(bit_expr,bit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)APPROX_COUNT_DISTINCT_SYNOPSIS_MERGE(bit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)SUM(ALLDISTINCTUNIQUEbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)MAX(ALLDISTINCTUNIQUEbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)MIN(ALLDISTINCTUNIQUEbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)AVG(ALLDISTINCTUNIQUEbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)LISTAGG(ALLbit_expr,bit_exprSEPARATORSTRING_VALUE)WITHINGROUP(ORDERSIBLINGSBYbit_exprASCDESC,bit_exprASCDESC)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)RANK()OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)DENSE_RANK()OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)PERCENT_RANK()OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)ROW_NUMBER()OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)NTILE(bit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)CUME_DIST()OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)FIRST_VALUEwin_fun_first_last_paramsOVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)LAST_VALUEwin_fun_first_last_paramsOVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)LEADwin_fun_lead_lag_paramsOVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)LAGwin_fun_lead_lag_paramsOVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)NTH_VALUE(bit_expr,bit_expr)FROMfirst_or_lastrespect_or_ignoreNULLSOVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)RATIO_TO_REPORT(ALLDISTINCTUNIQUEbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window) |
range_partition_expr | |
physical_attributes_option | |
list_partition_expr | |
physical_attributes_option_list | |
empty | |
access_func_expr | |
table_element_access_list | |
literal | |
global_or_session_alias | |
select_no_parens | |
with_select | |
case_default | |
single_row_function | |
aggregate_function | |
special_func_expr | |
common_cursor_attribute | |
implicit_cursor_attribute | |
sort_key | |
win_window | |
win_fun_first_last_params | |
win_fun_lead_lag_params | |
first_or_last | |
respect_or_ignore | |
range_expr | |
storage_option | |
function_name | |
func_param | |
table_index | |
interval_literal | |
select_clause | |
select_clause_set | |
with_clause | |
character_function | |
|
conversion_function | |
signed_literal | |
environment_id_function | |
cur_timestamp_func | |
charset_name | |
cursor_attribute_bulk_exceptions | |
win_rows_or_range | |
win_bounding | |
unit_of_size | |
int_or_unlimited | |
var_name | |
interval_literal_short | |
date_unit | |
select_with_opt_hint | |
query_expression_option_list | |
projection | |
into_opt | |
no_table_select_with_hierarchical_query | |
table_reference | |
select_with_hierarchical_query | |
set_type | |
select_clause_set_right | |
common_table_expr | |
substr_params | |
parameterized_trim | |
|
cast_data_type | |
number_literal | |
win_preceding_or_following | |
hint_option | |
opt_hint_list | |
query_expression_option | |
column_label | |
charset_key | |
field_opt | |
line_opt | |
into_clause | |
table_factor | |
joined_table | |