全部产品
云市场

ALTER SYSTEM

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

OracleSQLParser.g4

alter_system_stmt

ALTERSYSTEMBOOTSTRAPCLUSTERpartition_roleserver_info,server_infoUSERuserPASSWORDpasswordALTERSYSTEMFLUSHcache_typeCACHETENANTCOMP_EQrelation_name_or_string,relation_name_or_stringGLOBALALTERSYSTEMFLUSHKVCACHETENANTCOMP_EQrelation_name_or_stringCACHECOMP_EQrelation_name_or_stringALTERSYSTEMFLUSHILOGCACHEFILE_IDCOMP_EQINTNUMALTERSYSTEMALTERPLANBASELINETENANTCOMP_EQrelation_name_or_stringSQL_IDCOMP_EQSTRING_VALUEBASELINE_IDCOMP_EQINTNUMSETcolumn_nameCOMP_EQliteralALTERSYSTEMLOADPLANBASELINEFROMPLANCACHETENANTCOMP_EQrelation_name_or_string,relation_name_or_stringSQL_IDCOMP_EQSTRING_VALUEALTERSYSTEMSWITCHREPLICApartition_rolepartition_id_or_server_or_zoneALTERSYSTEMSWITCHROOTSERVICEpartition_roleserver_or_zoneALTERSYSTEMalter_or_change_or_modifyREPLICAPARTITION_IDCOMP_EQSTRING_VALUESERVERCOMP_EQSTRING_VALUEalter_or_change_or_modifychange_actionsFORCEALTERSYSTEMDROPREPLICAPARTITION_IDCOMP_EQSTRING_VALUESERVERCOMP_EQSTRING_VALUECREATE_TIMESTAMPCOMP_EQINTNUMZONECOMP_EQrelation_name_or_stringFORCEALTERSYSTEMmigrate_actionREPLICAPARTITION_IDCOMP_EQSTRING_VALUESOURCECOMP_EQSTRING_VALUEDESTINATIONCOMP_EQSTRING_VALUEFORCEALTERSYSTEMREPORTREPLICAserver_or_zoneALTERSYSTEMRECYCLEREPLICAserver_or_zoneALTERSYSTEMSTARTMERGEZONECOMP_EQrelation_name_or_stringALTERSYSTEMsuspend_or_resumeMERGEZONECOMP_EQrelation_name_or_stringALTERSYSTEMCLEARMERGEERROR_PALTERSYSTEMCANCELcancel_task_typeTASKSTRING_VALUEALTERSYSTEMMAJORFREEZEIGNORESTRING_VALUE,STRING_VALUEALTERSYSTEMCHECKPOINTALTERSYSTEMMINORFREEZETENANTCOMP_EQ(relation_name_or_string,relation_name_or_string)PARTITION_IDCOMP_EQSTRING_VALUESERVERCOMP_EQ(STRING_VALUE,STRING_VALUE)ZONECOMP_EQrelation_name_or_stringALTERSYSTEMCLEARROOTTABLETENANTCOMP_EQrelation_name_or_stringALTERSYSTEMserver_actionSERVERSTRING_VALUE,STRING_VALUEZONECOMP_EQrelation_name_or_stringALTERSYSTEMADDZONErelation_name_or_stringadd_or_alter_zone_optionsALTERSYSTEMzone_actionZONErelation_name_or_stringALTERSYSTEMalter_or_change_or_modifyZONErelation_name_or_stringSETadd_or_alter_zone_optionsALTERSYSTEMREFRESHSCHEMAserver_or_zoneALTERSYSTEMSET_TPalter_system_settp_actionsALTERSYSTEMCLEARLOCATIONCACHEserver_or_zoneALTERSYSTEMREMOVEBALANCETASKTENANTCOMP_EQrelation_name_or_string,relation_name_or_stringZONECOMP_EQSTRING_VALUE,STRING_VALUETYPECOMP_EQbalance_task_typeALTERSYSTEMRELOADGTSALTERSYSTEMRELOADUNITALTERSYSTEMRELOADSERVERALTERSYSTEMRELOADZONEALTERSYSTEMMIGRATEUNITCOMP_EQINTNUMDESTINATIONCOMP_EQSTRING_VALUEALTERSYSTEMCANCELMIGRATEUNITINTNUMALTERSYSTEMUPGRADEVIRTUALSCHEMAALTERSYSTEMRUNJOBSTRING_VALUEserver_or_zoneALTERSYSTEMupgrade_actionUPGRADEALTERSYSTEMREFRESHTIME_ZONE_INFOALTERSYSTEMSETDISKVALIDSERVERCOMP_EQSTRING_VALUEALTERSYSTEMDROPTABLESINSESSIONINTNUMALTERSYSTEMREFRESHTABLESINSESSIONINTNUMALTERSYSTEMSETvar_nameCOMP_EQbit_expr

partition_role

LEADERFOLLOWER

server_info

REGIONCOMP_EQrelation_name_or_stringZONECOMP_EQrelation_name_or_stringSERVERCOMP_EQSTRING_VALUEZONECOMP_EQrelation_name_or_stringSERVERCOMP_EQSTRING_VALUE

user

STRING_VALUEQUESTIONMARKunreserved_keyword

password

INTNUMQUESTIONMARKunreserved_keyword

cache_type

ALLLOCATIONCLOGILOGCOLUMN_STATBLOCK_INDEXBLOCKROWBLOOM_FILTERSCHEMAPLAN

relation_name_or_string

relation_nameSTRING_VALUE

column_name

QUESTIONMARKunreserved_keyword

literal

STRING_VALUEDATE_VALUETIMESTAMP_VALUEINTNUMAPPROXNUMDECIMAL_VALNULLXinterval_literal

partition_id_or_server_or_zone

PARTITION_IDCOMP_EQSTRING_VALUESERVERCOMP_EQSTRING_VALUESERVERCOMP_EQSTRING_VALUETENANTCOMP_EQrelation_name_or_stringZONECOMP_EQrelation_name_or_stringTENANTCOMP_EQrelation_name_or_string

server_or_zone

SERVERCOMP_EQSTRING_VALUEZONECOMP_EQrelation_name_or_string

alter_or_change_or_modify

ALTERCHANGEMODIFY

change_actions

REPLICA_TYPECOMP_EQSTRING_VALUEREPLICA_TYPECOMP_EQSTRING_VALUEchange_actions

migrate_action

MOVECOPY

suspend_or_resume

SUSPENDRESUME

cancel_task_type

PARTITIONMIGRATIONempty

server_action

ADDDELETECANCELDELETESTARTSTOPFORCESTOP

add_or_alter_zone_options

add_or_alter_zone_optionadd_or_alter_zone_options,add_or_alter_zone_optionempty

zone_action

DELETESTARTSTOPFORCESTOP

alter_system_settp_actions

settp_optionalter_system_settp_actions,settp_optionempty

balance_task_type

AUTOMANUALALL

upgrade_action

BEGIEND

var_name

QUESTIONMARKunreserved_keyword_normal

bit_expr

bit_expr+bit_exprbit_expr-bit_exprbit_exprbit_exprbit_expr/bit_exprbit_exprCNNOPbit_exprunary_expr

relation_name

QUESTIONMARKunreserved_keyword

interval_literal

interval_literal_shortinterval_literal_shortTOdate_unit(INTNUM)

empty

ε

add_or_alter_zone_option

REGIONCOMP_EQrelation_name_or_stringIDCCOMP_EQrelation_name_or_stringZONE_TYPECOMP_EQrelation_name_or_string

settp_option

TP_NOCOMP_EQINTNUMTP_NAMECOMP_EQrelation_name_or_stringOCCURCOMP_EQINTNUMFREQUENCYCOMP_EQINTNUMERROR_CODECOMP_EQINTNUM

unary_expr

+simple_expr-simple_exprsimple_expr

interval_literal_short

INTERVAL_VALUEdate_unit(INTNUM)INTERVAL_VALUEdate_unit(INTNUM,INTNUM)

date_unit

YEARMONTHDAYHOURMINUTESECOND

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

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

select_with_parens

(select_no_parens)(select_with_parens)(with_select)

column_definition_ref

column_namerelation_name.column_namerelation_name.relation_name.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)

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)

global_or_session_alias

GLOBAL_ALIASSESSION_ALIAS

select_no_parens

select_clauseselect_clause_set

with_select

with_clauseselect_no_parenswith_clauseselect_with_parens

case_default

ELSEbit_exprempty

single_row_function

MOD(bit_expr,bit_expr)character_functionextract_functionconversion_functionSYS_CONNECT_BY_PATH(bit_expr,signed_literal)environment_id_function

aggregate_function

APPROX_COUNT_DISTINCT(bit_expr,bit_expr)APPROX_COUNT_DISTINCT_SYNOPSIS(bit_expr,bit_expr)APPROX_COUNT_DISTINCT_SYNOPSIS_MERGE(bit_expr)SUM(ALLDISTINCTUNIQUEbit_expr)MAX(ALLDISTINCTUNIQUEbit_expr)MIN(ALLDISTINCTUNIQUEbit_expr)AVG(ALLDISTINCTUNIQUEbit_expr)STDDEV(ALLDISTINCTUNIQUEbit_expr)VARIANCE(ALLDISTINCTUNIQUEbit_expr)STDDEV_POP(ALLDISTINCTUNIQUEbit_expr)STDDEV_SAMP(ALLDISTINCTUNIQUEbit_expr)GROUPING(bit_expr)

special_func_expr

ISNULL(bit_expr)cur_timestamp_funcINSERT(bit_expr,bit_expr,bit_expr,bit_expr)LEFT(bit_expr,bit_expr)POSITION(bit_exprINbit_expr)DATE(bit_expr)YEAR(bit_expr)TIME(bit_expr)MONTH(bit_expr)DEFAULT(column_definition_ref)VALUES(column_definition_ref)CHARACTER(bit_expr,bit_expr)CHARACTER(bit_expr,bit_exprUSINGcharset_name)

common_cursor_attribute

ISOPENFOUNDNOTFOUNDROWCOUNT

implicit_cursor_attribute

SQL%common_cursor_attributeSQL%BULK_ROWCOUNT(bit_expr)SQL%cursor_attribute_bulk_exceptions

sort_key

bit_exprASCDESC

win_window

win_rows_or_rangeBETWEENwin_boundingANDwin_boundingwin_rows_or_rangewin_bounding

win_fun_first_last_params

(bit_exprrespect_or_ignoreNULLS)(bit_expr)respect_or_ignoreNULLS

win_fun_lead_lag_params

(bit_exprrespect_or_ignoreNULLS)(bit_exprrespect_or_ignoreNULLS,bit_expr,bit_expr)(bit_expr,bit_expr)respect_or_ignoreNULLS

first_or_last

FIRSTLAST

respect_or_ignore

RESPECTIGNORE

function_name

QUESTIONMARKDUMPCHARSETCOLLATIONKEY_VERSIONDATABASECOALESCEREPEATROW_COUNTREVERSERIGHTCURRENT_USERSYSTEM_USERSESSION_USERREPLACEEGKMPT

func_param

var_namePARAM_ASSIGN_OPERATORbit_exprbit_expr

table_index

INTNUMvar_name

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

character_function

SUBSTR(substr_params)TRIM(parameterized_trim)

extract_function

EXTRACT(date_unit_for_extractFROMbit_expr)SESSIONTIMEZONEDBTIMEZONE

conversion_function

CAST(bit_exprAScast_data_type)CONVERT(bit_expr,cast_data_type)CONVERT(bit_exprUSINGcharset_name)

signed_literal

literal+number_literal-number_literal

environment_id_function

USERUID

cur_timestamp_func

SYSDATESYSTIMESTAMPSYSTIMESTAMP(INTNUM)CURRENT_DATELOCALTIMESTAMPLOCALTIMESTAMP(INTNUM)CURRENT_TIMESTAMPCURRENT_TIMESTAMP(INTNUM)

charset_name

QUESTIONMARKSTRING_VALUEBINARY

cursor_attribute_bulk_exceptions

BULK_EXCEPTIONS.COUNTBULK_EXCEPTIONS(bit_expr).ERROR_INDEXBULK_EXCEPTIONS(bit_expr).ERROR_CODE

win_rows_or_range

ROWSRANGE

win_bounding

CURRENTROWbit_exprwin_preceding_or_following

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

substr_params

bit_expr,bit_exprbit_expr,bit_expr,bit_expr

parameterized_trim

bit_exprbit_exprFROMbit_exprBOTHbit_exprFROMbit_exprLEADINGbit_exprFROMbit_exprTRAILINGbit_exprFROMbit_exprBOTHFROMbit_exprLEADINGFROMbit_exprTRAILINGFROMbit_expr

date_unit_for_extract

date_unittimezone_unit

cast_data_type

RAW(INTNUMCHARACTERBYTE)CHARACTER(INTNUMCHARACTERBYTE)BINARYvarchar_type_i(INTNUMCHARACTERBYTE)BINARYvarchar_type_iDATETIMESTAMP(INTNUM)TIMESTAMP(INTNUM)WITHTIMEZONETIMESTAMP(INTNUM)WITHLOCALTIMEZONEint_type_inumber_type_inumber_precisionNUMBERnumber_precisionFLOAT(INTNUM)()double_type_i