全部产品

CREATE TENANT

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

OracleSQLParser.g4

create_tenant_stmt

CREATETENANTrelation_nametenant_optionopt_tenant_option_list,tenant_optionSETobj_access_ref_normalto_or_eqset_expr_or_default,obj_access_ref_normalto_or_eqset_expr_or_defaultSETVARIABLESobj_access_ref_normalto_or_eqset_expr_or_default,obj_access_ref_normalto_or_eqset_expr_or_defaultVARIABLESobj_access_ref_normalto_or_eqset_expr_or_default,obj_access_ref_normalto_or_eqset_expr_or_default

relation_name

QUESTIONMARKunreserved_keyword

tenant_option

LOGONLY_REPLICA_NUMCOMP_EQINTNUMLOCALITYCOMP_EQSTRING_VALUEFORCEREPLICA_NUMCOMP_EQINTNUMREWRITE_MERGE_VERSIONCOMP_EQINTNUMSTORAGE_FORMAT_VERSIONCOMP_EQINTNUMSTORAGE_FORMAT_WORK_VERSIONCOMP_EQINTNUMPRIMARY_ZONECOMP_EQprimary_zone_nameRESOURCE_POOL_LISTCOMP_EQ(STRING_VALUE,STRING_VALUE)ZONE_LISTCOMP_EQ(STRING_VALUE,STRING_VALUE)charset_keyCOMP_EQcharset_nameread_only_or_writeCOMMENTCOMP_EQSTRING_VALUEdefault_tablegroup

opt_tenant_option_list

tenant_optionopt_tenant_option_list,tenant_optionempty

obj_access_ref_normal

var_name.obj_access_ref_normalaccess_func_expr.obj_access_ref_normaltable_element_access_list

to_or_eq

TOCOMP_EQ

set_expr_or_default

bit_exprBOOL_VALUEONOFFBINARYDEFAULT

primary_zone_name

DEFAULTRANDOMrelation_name_or_string

charset_key

CHARSETCHARACTERSET

charset_name

QUESTIONMARKSTRING_VALUEBINARY

read_only_or_write

READONLYREADWRITE

default_tablegroup

DEFAULT_TABLEGROUPCOMP_EQrelation_nameDEFAULT_TABLEGROUPCOMP_EQNULLX

empty

ε

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)

bit_expr

bit_expr+bit_exprbit_expr-bit_exprbit_expr bit_exprbit_expr/bit_exprbit_exprCNNOPbit_exprunary_expr

relation_name_or_string

relation_nameSTRING_VALUE

function_name

QUESTIONMARKDUMPCHARSETCOLLATIONKEY_VERSIONDATABASECOALESCEREPEATROW_COUNTREVERSERIGHTCURRENT_USERSYSTEM_USERSESSION_USERREPLACEEGKMPT

func_param

var_namePARAM_ASSIGN_OPERATORbit_exprbit_expr

table_index

INTNUMvar_name

unary_expr

+simple_expr-simple_exprsimple_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

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)

column_name

QUESTIONMARKunreserved_keyword

literal

STRING_VALUEDATE_VALUETIMESTAMP_VALUEINTNUMAPPROXNUMDECIMAL_VALNULLXinterval_literal

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

interval_literal

interval_literal_shortinterval_literal_shortTOdate_unit(INTNUM)

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)

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

interval_literal_short

INTERVAL_VALUEdate_unit(INTNUM)INTERVAL_VALUEdate_unit(INTNUM,INTNUM)

date_unit

YEARMONTHDAYHOURMINUTESECOND

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_iINTERVALYEAR(INTNUM)TOMONTHINTERVALDAY(INTNUM)TOSECOND(INTNUM)udt_type

number_literal

INTNUMDECIMAL_VAL

win_preceding_or_following

PRECEDINGFOLLOWING

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

query_expression_option

ALLDISTINCTUNIQUESQL_CALC_FOUND_ROWS

column_label

QUESTIONMARKunreserved_keyword

field_opt

columns_or_fieldsfield_termempty

line_opt

LINESline_termempty

into_clause

INTOinto_var,into_varBULKCOLLECTINTOinto_var,into_var

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_conditionjoined_tableouter_join_typeJOINtable_factorjoin_conditiontable_factorINNERJOINtable_factorONexprtable_factorASOFTIMESTAMPsimple_exprINNERJOINtable_factorONexpr