Oracle Built-in Functions

发布时间：2020-12-12 15:06:49 所属栏目：百科来源：网络整理

导读：点击打开链接 Oracle Built-in Functions Version 11.1 Function Name Analytic Collection Conver sion Date Time Data Mining Misc. Model Clause Null Handling Numeric Object String XML ABS ACOS ADD_MONTHS ADJ_DATE APPENDCHILDXML ASCII ASCIISTR A

Oracle Built-in FunctionsVersion 11.1

Function Name

AnalyticCollectionConver
sionDate
TimeData MiningMisc.Model
ClauseNull
HandlingNumericObjectStringXMLABSACOSADD_MONTHSADJ_DATEAPPENDCHILDXMLASCIIASCIISTRASINATANATAN2AVGBFILENAMEBIN_TO_NUMBINARY2VARCHARBIT_COMPLEMENTBIT_ORBIT_XORBITANDBOOL_TO_INTCARDINALITYCASECASTCAST_FROM_BINARY
_DOUBLECAST_FROM_BINARY
_FLOATCAST_FROM_BINARY
_INTEGERCAST_FROM_NUMBERCAST_TO_BINARY
_DOUBLECAST_TO_BINARY_FLOATCAST_TO_BINARY
_INTEGERCAST_TO_NUMBERCAST_TO_NVARCHAR2CAST_TO_RAWCAST_TO_VARCHARCEILCHARTOROWIDCHRCLUSTER_IDCLUSTER_PROBABILITYCLUSTER_SETCOALESCECOLLECTCOMPOSECONCATCONVERTCORRCORR_KCORR_SCOSCOSHCOUNTCOVAR_POPCOVAR_SAMPCUME_DISTCURRENT_DATECURRENT_TIMESTAMPCVDBTIMEZONEDENSE_RANKDECODEDECOMPOSEDELETEXMLDEPTHDEREFDUMPEMPTY_BLOB (large object)EMPTY_CLOB (large object)ESTIMATE_CPU_UNITSEXISTSNODEEXPEXTRACTEXTRACTVALUEFEATURE_IDFEATURE_SETFEATURE_VALUEFIRSTFIRST_VALUEFLOORFROM_TZGET_CLOCK_TIMEGET_DDLGET_DEPENDENT_DDLGET_DEPENDENT_XMLGET_GRANTED_DDLGET_GRANTED_XDLGET_HASHGET_REBUILD_COMMANDGET_SCNGET_XMLGREATESTGROUP_IDGROUPINGGROUPING_IDHEXTORAWINITCAPINSERTCHILDXMLINSERTXMLBEFOREINSTRINSTRBINSTRCINSTR2INSTR4INT_TO_BOOLINTERVALITERATEITERATE UNTILITERATION_NUMBERLAGLASTLAST_DAYLAST_VALUELEADLEASTLENGTHLENGTHBLENGTHCLENGTH2LENGTH4LNLNNVLLOCALTIMESTAMPLOGLOWERLPADLTRIMMAKEREFMAXMEDIANMINMONTHS_BETWEENMODNANVLNEW_TIMENEXT_DAYNHEXTORAWNLS_CHARSET_DECL_LENNLS_CHARSET_IDNLS_CHARSET_NAMENLS_INITCAPNLS_LOWERNLSSORTNLS_UPPERNTILENULLFNNULLIFNUMTODSINTERVALNUMTOHEX&NUMTOHEX2NUMTOYMINTERVALNVLNVL2ORA_HASHPATHPERCENT_RANKPERCENTILE_CONTPERCENTILE_DISCPOWERPOWERMULTISETPOWERMULTISET_BY_
CARDINALITYPREDICTIONPREDICTION_BOUNDSPREDICTION_COSTPREDICTION_DETAILSPREDICTION_PROBABILITYPREDICTION_SETPRESENTNNVPRESENTVPREVIOUSQUOTE DELIMITERSRANDOMBYTESRANDOMINTEGERRANDOMNUMBERRANKRATIO_TO_REPORTRAW_TO_CHARRAW_TO_NCHARRAW_TO_VARCHAR2RAWTOHEXRAWTONHEXRAWTONUMRAWTONUM2REFREFTOHEXREGEXP_COUNTREGEXP_INSTRREGEXP_REPLACEREGEXP_SUBSTRREGR_AVGXREGR_AVGYREGR_COUNTREGR_INTERCEPTREGR_R2REGR_SLOPEREGR_SXXREGR_SXYREGR_SYYREMAINDERREPLACEREVERSEROUNDROW_NUMBERROWIDTOCHARROWIDTONCHARRPADRTRIMSCN_TO_TIMESTAMPSESSIONTIMEZONESETSIGNSINSINHSOUNDEXSQRTSQLCODE (exception)SQLERRM (exception)STATS_BINOMIAL_TESTSTATS_CROSSTABSTATS_F_TESTSTATS_KS_TESTSTATS_MODESTATS_MW_TESTSTATS_ONE_WAY_ANOVASTATS_T_TESTSTATS_WSR_TESTSTDDEVSTDDEV_POPSTDDEV_SAMPSTRING_TO_RAWSUBSTRSUBSTRBSUBSTRCSUBSTR2SUBSTR4SUMSYS_CONNECT_BY_PATH (hierarchical)SYS_CONTEXT (environment)SYS_DBURIGENSYS_EXTRACT_UTCSYS_GUID (identifier)SYS_OP_COMBINED_HASHSYS_OP_DESCENDSYS_OP_DISTINCTSYS_OP_GUIDSYS_OP_LBIDSYS_OP_MAP_NONNULLSYS_OP_RAWTONUMSYS_OP_RPBSYS_OP_TOSETIDSYS_TYPEIDSYS_XMLAGGSYS_XMLGENSYSDATESYSTIMESTAMPTABLETANTANHTIMESTAMP_TO_SCNTO_BINARYDOUBLETO_BINARYFLOATTO_CHARTO_CLOBTO_DATETO_DSINTERVALTO_LOBTO_MULTI_BYTETO_NCHARTO_NCLOBTO_NUMBERTO_SINGLE_BYTETO_TIMESTAMPTO_TIMESTAMP_TZTO_YMINTERVALTRANSLATETRANSLATE USINGTRANSLITERATETREATTRIMTRUNCTZ_OFFSETUID (environment)UNISTRUPDATEXMLUPPERUSER (environment)USERENV (environment)VALUE (object)VAR_POPVAR_SAMPVARIANCEVERIFY_OWNERVERIFY_TABLEVERTICAL BARSVSIZEWIDTH_BUCKETXMLAGGXMLCASTXMLCDATAXMLCOLLATVALXMLCOMMENTXMLCONCATXMLDIFFXMLELEMENTXMLEXISTSXMLFORESTXMLISVALIDXMLPARSEXMLPATCHXMLPIXMLQUERYXMLROOTXMLSEQUENCEXMLSERIALIZEXMLTABLEXMLTRANSFORMXOR

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

点击打开链接