全部产品

CREATE TABLE

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

OracleSQLParser.g4

createtable_stmt

CREATEtemporary_optionTABLErelation_factor(table_element,table_element)table_option_listopt_partition_optionon_commit_optionCREATEtemporary_optionTABLErelation_factor(table_element,table_element)table_option_listopt_partition_optionASsubqueryORDERSIBLINGSBYbit_exprASCDESC,bit_exprASCDESCCREATEtemporary_optionTABLErelation_factortable_option_listopt_partition_optionASsubqueryORDERSIBLINGSBYbit_exprASCDESC,bit_exprASCDESCCREATEtemporary_optionTABLErelation_factorpartition_option_innercolumn_partition_optionASsubqueryORDERSIBLINGSBYbit_exprASCDESC,bit_exprASCDESCCREATEtemporary_optionTABLErelation_factorASsubqueryORDERSIBLINGSBYbit_exprASCDESC,bit_exprASCDESC

temporary_option

GLOBALTEMPORARYempty

relation_factor

normal_relation_factor.relation_name

table_element

column_definitionout_of_line_constraintINDEXrelation_nameindex_using_algorithm(bit_exprASCDESCIDINTNUM,bit_exprASCDESCIDINTNUM)index_optionempty

table_option_list

table_option_list_space_seperatedtable_option,table_option_list

opt_partition_option

partition_option_innercolumn_partition_optioncolumn_partition_option

on_commit_option

ONCOMMITDELETEROWSONCOMMITPRESERVEROWSempty

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

partition_option_inner

PARTITIONBYHASH(column_name,column_name)subpartition_optionPARTITIONSINTNUMTABLESPACEQUESTIONMARKcompress_optionPARTITIONBYRANGE(column_name,column_name)subpartition_optionPARTITIONSINTNUM(range_partition_element,range_partition_element)PARTITIONBYLIST(column_name,column_name)subpartition_optionPARTITIONSINTNUM(list_partition_element,list_partition_element)

column_partition_option

PARTITIONBYCOLUMN(vertical_column_name)PARTITIONBYCOLUMN(vertical_column_name,vertical_column_name,vertical_column_name)

empty

ε

normal_relation_factor

relation_namerelation_name.relation_name

relation_name

QUESTIONMARKunreserved_keyword

column_definition

column_definition_refdata_typevisibility_optionopt_column_attribute_listcolumn_attributecolumn_definition_refdata_typevisibility_optionGENERATEDALWAYSAS(bit_expr)VIRTUALopt_generated_column_attribute_listgenerated_column_attributecolumn_definition_refvisibility_optionGENERATEDALWAYSAS(bit_expr)VIRTUALopt_generated_column_attribute_listgenerated_column_attribute

out_of_line_constraint

CONSTRAINTrelation_nameUNIQUE(bit_exprASCDESCIDINTNUM,bit_exprASCDESCIDINTNUM)USINGINDEXindex_optionPRIMARYKEY(column_name,column_name)USINGINDEXindex_optionCONSTRAINTrelation_namePRIMARYKEY(column_name,column_name)USINGINDEXindex_optionCONSTRAINTrelation_nameFOREIGNKEY(column_name,column_name)REFERENCESnormal_relation_factor(column_name,column_name)ONDELETEreference_actionUSINGINDEXindex_optionFOREIGNKEY(column_name,column_name)REFERENCESnormal_relation_factor(column_name,column_name)ONDELETEreference_actionUSINGINDEXindex_optionCONSTRAINTrelation_nameCHECK(expr)RELYNORELYUSINGINDEXindex_optionENABLEDISABLEVALIDATENOVALIDATE

index_using_algorithm

USINGBTREEUSINGHASH

index_option

GLOBALLOCALBLOCK_SIZECOMP_EQINTNUMCOMMENTSTRING_VALUESTORING(column_name,column_name)WITH_ROWIDWITHPARSERSTRING_VALUEindex_using_algorithmvisibility_optionDATA_TABLE_IDCOMP_EQINTNUMINDEX_TABLE_IDCOMP_EQINTNUMMAX_USED_PART_IDCOMP_EQINTNUMTABLESPACEQUESTIONMARK

table_option_list_space_seperated

table_optiontable_optiontable_option_list_space_seperated

table_option

TABLE_MODECOMP_EQSTRING_VALUEDUPLICATE_SCOPECOMP_EQSTRING_VALUELOCALITYCOMP_EQlocality_nameFORCEEXPIRE_INFOCOMP_EQ(bit_expr)PROGRESSIVE_MERGE_NUMCOMP_EQINTNUMBLOCK_SIZECOMP_EQINTNUMTABLE_IDCOMP_EQINTNUMREPLICA_NUMCOMP_EQINTNUMcompress_optionUSE_BLOOM_FILTERCOMP_EQBOOL_VALUEPRIMARY_ZONECOMP_EQprimary_zone_nameTABLEGROUPCOMP_EQrelation_name_or_stringread_only_or_writeENGINECOMPEQrelation_name_or_stringTABLET_SIZECOMP_EQINTNUMMAX_USED_PART_IDCOMP_EQINTNUMENABLEROWMOVEMENTDISABLEROWMOVEMENTphysical_attributes_option

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

column_name

QUESTIONMARKunreserved_keyword

subpartition_option

SUBPARTITIONBYRANGE(column_name,column_name)SUBPARTITIONTEMPLATE(SUBPARTITIONrelation_factorVALUESLESSTHANrange_partition_exprphysical_attributes_option,SUBPARTITIONrelation_factorVALUESLESSTHANrange_partition_exprphysical_attributes_option)SUBPARTITIONBYHASH(column_name,column_name)SUBPARTITIONSINTNUMSUBPARTITIONBYLIST(column_name,column_name)SUBPARTITIONTEMPLATE(SUBPARTITIONrelation_factorVALUESlist_partition_exprphysical_attributes_option_list,SUBPARTITIONrelation_factorVALUESlist_partition_exprphysical_attributes_option_list)empty

compress_option

NOCOMPRESSCOMPRESSBASICFOROLTPFORQUERYLOWHIGHFORARCHIVELOWHIGH

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

vertical_column_name

column_name(column_name,column_name)

column_definition_ref

column_namerelation_name.column_namerelation_name.relation_name.column_name

data_type

int_type_iFLOAT(INTNUM)()double_type_inumber_type_inumber_precisionNUMBERnumber_precisionTIMESTAMP(INTNUM)TIMESTAMP(INTNUM)WITHTIMEZONETIMESTAMP(INTNUM)WITHLOCALTIMEZONEDATECHARACTER(INTNUMCHARACTERBYTE)BINARYcharset_keycharset_nameCOLLATEcollation_namevarchar_type_i(INTNUMCHARACTERBYTE)BINARYcharset_keycharset_nameCOLLATEcollation_nameRAW(INTNUMCHARACTERBYTE)STRING_VALUEBLOBCLOBBINARYcharset_keycharset_nameCOLLATEcollation_nameINTERVALYEAR(INTNUM)TOMONTHINTERVALDAY(INTNUM)TOSECOND(INTNUM)

visibility_option

VISIBLEINVISIBLE

opt_column_attribute_list

opt_column_attribute_listcolumn_attributeempty

column_attribute

NOTNULLXNULLXDEFAULTbit_exprORIG_DEFAULTnow_or_signed_literalPRIMARYKEYUNIQUEONUPDATEcur_timestamp_funcIDINTNUMCONSTRAINTrelation_nameCHECK(expr)RELYNORELYUSINGINDEXindex_optionENABLEDISABLEVALIDATENOVALIDATE

opt_generated_column_attribute_list

opt_generated_column_attribute_listgenerated_column_attributeempty

generated_column_attribute

NOTNULLXNULLXUNIQUEKEYPRIMARYKEYUNIQUECOMMENTSTRING_VALUEIDINTNUM

reference_action

CASCADESETNULLX

locality_name

STRING_VALUEDEFAULT

primary_zone_name

DEFAULTRANDOMrelation_name_or_string

relation_name_or_string

relation_nameSTRING_VALUE

read_only_or_write

READONLYREADWRITE

physical_attributes_option

PCTFREECOMP_EQINTNUMPCTUSEDINTNUMINITRANSINTNUMMAXTRANSINTNUMSTORAGE(storage_option)TABLESPACEQUESTIONMARK

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

range_partition_expr

(range_expr,range_expr)MAXVALUE

list_partition_expr

(bit_expr,bit_expr)(DEFAULT)

physical_attributes_option_list

physical_attributes_option

int_type_i

SMALLINTINTINTEGERNUMERICDECIMAL

double_type_i

BINARY_DOUBLEBINARY_FLOAT

number_type_i

DECIMALNUMERIC

number_precision

(signed_int_num,signed_int_num)(,signed_int_num)( )(signed_int_num)

charset_key

CHARSETCHARACTERSET

charset_name

QUESTIONMARKSTRING_VALUEBINARY

collation_name

QUESTIONMARKSTRING_VALUE

varchar_type_i

VARCHARVARCHAR2

now_or_signed_literal

cur_timestamp_func_paramssigned_literal_params

cur_timestamp_func

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

storage_option

INITIALINTNUMunit_of_sizeNEXTINTNUMunit_of_sizeMINEXTENTSINTNUMMAXEXTENTSint_or_unlimited

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

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)

range_expr

bit_exprMAXVALUE

signed_int_num

INTNUM-INTNUM

cur_timestamp_func_params

(cur_timestamp_func_params)cur_timestamp_func

signed_literal_params

(signed_literal_params)signed_literal

unit_of_size

KMGTPE

int_or_unlimited

INTNUMUNLIMITED

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(