update_stmt | |
update_with_opt_hint | |
dml_table_clause | |
update_asgn_list | |
projection | |
into_clause | |
hint_option | |
opt_hint_list | |
relation_factor | |
name_list | |
relation_name | |
column_definition_ref | |
expr_or_default | |
subquery | |
bit_expr | |
column_label | |
into_var | |
consistency_level | |
qb_name_option | |
normal_relation_factor | |
relation_factor_in_leading_hint_list_entry | |
use_plan_cache_type | |
relation_factor_in_use_join_hint_list | |
tracing_num_list | |
relation_factor_in_pq_hint | |
distribute_method | |
empty | |
column_name | |
select_no_parens | |
select_with_parens | |
with_select | |
unary_expr | |
obj_access_ref_normal | |
relation_factor_in_leading_hint_list | |
select_clause | |
select_clause_set | |
with_clause | |
simple_expr | |
var_name | |
access_func_expr | )COUNT(ALLbit_expr)COUNT(DISTINCTbit_expr)COUNT(UNIQUEbit_expr)function_name(func_param,func_param) |
table_element_access_list | |
select_with_opt_hint | |
query_expression_option_list | |
into_opt | |
no_table_select_with_hierarchical_query | |
table_reference | |
select_with_hierarchical_query | |
set_type | |
select_clause_set_right | |
common_table_expr | |
collation_name | |
obj_access_ref | |
expr_const | |
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) |
function_name | |
func_param | |
table_index | |
query_expression_option | |
charset_key | |
charset_name | |
field_opt | |
line_opt | |
table_factor | |
joined_table | |
set_type_other | |
literal | |
global_or_session_alias | |
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 | |
columns_or_fields | |
field_term | |
line_term | |
tbl_name | |
table_subquery | |
outer_join_type | |
join_condition | |
natural_join_type | |
interval_literal | |
character_function | |
|
conversion_function | |
signed_literal | |
environment_id_function | |
cur_timestamp_func | |
cursor_attribute_bulk_exceptions | |
win_rows_or_range | |
win_bounding | |
sample_percent | |
interval_literal_short | |
date_unit | |
substr_params | |
parameterized_trim | |