全部产品

ALTER OUTLINE

更新时间:2020-04-01 11:49:37

OracleSQLParser.g4

alter_outline_stmt

ALTEROUTLINErelation_nameADDexplainable_stmtTOexplainable_stmt

relation_name

QUESTIONMARKunreserved_keyword

explainable_stmt

select_stmtdelete_stmtinsert_with_opt_hintsingle_table_insertmerge_stmtupdate_with_opt_hintdml_table_clauseSETupdate_asgn_listWHEREHINT_VALUEexprRETURNINGprojection,projectioninto_clause

select_stmt

subquerysubqueryFORUPDATEWAITDECIMAL_VALWAITINTNUMNOWAITsubqueryORDERSIBLINGSBYbit_exprASCDESC,bit_exprASCDESCsubqueryORDERSIBLINGSBYbit_exprASCDESC,bit_exprASCDESCFORUPDATEWAITDECIMAL_VALWAITINTNUMNOWAITsubqueryFORUPDATEWAITDECIMAL_VALWAITINTNUMNOWAITORDERSIBLINGSBYbit_exprASCDESC,bit_exprASCDESC

delete_stmt

delete_with_opt_hintFROMtbl_nameWHEREHINT_VALUEexprRETURNINGprojection,projectioninto_clausedelete_with_opt_hinttbl_nameWHEREHINT_VALUEexprRETURNINGprojection,projectioninto_clause

insert_with_opt_hint

INSERTINSERT_HINT_BEGINhint_optionopt_hint_list,hint_optionHINT_END

single_table_insert

INTOrelation_factorPARTITION(name_list)relation_nameNOLOGGING(column_definition_ref,column_definition_ref)values_clauseRETURNINGprojection,projectioninto_clauseINTOrelation_factorPARTITION(name_list)relation_nameNOLOGGING()values_clauseRETURNINGprojection,projectioninto_clauseINTOrelation_factorPARTITION(name_list)relation_nameNOLOGGINGvalues_clauseRETURNINGprojection,projectioninto_clause

merge_stmt

MERGEINTOrelation_factorrelation_nameUSINGsource_relation_factorrelation_nameON(expr)WHENMATCHEDTHENUPDATESETupdate_asgn_listWHEREHINT_VALUEexprDELETEWHEREexprWHENNOTMATCHEDTHENINSERT(column_definition_ref,column_definition_ref)VALUES(expr_or_default,expr_or_default)WHEREHINT_VALUEexprMERGEINTOrelation_factorrelation_nameUSINGsource_relation_factorrelation_nameON(expr)WHENNOTMATCHEDTHENINSERT(column_definition_ref,column_definition_ref)VALUES(expr_or_default,expr_or_default)WHEREHINT_VALUEexprMERGEINTOrelation_factorrelation_nameUSINGsource_relation_factorrelation_nameON(expr)WHENMATCHEDTHENUPDATESETupdate_asgn_listWHEREHINT_VALUEexprDELETEWHEREexpr

update_with_opt_hint

UPDATEUPDATE_HINT_BEGINhint_optionopt_hint_list,hint_optionHINT_END

dml_table_clause

relation_factorPARTITION(name_list)relation_nameONLY(relation_factorPARTITION(name_list))relation_name

update_asgn_list

column_definition_refCOMP_EQexpr_or_default,column_definition_refCOMP_EQexpr_or_default(column_definition_ref,column_definition_ref)COMP_EQ(subquery)

projection

bit_exprbit_exprAScolumn_label

into_clause

INTOinto_var,into_varBULKCOLLECTINTOinto_var,into_var

subquery

select_no_parensselect_with_parenswith_select

bit_expr

bit_expr+bit_exprbit_expr-bit_exprbit_expr bit_exprbit_expr/bit_exprbit_exprCNNOPbit_exprunary_expr

delete_with_opt_hint

DELETEDELETE_HINT_BEGINhint_optionopt_hint_list,hint_optionHINT_END

tbl_name

relation_factorPARTITION(name_list)SAMPLEBLOCKALLBASEINCR(sample_percent)SEED(INTNUM)relation_factorPARTITION(name_list)SAMPLEBLOCKALLBASEINCR(sample_percent)SEED(INTNUM)relation_namerelation_factorPARTITION(name_list)SAMPLEBLOCKALLBASEINCR(sample_percent)relation_namerelation_factorPARTITION(name_list)relation_name

hint_option

NO_REWRITEREAD_CONSISTENCY(consistency_level)INDEX_HINT(qb_name_optionnormal_relation_factorqb_name_optionQUESTIONMARK)QUERY_TIMEOUT(INTNUM)FROZEN_VERSION(INTNUM)TOPK(INTNUMINTNUM)HOTSPOTLOG_LEVEL(QUESTIONMARK)LOG_LEVEL(STRING_VALUE)LEADING_HINT(qb_name_optionrelation_factor_in_leading_hint_list_entry)LEADING_HINT(qb_name_optionnormal_relation_factorqb_name_option,normal_relation_factorqb_name_option)ORDEREDFULL_HINT(qb_name_optionnormal_relation_factorqb_name_option)USE_PLAN_CACHE(use_plan_cache_type)USE_MERGE(qb_name_optionrelation_factor_in_use_join_hint_list)NO_USE_MERGE(qb_name_optionrelation_factor_in_use_join_hint_list)USE_HASH(qb_name_optionrelation_factor_in_use_join_hint_list)NO_USE_HASH(qb_name_optionrelation_factor_in_use_join_hint_list)USE_NL(qb_name_optionrelation_factor_in_use_join_hint_list)NO_USE_NL(qb_name_optionrelation_factor_in_use_join_hint_list)USE_BNL(qb_name_optionrelation_factor_in_use_join_hint_list)NO_USE_BNL(qb_name_optionrelation_factor_in_use_join_hint_list)USE_NL_MATERIALIZATION(qb_name_optionrelation_factor_in_use_join_hint_list)NO_USE_NL_MATERIALIZATION(qb_name_optionrelation_factor_in_use_join_hint_list)USE_HASH_AGGREGATIONNO_USE_HASH_AGGREGATIONMERGE_HINT(qb_name_option)NO_MERGE_HINT(qb_name_option)NO_EXPAND(qb_name_option)USE_CONCAT(qb_name_option)UNNEST(qb_name_option)NO_UNNEST(qb_name_option)PLACE_GROUP_BY(qb_name_option)NO_PLACE_GROUP_BY(qb_name_option)USE_JITNO_USE_JITUSE_LATE_MATERIALIZATIONNO_USE_LATE_MATERIALIZATIONTRACE_LOGSTAT(tracing_num_list)TRACING(tracing_num_list)USE_PXNO_USE_PXPX_JOIN_FILTERQB_NAME(QUESTIONMARK)MAX_CONCURRENT(INTNUM)PARALLEL(INTNUM)PQ_DISTRIBUTE(qb_name_optionrelation_factor_in_pq_hint,distribute_method,distribute_method)QUESTIONMARKEND_PPARSER_SYNTAX_ERROR

opt_hint_list

hint_optionopt_hint_list,hint_optionempty

relation_factor

normal_relation_factor.relation_name

name_list

QUESTIONMARKname_listQUESTIONMARKname_list,QUESTIONMARK

column_definition_ref

column_namerelation_name.column_namerelation_name.relation_name.column_name

values_clause

VALUESinsert_vals_listsubqueryORDERSIBLINGSBYbit_exprASCDESC,bit_exprASCDESC

source_relation_factor

relation_factorselect_with_parens

expr_or_default

bit_exprDEFAULT

column_label

QUESTIONMARKunreserved_keyword

into_var

USER_VARIABLEobj_access_ref_normal

select_no_parens

select_clauseselect_clause_set

select_with_parens

(select_no_parens)(select_with_parens)(with_select)

with_select

with_clauseselect_no_parenswith_clauseselect_with_parens

unary_expr

+simple_expr-simple_exprsimple_expr

sample_percent

INTNUMDECIMAL_VAL

consistency_level

WEAKSTRONGFROZEN

qb_name_option

@QUESTIONMARKempty

normal_relation_factor

relation_namerelation_name.relation_name

relation_factor_in_leading_hint_list_entry

relation_factor_in_leading_hint_listnormal_relation_factorqb_name_option,normal_relation_factorqb_name_option,relation_factor_in_leading_hint_list

use_plan_cache_type

NONEDEFAULT

relation_factor_in_use_join_hint_list

normal_relation_factorqb_name_option(normal_relation_factorqb_name_option,normal_relation_factorqb_name_option)relation_factor_in_use_join_hint_list,normal_relation_factorqb_name_optionrelation_factor_in_use_join_hint_list,(normal_relation_factorqb_name_option,normal_relation_factorqb_name_option)

tracing_num_list

INTNUM,tracing_num_listINTNUM

relation_factor_in_pq_hint

normal_relation_factorqb_name_option(normal_relation_factorqb_name_option,normal_relation_factorqb_name_option)

distribute_method

NONEPARTITIONRANDOMRANDOM_LOCALHASHBROADCAST

empty

ε

column_name

QUESTIONMARKunreserved_keyword

insert_vals_list

(expr_or_default,expr_or_default)insert_vals_list,(expr_or_default,expr_or_default)

obj_access_ref_normal

var_name.obj_access_ref_normalaccess_func_expr.obj_access_ref_normaltable_element_access_list

select_clause

select_with_opt_hintquery_expression_option_listprojection,projectioninto_optFROMDUALWHEREHINT_VALUEexprno_table_select_with_hierarchical_queryselect_with_opt_hintquery_expression_option_listprojection,projectioninto_optFROMtable_reference,table_referenceWHEREHINT_VALUEexprGROUPBYbit_exprASCDESC,bit_exprASCDESCGROUPBYROLLUP(bit_exprASCDESC,bit_exprASCDESC)HAVINGexprselect_with_hierarchical_query

select_clause_set

select_clause_setset_typeselect_clause_set_rightselect_clause_set_rightset_typeselect_clause_set_right

with_clause

WITHcommon_table_expr,common_table_exprWITHRECURSIVEcommon_table_expr

simple_expr

simple_exprCOLLATEcollation_nameROWNUMobj_access_refCOLUMN_OUTER_JOIN_SYMBOLexpr_constselect_with_parens(bit_expr)(bit_expr,bit_expr,bit_expr)MATCH(column_definition_ref,column_definition_ref)AGAINST(STRING_VALUEINNATURALLANGUAGEMODEINBOOLEANMODE)case_exprobj_access_refsql_functioncursor_attribute_exprwindow_functionUSER_VARIABLEPRIORunary_exprCONNECT_BY_ROOTunary_exprLEVELCONNECT_BY_ISLEAFCONNECT_BY_ISCYCLE

relation_factor_in_leading_hint_list

(normal_relation_factorqb_name_option,normal_relation_factorqb_name_option)relation_factor_in_leading_hint_list,(normal_relation_factorqb_name_option,normal_relation_factorqb_name_option)relation_factor_in_leading_hint_list,normal_relation_factorqb_name_option(relation_factor_in_leading_hint_list)(normal_relation_factorqb_name_option,normal_relation_factorqb_name_option,relation_factor_in_leading_hint_list)relation_factor_in_leading_hint_list,(normal_relation_factorqb_name_option,normal_relation_factorqb_name_option,relation_factor_in_leading_hint_list)

var_name

QUESTIONMARKunreserved_keyword_normal

access_func_expr

COUNT(ALL)COUNT(ALLbit_expr)COUNT(DISTINCTbit_expr)COUNT(UNIQUEbit_expr)function_name(func_param,func_param)

table_element_access_list

(table_index)table_element_access_list(table_index)

select_with_opt_hint

SELECTSELECT_HINT_BEGINhint_optionopt_hint_list,hint_optionHINT_END

query_expression_option_list

query_expression_optionquery_expression_optionquery_expression_option

into_opt

INTOOUTFILESTRING_VALUEcharset_keycharset_namefield_optline_optINTODUMPFILESTRING_VALUEinto_clauseempty

no_table_select_with_hierarchical_query

select_with_opt_hintquery_expression_option_listprojection,projectioninto_optFROMDUALWHEREHINT_VALUEexprSTARTWITHexprCONNECTBYNOCYCLEexprselect_with_opt_hintquery_expression_option_listprojection,projectioninto_optFROMDUALWHEREHINT_VALUEexprCONNECTBYNOCYCLEexprSTARTWITHexpr

table_reference

table_factortable_factorASOFTIMESTAMPsimple_exprtable_factorASOFSCNsimple_exprjoined_table

select_with_hierarchical_query

select_with_opt_hintquery_expression_option_listprojection,projectioninto_optFROMtable_reference,table_referenceWHEREHINT_VALUEexprSTARTWITHexprCONNECTBYNOCYCLEexprGROUPBYbit_exprASCDESC,bit_exprASCDESCGROUPBYROLLUP(bit_exprASCDESC,bit_exprASCDESC)HAVINGexprselect_with_opt_hintquery_expression_option_listprojection,projectioninto_optFROMtable_reference,table_referenceWHEREHINT_VALUEexprCONNECTBYNOCYCLEexprSTARTWITHexprGROUPBYbit_exprASCDESC,bit_exprASCDESCGROUPBYROLLUP(bit_exprASCDESC,bit_exprASCDESC)HAVINGexpr

set_type

UNIONALLset_type_other

select_clause_set_right

select_with_opt_hintquery_expression_option_listprojection,projectioninto_optFROMDUALWHEREHINT_VALUEexprselect_with_opt_hintquery_expression_option_listprojection,projectioninto_optFROMtable_reference,table_referenceWHEREHINT_VALUEexprGROUPBYbit_exprASCDESC,bit_exprASCDESCGROUPBYROLLUP(bit_exprASCDESC,bit_exprASCDESC)HAVINGexprselect_with_parens

common_table_expr

relation_name(column_name,column_name)ASselect_with_parensSEARCHDEPTHFIRSTBYbit_exprASCDESC,bit_exprASCDESCSETvar_nameSEARCHBREADTHFIRSTBYbit_exprASCDESC,bit_exprASCDESCSETvar_nameCYCLEcolumn_name,column_nameSETvar_nameTOSTRING_VALUEDEFAULTSTRING_VALUErelation_name(column_name,column_name)AS(subqueryORDERSIBLINGSBYbit_exprASCDESC,bit_exprASCDESC)SEARCHDEPTHFIRSTBYbit_exprASCDESC,bit_exprASCDESCSETvar_nameSEARCHBREADTHFIRSTBYbit_exprASCDESC,bit_exprASCDESCSETvar_nameCYCLEcolumn_name,column_nameSETvar_nameTOSTRING_VALUEDEFAULTSTRING_VALUE

collation_name

QUESTIONMARKSTRING_VALUE

obj_access_ref

column_name.obj_access_ref. access_func_expr.obj_access_reftable_element_access_list

expr_const

literalSYSTEM_VARIABLEQUESTIONMARKglobal_or_session_alias.column_name

case_expr

CASEbit_exprWHENbit_exprTHENbit_exprcase_defaultENDCASEWHENexprTHENbit_exprcase_defaultEND

sql_function

single_row_functionaggregate_functionspecial_func_expr

cursor_attribute_expr

column_name%common_cursor_attributeimplicit_cursor_attribute

window_function

COUNT(ALL)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

QUESTIONMARKDUMPCHARSETCOLLATIONKEY_VERSIONDATABASECOALESCEREPEATROW_COUNTREVERSERIGHTCURRENT_USERSYSTEM_USERSESSION_USERREPLACEEGKMPT

func_param

var_namePARAM_ASSIGN_OPERATORbit_exprbit_expr

table_index

INTNUMvar_name

query_expression_option

ALLDISTINCTUNIQUESQL_CALC_FOUND_ROWS

charset_key

CHARSETCHARACTERSET

charset_name

QUESTIONMARKSTRING_VALUEBINARY

field_opt

columns_or_fieldsfield_termempty

line_opt

LINESline_termempty

table_factor

tbl_nametable_subquery(subqueryORDERSIBLINGSBYbit_exprASCDESC,bit_exprASCDESC)select_with_parens(table_reference)TABLE(simple_expr)relation_name

joined_table

table_factorouter_join_typeJOINtable_factorjoin_conditiontable_factorASOFTIMESTAMPsimple_exprouter_join_typeJOINtable_factorjoin_conditiontable_factorASOFSCNsimple_exprouter_join_typeJOINtable_factorjoin_condition