create_outline_stmt | |
relation_name | |
explainable_stmt | |
hint_option | |
opt_hint_list | |
select_stmt | |
delete_stmt | |
insert_with_opt_hint | |
single_table_insert | |
merge_stmt | |
update_with_opt_hint | |
dml_table_clause | |
update_asgn_list | |
projection | |
into_clause | |
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 | |
subquery | |
bit_expr | |
delete_with_opt_hint | |
tbl_name | |
relation_factor | |
name_list | |
column_definition_ref | |
values_clause | |
source_relation_factor | |
expr_or_default | |
column_label | |
into_var | |
relation_factor_in_leading_hint_list | |
select_no_parens | |
select_with_parens | |
with_select | |
unary_expr | |
sample_percent | |
column_name | |
insert_vals_list | |
obj_access_ref_normal | |
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 | |