全部产品

MERGE

OracleSQLParser.g4

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

relation_factor

normal_relation_factor.relation_name

relation_name

QUESTIONMARKunreserved_keyword

source_relation_factor

relation_factorselect_with_parens

update_asgn_list

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

column_definition_ref

column_namerelation_name.column_namerelation_name.relation_name.column_name

expr_or_default

bit_exprDEFAULT

normal_relation_factor

relation_namerelation_name.relation_name

select_with_parens

(select_no_parens)(select_with_parens)(with_select)

subquery

select_no_parensselect_with_parenswith_select

column_name

QUESTIONMARKunreserved_keyword

bit_expr

bit_expr+bit_exprbit_expr-bit_exprbit_exprbit_exprbit_expr/bit_exprbit_exprCNNOPbit_exprunary_expr

select_no_parens

select_clauseselect_clause_set

with_select

with_clauseselect_no_parenswith_clauseselect_with_parens

unary_expr

+simple_expr-simple_exprsimple_expr

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

select_with_opt_hint

SELECTSELECT_HINT_BEGINhint_optionopt_hint_list,hint_optionHINT_END

query_expression_option_list

query_expression_optionquery_expression_optionquery_expression_option

projection

bit_exprbit_exprAScolumn_label

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