全部产品
云市场

CREATE TABLEGROUP

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

OracleSQLParser.g4

createtablegroup_stmt

CREATETABLEGROUPrelation_nametablegroup_option_listtg_hash_partition_optionPARTITIONBYRANGECOLUMNSINTNUMtg_subpartition_optionPARTITIONSINTNUM(range_partition_element,range_partition_element)PARTITIONBYLISTCOLUMNSINTNUMtg_subpartition_optionPARTITIONSINTNUM(list_partition_element,list_partition_element)

relation_name

QUESTIONMARKunreserved_keyword

tablegroup_option_list

tablegroup_option_list_space_seperatedtablegroup_option,tablegroup_option_list

tg_hash_partition_option

PARTITIONBYHASHtg_subpartition_optionPARTITIONSINTNUMPARTITIONBYHASHINTNUMtg_subpartition_optionPARTITIONSINTNUM

tg_subpartition_option

SUBPARTITIONBYRANGECOLUMNSINTNUMSUBPARTITIONTEMPLATE(SUBPARTITIONrelation_factorVALUESLESSTHANrange_partition_exprphysical_attributes_option,SUBPARTITIONrelation_factorVALUESLESSTHANrange_partition_exprphysical_attributes_option)SUBPARTITIONBYHASHSUBPARTITIONSINTNUMSUBPARTITIONBYLISTCOLUMNSINTNUMSUBPARTITIONTEMPLATE(SUBPARTITIONrelation_factorVALUESlist_partition_exprphysical_attributes_option,SUBPARTITIONrelation_factorVALUESlist_partition_exprphysical_attributes_option)empty

range_partition_element

PARTITIONrelation_factorVALUESLESSTHANrange_partition_exprIDINTNUMphysical_attributes_optioncompress_optionPARTITIONVALUESLESSTHANrange_partition_exprIDINTNUMphysical_attributes_optioncompress_option

list_partition_element

PARTITIONrelation_factorVALUESlist_partition_exprIDINTNUMphysical_attributes_optioncompress_optionPARTITIONVALUESlist_partition_exprIDINTNUMphysical_attributes_optioncompress_option

tablegroup_option_list_space_seperated

tablegroup_optiontablegroup_optiontablegroup_option_list_space_seperated

tablegroup_option

LOCALITYCOMP_EQlocality_nameFORCEPRIMARY_ZONECOMP_EQprimary_zone_nameTABLEGROUP_IDCOMP_EQINTNUMBINDINGCOMP_EQBOOL_VALUEMAX_USED_PART_IDCOMP_EQINTNUM

relation_factor

normal_relation_factor.relation_name

range_partition_expr

(range_expr,range_expr)MAXVALUE

physical_attributes_option

PCTFREECOMP_EQINTNUMPCTUSEDINTNUMINITRANSINTNUMMAXTRANSINTNUMSTORAGE(storage_option)TABLESPACEQUESTIONMARK

list_partition_expr

(bit_expr,bit_expr)(DEFAULT)

empty

ε

compress_option

NOCOMPRESSCOMPRESSBASICFOROLTPFORQUERYLOWHIGHFORARCHIVELOWHIGH

locality_name

STRING_VALUEDEFAULT

primary_zone_name

DEFAULTRANDOMrelation_name_or_string

normal_relation_factor

relation_namerelation_name.relation_name

range_expr

bit_exprMAXVALUE

storage_option

INITIALINTNUMunit_of_sizeNEXTINTNUMunit_of_sizeMINEXTENTSINTNUMMAXEXTENTSint_or_unlimited

bit_expr

bit_expr+bit_exprbit_expr-bit_exprbit_exprbit_exprbit_expr/bit_exprbit_exprCNNOPbit_exprunary_expr

relation_name_or_string

relation_nameSTRING_VALUE

unit_of_size

KMGTPE

int_or_unlimited

INTNUMUNLIMITED

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

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)

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

function_name

QUESTIONMARKDUMPCHARSETCOLLATIONKEY_VERSIONDATABASECOALESCEREPEATROW_COUNTREVERSERIGHTCURRENT_USERSYSTEM_USERSESSION_USERREPLACEEGKMPT

func_param

var_namePARAM_ASSIGN_OPERATORbit_exprbit_expr

table_index

INTNUMvar_name

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)

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

var_name

QUESTIONMARKunreserved_keyword_normal

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

charset_key

CHARSETCHARACTERSET

field_opt