2群基础群 适合刚入门的同学，会共享最佳入门实践和资料 QQ群 # QQ群号:171092051 # 已经升级到 500人的超级群，空位多多，无需面试
Oracle SQL Function Detail
Below lists Oracle SQL Function , and which version introduce this:
SQL> SELECT NAME,VERSION,DATATYPE,DESCR FROM v$sqlfn_metadata order by 2; NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTKDUSTOOPN INVALID UNKNOWN KDUSTOOPN OPTTLK2 SQL/DS UNKNOWN LIKE OPTURNE SQL/DS UNKNOWN <> OPTTUA SQL/DS UNKNOWN UNION ALL COS SQL/DS NUMERIC COS SIN SQL/DS NUMERIC SIN TAN SQL/DS NUMERIC TAN COSH SQL/DS NUMERIC COSH SINH SQL/DS NUMERIC SINH TANH SQL/DS NUMERIC TANH EXP SQL/DS NUMERIC EXP LN SQL/DS NUMERIC LN LOG SQL/DS NUMERIC LOG OPTCFX SQL/DS UNKNOWN ANSI Fix Character Function > SQL/DS UNKNOWN > < SQL/DS UNKNOWN < >= SQL/DS UNKNOWN >= <= SQL/DS UNKNOWN <= = SQL/DS UNKNOWN = != SQL/DS UNKNOWN <> NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTNLS SQL/DS UNKNOWN NLS Parameter String To Internal Representation OPTTVLCF SQL/DS UNKNOWN TO_NUMBER TO_SINGLE_BYTE SQL/DS STRING TO_SINGLE_BYTE TO_MULTI_BYTE SQL/DS STRING TO_MULTI_BYTE NLS_LOWER SQL/DS STRING NLS_LOWER NLS_UPPER SQL/DS STRING NLS_UPPER NLS_INITCAP SQL/DS STRING NLS_INITCAP INSTRB SQL/DS NUMERIC INSTRB LENGTHB SQL/DS NUMERIC LENGTHB SUBSTRB SQL/DS STRING SUBSTRB OPTRTUR SQL/DS UNKNOWN DTYRID=>DTYBURI OPTURTB SQL/DS UNKNOWN DTYBURI=>DTYBRI OPTBTUR SQL/DS UNKNOWN DTYBRI=>DTYBURI OPTCTUR SQL/DS UNKNOWN DTYCHR=>DTYBURI OPTURTC SQL/DS UNKNOWN DTYBURI=>DTYCHR OPTURGT SQL/DS UNKNOWN > OPTURLT SQL/DS UNKNOWN < OPTURGE SQL/DS UNKNOWN >= OPTURLE SQL/DS UNKNOWN <= OPTUREQ SQL/DS UNKNOWN = OPTTNK2 SQL/DS UNKNOWN NOT LIKE NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SYS_XQRENAME V10 Oracle UNKNOWN SYS_XQRENAME SYS_XQREPLACE V10 Oracle UNKNOWN SYS_XQREPLACE SYS_XQXFORM V10 Oracle UNKNOWN SYS_XQXFORM SYS_XQFTCONTAIN V10 Oracle UNKNOWN SYS_XQXFORM SYS_XQPOLYVNE V10 Oracle UNKNOWN SYS_XQPOLYVNE SYS_XQPOLYFLR V10 Oracle UNKNOWN SYS_XQPOLYFLR SYS_XQPOLYCEL V10 Oracle UNKNOWN SYS_XQPOLYCEL SYS_XQPOLYABS V10 Oracle UNKNOWN SYS_XQPOLYABS SYS_XQPOLYRND V10 Oracle UNKNOWN SYS_XQPOLYRND SYS_XQSTARTSWITH V10 Oracle UNKNOWN SYS_XQSTARTSWITH SYS_XQENDSWITH V10 Oracle UNKNOWN SYS_XQENDSWITH SYS_XQSUBSTRBEF V10 Oracle UNKNOWN SYS_XQSUBSTRBEF SYS_XQSUBSTRAFT V10 Oracle UNKNOWN SYS_XQSUBSTRAFT SYS_XQSTRJOIN V10 Oracle UNKNOWN SYS_XQSTRJOIN SYS_XQNORMSPACE V10 Oracle UNKNOWN SYS_XQNORMSPACE SYS_XQNORMUCODE V10 Oracle UNKNOWN SYS_XQNORMUCODE SYS_XQED4URI V10 Oracle UNKNOWN SYS_XQED4URI SYS_XQIRI2URI V10 Oracle UNKNOWN SYS_XQIRI2URI SYS_XQESHTMLURI V10 Oracle UNKNOWN SYS_XQESHTMLURI SYS_XQCODEP2STR V10 Oracle UNKNOWN SYS_XQCODEP2STR SYS_XQSTR2CODEP V10 Oracle UNKNOWN SYS_XQSTR2CODEP NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SYS_XQCODEPEQ V10 Oracle UNKNOWN SYS_XQCODEPEQ SYS_XQFNCMP V10 Oracle UNKNOWN SYS_XQFNCMP SYS_XQRNDHALF2EVN V10 Oracle UNKNOWN SYS_XQRNDHALF2EVN SYS_XQNODENAME V10 Oracle UNKNOWN SYS_XQNODENAME SYS_XQNILLED V10 Oracle UNKNOWN SYS_XQNILLED SYS_XQBASEURI V10 Oracle UNKNOWN SYS_XQBASEURI SYS_XQDOCURI V10 Oracle UNKNOWN SYS_XQDOCURI SYS_XQRESVURI V10 Oracle UNKNOWN SYS_XQRESVURI SYS_XQDFLTCOLATION V10 Oracle UNKNOWN SYS_XQDFLTCOLATION SYS_XQSTATBURI V10 Oracle UNKNOWN SYS_XQSTATBURI SYS_XQRSLVQNM V10 Oracle UNKNOWN SYS_XQRSLVQNM SYS_XQFNQNM V10 Oracle UNKNOWN SYS_XQFNQNM SYS_XQPFXFRMQNM V10 Oracle UNKNOWN SYS_XQPFXFRMQNM SYS_XQLLNMFRMQNM V10 Oracle UNKNOWN SYS_XQLLNMFRMQNM SYS_XQNSPFRMQNM V10 Oracle UNKNOWN SYS_XQNSPFRMQNM SYS_XQNSP4PFX V10 Oracle UNKNOWN SYS_XQNSP4PFX SYS_XQINSPFX V10 Oracle UNKNOWN SYS_XQINSPFX SYS_XQFNNM V10 Oracle UNKNOWN SYS_XQFNNM SYS_XQSEQRVS V10 Oracle UNKNOWN SYS_XQSEQRVS SYS_XQINDXOF V10 Oracle UNKNOWN SYS_XQINDXOF SYS_XQSEQ2CON4XC V10 Oracle UNKNOWN SYS_XQSEQ2CON4XC NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SYS_XQPOLYUPLS V10 Oracle UNKNOWN SYS_XQPOLYUPLS SYS_XQPOLYUMUS V10 Oracle UNKNOWN SYS_XQPOLYUMUS SYS_XQPOLYCST V10 Oracle UNKNOWN SYS_XQPOLYCST SYS_XQPOLYCSTBL V10 Oracle UNKNOWN SYS_XQPOLYCSTBL SYS_XQPOLYSQRT V10 Oracle UNKNOWN SYS_XQPOLYSQRT SYS_XQFUNCR V10 Oracle UNKNOWN SYS_XQFUNCR SYS_XQERR V10 Oracle UNKNOWN SYS_XQERR SYS_XQMKNODEREF V10 Oracle UNKNOWN SYS_XQMKNODEREF SYS_XQRYWRP V10 Oracle UNKNOWN SYS_XQRYWRP SYS_XQEXSTWRP V10 Oracle UNKNOWN SYS_XQEXSTWRP SYS_XQRYVARGET V10 Oracle UNKNOWN SYS_XQRYVARGET SYS_XQRYENVPGET V10 Oracle UNKNOWN SYS_XQRYENVPGET SYS_XQFNROOT V10 Oracle UNKNOWN SYS_XQFNROOT SYS_XQREF2VAL V10 Oracle UNKNOWN SYS_XQREF2VAL INSERTCHILDXMLBEFORE V10 Oracle UNKNOWN INSERTCHILDXMLBEFORE INSERTCHILDXMLAFTER V10 Oracle UNKNOWN INSERTCHILDXMLAFTER SYS_XQFNDATIM V10 Oracle UNKNOWN SYS_XQFNDATIM SYS_XQLANG V10 Oracle UNKNOWN SYS_XQLANG SYS_XQDOC V10 Oracle UNKNOWN SYS_XQDOC SYS_XQFB2STR V10 Oracle UNKNOWN SYS_XQFB2STR OPTORNA V10 Oracle UNKNOWN N-way relational OR ANSI NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTORNO V10 Oracle UNKNOWN N-way relational OR ORACLE INSERTXMLAFTER V10 Oracle UNKNOWN INSERTXMLAFTER SYS_GETTOKENID V10 Oracle UNKNOWN SYS_GETTOKENID SYS_XQDELETE V10 Oracle UNKNOWN SYS_XQDELETE SYS_XQINSERT V10 Oracle UNKNOWN SYS_XQINSERT CV V10 Oracle UNKNOWN CV SYS_OP_XPTHATG V10 Oracle UNKNOWN SYS_OP_XPTHATG SYS_OP_XPTHOP V10 Oracle UNKNOWN SYS_OP_XPTHOP SYS_OP_XPTHIDX V10 Oracle UNKNOWN SYS_OP_XPTHIDX SYS_OP_XTXT2SQLT V10 Oracle UNKNOWN SYS_OP_XTXT2SQLT OPTWNLNNV V10 Oracle UNKNOWN LAST_VALUE OPTWNFNNV V10 Oracle UNKNOWN FIRST_VALUE OPTXMLSERIALIZE V10 Oracle UNKNOWN XMLSERIALIZE SYS_OP_ROWIDTOOBJ V10 Oracle UNKNOWN ROWID=>Obj# SYS_MAKE_XMLNODEID V10 Oracle UNKNOWN SYS_MAKE_XMLNODEID SYS_XMLNODEID_GETRID V10 Oracle UNKNOWN SYS_XMLNODEID_GETRID SYS_XMLNODEID_GETOKEY V10 Oracle UNKNOWN SYS_XMLNODEID_GETOKEY SYS_XQ_PKSQL2XML V10 Oracle UNKNOWN SYS_XQ_PKSQL2XML SYS_XQ_UPKXML2SQL V10 Oracle UNKNOWN SYS_XQ_UPKXML2SQL SYS_XQ_ATOMCNVCHK V10 Oracle UNKNOWN SYS_XQ_ATOMCNVCHK SYS_XQ_ASQLCNV V10 Oracle UNKNOWN SYS_XQ_ASQLCNV NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTENCRYPT V10 Oracle UNKNOWN OPTENCRYPT OPTDECRYPT V10 Oracle UNKNOWN OPTDECRYPT SYS_XMLNODEID_GETSVAL V10 Oracle UNKNOWN SYS_XMLNODEID_GETSVAL SYS_PATHID_LASTNAME V10 Oracle UNKNOWN SYS_PATHID_LASTNAME SYS_PATHID_LASTNMSPC V10 Oracle UNKNOWN SYS_PATHID_LASTNMSPC SYS_PATHID_IS_NMSPC V10 Oracle UNKNOWN SYS_PATHID_IS_NMSPC SYS_ORDERKEY_MAXCHILD V10 Oracle UNKNOWN SYS_ORDERKEY_MAXCHILD SYS_ORDERKEY_PARENT V10 Oracle UNKNOWN SYS_ORDERKEY_PARENT SYS_ORDERKEY_DEPTH V10 Oracle UNKNOWN SYS_ORDERKEY_DEPTH SYS_XMLI_LOC_ISTEXT V10 Oracle UNKNOWN SYS_XMLI_LOC_ISTEXT SYS_XMLI_LOC_ISNODE V10 Oracle UNKNOWN SYS_XMLI_LOC_ISNODE SYS_PATH_REVERSE V10 Oracle UNKNOWN SYS_PATH_REVERSE SYS_PATHID_IS_ATTR V10 Oracle UNKNOWN SYS_PATHID_IS_ATTR SYS_XQGETCONTENT V10 Oracle UNKNOWN SYS_XQGETCONTENT SYS_XQSEQTYPMATCH V10 Oracle UNKNOWN SYS_XQSEQTYPMATCH SYS_XQTREATAS V10 Oracle UNKNOWN SYS_XQTREATAS SYS_XQSEQINSB V10 Oracle UNKNOWN SYS_XQSEQINSB SYS_XQSEQRM V10 Oracle UNKNOWN SYS_XQSEQRM SYS_XQSEQSUB V10 Oracle UNKNOWN SYS_XQSEQSUB SYS_XQSEQDEEPEQ V10 Oracle UNKNOWN SYS_XQSEQDEEPEQ SYS_XQERRH V10 Oracle UNKNOWN SYS_XQERRH NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- XMLTRANSFORMBLOB V10 Oracle UNKNOWN XMLTRANSFORMBLOB SYS_XMLNODEID V10 Oracle UNKNOWN SYS_XMLNODEID SYS_XMLNODEID_GETPATHID V10 Oracle UNKNOWN SYS_XMLNODEID_GETPATHID SYS_XMLNODEID_GETLOCATOR V10 Oracle UNKNOWN SYS_XMLNODEID_GETLOCATOR SYS_XQPOLYADD V10 Oracle UNKNOWN SYS_XQPOLYADD SYS_XQPOLYSUB V10 Oracle UNKNOWN SYS_XQPOLYSUB SYS_XQPOLYMUL V10 Oracle UNKNOWN SYS_XQPOLYMUL SYS_XQPOLYDIV V10 Oracle UNKNOWN SYS_XQPOLYDIC SYS_XQPOLYMOD V10 Oracle UNKNOWN SYS_XQPOLYMOD SYS_XQPOLYVEQ V10 Oracle UNKNOWN SYS_XQPOLYVEQ SYS_XQPOLYVLT V10 Oracle UNKNOWN SYS_XQPOLYVLT SYS_XQPOLYVLE V10 Oracle UNKNOWN SYS_XQPOLYVLE SYS_XQPOLYVGT V10 Oracle UNKNOWN SYS_XQPOLYVGT SYS_XQPOLYVGE V10 Oracle UNKNOWN SYS_XQPOLYVGE VARIANCE V10 Oracle NUMERIC VARIANCE(FLOAT) (Windows) VARIANCE V10 Oracle NUMERIC VARIANCE(DOUBLE) (Windows) MEDIAN V10 Oracle NUMERIC MEDIAN STATS_MODE V10 Oracle ARG 1 STATS_MODE STATS_T_TEST_ONE V10 Oracle NUMERIC STATS_T_TEST_ONE STATS_T_TEST_PAIRED V10 Oracle NUMERIC STATS_T_TEST_PAIRED STATS_T_TEST_INDEP V10 Oracle NUMERIC STATS_T_TEST_INDEP NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- STATS_T_TEST_INDEPU V10 Oracle NUMERIC STATS_T_TEST_INDEPU STATS_F_TEST V10 Oracle NUMERIC STATS_F_TEST STATS_ONE_WAY_ANOVA V10 Oracle STRING STATS_ONE_WAY_ANOVA STATS_CROSSTAB V10 Oracle NUMERIC STATS_CROSSTAB STATS_BINOMIAL_TEST V10 Oracle NUMERIC STATS_BINOMIAL_TEST STATS_WSR_TEST V10 Oracle NUMERIC STATS_WSR_TEST STATS_MW_TEST V10 Oracle NUMERIC STATS_MW_TEST STATS_KS_TEST V10 Oracle NUMERIC STATS_KS_TEST CORR_S V10 Oracle NUMERIC CORR_S CORR_K V10 Oracle NUMERIC CORR_K OPTCL2NCL V10 Oracle UNKNOWN CLOB<=>NCLOB OPTRTRI V10 Oracle UNKNOWN RTRIM ' ' to ' ' OPTMSUA V10 Oracle UNKNOWN MULTISET UNION OPTMSUD V10 Oracle UNKNOWN MULTISET UNION DISTINCT OPTMSIA V10 Oracle UNKNOWN MULTISET INTERSECT OPTMSID V10 Oracle UNKNOWN MULTISET INTERSECT DISTINCT OPTMSEA V10 Oracle UNKNOWN MULTISET EXCEPT OPTMSED V10 Oracle UNKNOWN MULTISET EXCEPT DISTINCT SET V10 Oracle BINARY SET CARDINALITY V10 Oracle NUMERIC CARDINALITY SUBMULTISET V10 Oracle UNKNOWN SUBMULTISET NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTNOTSUBMS V10 Oracle UNKNOWN NOT SUBMULTISET OPTMEMBER V10 Oracle UNKNOWN MEMBER OF OPTNOTMEMBER V10 Oracle UNKNOWN NOT MEMBER OF OPTISSET V10 Oracle UNKNOWN IS A SET OPTISNOTSET V10 Oracle UNKNOWN IS NOT A SET OPTISEMPTY V10 Oracle UNKNOWN IS EMPTY OPTISNOTEMPTY V10 Oracle UNKNOWN IS NOT EMPTY POWERMULTISET V10 Oracle UNKNOWN POWERMULTISET POWERMULTISET_BY_CARDINALITY V10 Oracle UNKNOWN POWERMULTISET_BY_CARDINALITY OPTNINF V10 Oracle UNKNOWN IS INFINITE OPTNNAN V10 Oracle UNKNOWN IS NAN OPTNNINF V10 Oracle UNKNOWN IS NOT INFINITE OPTNNNAN V10 Oracle UNKNOWN IS NOT NAN NANVL V10 Oracle NUMERIC NANVL REMAINDER V10 Oracle NUMERIC REMAINDER INSERTXMLBEFORE V10 Oracle UNKNOWN INSERTXMLBEFORE APPENDCHILDXML V10 Oracle UNKNOWN APPENDCHILDXML DELETEXML V10 Oracle UNKNOWN DELETEXML OPTXMLROOT V10 Oracle UNKNOWN XMLROOT XMLCOMMENT V10 Oracle UNKNOWN XMLCOMMENT OPTXMLPI V10 Oracle UNKNOWN XMLPI NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- XMLCDATA V10 Oracle UNKNOWN XMLCDATA HEXTOREF V10 Oracle UNKNOWN HEXTOREF OPTTTESTOD V10 Oracle UNKNOWN STATS_T_TEST_ONE OPTTTESTPD V10 Oracle UNKNOWN STATS_T_TEST_PAIRED OPTTTESTIPD V10 Oracle UNKNOWN STATS_T_TEST_INDEP OPTTTESTIUD V10 Oracle UNKNOWN STATS_T_TEST_INDEPU OPTFTESTD V10 Oracle UNKNOWN STATS_F_TEST OPTANOVAONED V10 Oracle NUMERIC STATS_ONE_WAY_ANOVA OPTWSRTESTD V10 Oracle NUMERIC STATS_WSR_TEST OPTFCFINT V10 Oracle UNKNOWN BINARY_FLOAT=>DTYINT OPTFCDINT V10 Oracle UNKNOWN BINARY_DOUBLE=>DTYINT OPTFCINTF V10 Oracle UNKNOWN DTYINT=>BINARY_FLOAT OPTFCINTD V10 Oracle UNKNOWN DTYINT=>BINARY_DOUBLE OPTCAST3 V10 Oracle UNKNOWN SYS_OP_CAST(as ): slaves only REMAINDER V10 Oracle NUMERIC REMAINDER REMAINDER V10 Oracle NUMERIC REMAINDER ABS V10 Oracle NUMERIC ABS ABS V10 Oracle NUMERIC ABS ACOS V10 Oracle NUMERIC ACOS ASIN V10 Oracle NUMERIC ASIN ATAN V10 Oracle NUMERIC ATAN NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- ATAN2 V10 Oracle NUMERIC ATAN2 CEIL V10 Oracle NUMERIC CEIL CEIL V10 Oracle NUMERIC CEIL COS V10 Oracle NUMERIC COS COSH V10 Oracle NUMERIC COSH EXP V10 Oracle NUMERIC EXP FLOOR V10 Oracle NUMERIC FLOOR FLOOR V10 Oracle NUMERIC FLOOR LN V10 Oracle NUMERIC LN LOG V10 Oracle NUMERIC LOG MOD V10 Oracle NUMERIC MOD MOD V10 Oracle NUMERIC MOD POWER V10 Oracle NUMERIC POWER ROUND V10 Oracle NUMERIC ROUND ROUND V10 Oracle NUMERIC ROUND SIGN V10 Oracle NUMERIC SIGN SIGN V10 Oracle NUMERIC SIGN SIN V10 Oracle NUMERIC SIN SINH V10 Oracle NUMERIC SINH SQRT V10 Oracle NUMERIC SQRT SQRT V10 Oracle NUMERIC SQRT NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- TAN V10 Oracle NUMERIC TAN TANH V10 Oracle NUMERIC TANH TRUNC V10 Oracle NUMERIC TRUNC TRUNC V10 Oracle NUMERIC TRUNC STDDEV V10 Oracle NUMERIC STDDEV STDDEV V10 Oracle NUMERIC STDDEV VARIANCE V10 Oracle NUMERIC VARIANCE VARIANCE V10 Oracle NUMERIC VARIANCE AVG V10 Oracle NUMERIC AVG AVG V10 Oracle NUMERIC AVG SUM V10 Oracle NUMERIC SUM SUM V10 Oracle NUMERIC SUM OPTFFADD V10 Oracle UNKNOWN + OPTFDADD V10 Oracle UNKNOWN + OPTFFSUB V10 Oracle UNKNOWN - OPTFDSUB V10 Oracle UNKNOWN - OPTFFMUL V10 Oracle UNKNOWN * OPTFDMUL V10 Oracle UNKNOWN * OPTFFDIV V10 Oracle UNKNOWN / OPTFDDIV V10 Oracle UNKNOWN / OPTFFNEG V10 Oracle UNKNOWN - NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTFDNEG V10 Oracle UNKNOWN - OPTFCFEI V10 Oracle UNKNOWN C float=>Canonical float OPTFCDEI V10 Oracle UNKNOWN C double=>Canonical double OPTFCFIE V10 Oracle UNKNOWN Canonical float=>C float OPTFCDIE V10 Oracle UNKNOWN Canonical double=>C double OPTFCFI V10 Oracle UNKNOWN BINARY_FLOAT=>DTYIIN OPTFCDI V10 Oracle UNKNOWN BINARY_DOUBLE=>DTYIIN OPTFCIF V10 Oracle UNKNOWN DTYIIN=>BINARY_FLOAT OPTFCID V10 Oracle UNKNOWN DTYIIN=>BINARY_DOUBLE SUM V10 Oracle NUMERIC SUM(FLOAT) (Windows) SUM V10 Oracle NUMERIC SUM(DOUBLE) (Windows) AVG V10 Oracle NUMERIC AVG(FLOAT) (Windows) AVG V10 Oracle NUMERIC AVG(DOUBLE) (Windows) STDDEV V10 Oracle NUMERIC STDDEV(FLOAT) (Windows) STDDEV V10 Oracle NUMERIC STDDEV(DOUBLE) (Windows) OPTTLKC V10 Oracle UNKNOWN Internal Function to Compile a Like Pattern SYS_XQ_NRNG V10 Oracle UNKNOWN SYS_XQ_NRNG XMLQUERY V10 Oracle UNKNOWN XMLQUERY SYS_XMLCONTAINS V10 Oracle UNKNOWN SYS_XMLCONTAINS SYS_OP_C2C V10 Oracle UNKNOWN SYS_OP_C2C ORA_HASH V10 Oracle NUMERIC ORA_HASH NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTSPASSIGN V10 Oracle UNKNOWN = OPTSPCELL V10 Oracle UNKNOWN SP cell Reference OPTSPPRES V10 Oracle UNKNOWN IS PRESENT PRESENTV V10 Oracle ARG 2 PRESENTV PRESENTNNV V10 Oracle ARG 2 PRESENTNNV OPTSPFORLOOP V10 Oracle UNKNOWN SP for FOR loop OPTSPFORLIKE V10 Oracle UNKNOWN SP for LIKE loop OPTSPFORINLIST V10 Oracle UNKNOWN SP for inlist Loop CURRENTV V10 Oracle UNKNOWN CURRENTV OPTSPISANY V10 Oracle UNKNOWN IS ANY PREVIOUS V10 Oracle UNKNOWN PREVIOUS OPTSPISPRESENT V10 Oracle UNKNOWN SP IS PRESENT OPTSPALIAS V10 Oracle UNKNOWN Spreadsheet Alias OPTTINLA V10 Oracle UNKNOWN inlist equality ANSI OPTTINLO V10 Oracle UNKNOWN inlist equality ORACLE OPTSPIS V10 Oracle UNKNOWN SP binary IS OPTSPAIS V10 Oracle UNKNOWN SP binary ANSI IS OPT521 V10 Oracle UNKNOWN Unused OPTRXLIKE V10 Oracle UNKNOWN REGEXP_LIKE OPTRXNLIKE V10 Oracle UNKNOWN NOT REGEXP_LIKE REGEXP_SUBSTR V10 Oracle STRING REGEXP_SUBSTR NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- REGEXP_INSTR V10 Oracle NUMERIC REGEXP_INSTR REGEXP_REPLACE V10 Oracle STRING REGEXP_REPLACE OPTRXCOMPILE V10 Oracle UNKNOWN Internal Function to Compile a Regexp Pattern OPTCOLLCONS V10 Oracle UNKNOWN Collection Constructor SYS_ET_BLOB_TO_IMAGE V10 Oracle UNKNOWN SYS_ET_BLOB_TO_IMAGE SYS_ET_IMAGE_TO_BLOB V10 Oracle UNKNOWN SYS_ET_IMAGE_TO_BLOB INSERTCHILDXML V10 Oracle UNKNOWN INSERTCHILDXML OPT534 V10 Oracle UNKNOWN Unused SYS_ET_BFILE_TO_RAW V10 Oracle UNKNOWN SYS_ET_BFILE_TO_RAW SYS_ET_RAW_TO_BFILE V10 Oracle UNKNOWN SYS_ET_RAW_TO_BFILE OPTLRXLIKE V10 Oracle UNKNOWN REGEXP_LIKE OPTLRXNLIKE V10 Oracle UNKNOWN NOT REGEXP_LIKE OPTLRXSUBSTR V10 Oracle STRING REGEXP_SUBSTR OPTLRXINSTR V10 Oracle NUMERIC REGEXP_INSTR OPTLRXREPLACE V10 Oracle STRING REGEXP_REPLACE TO_BINARY_DOUBLE V10 Oracle NUMERIC TO_BINARY_DOUBLE TO_BINARY_FLOAT V10 Oracle NUMERIC TO_BINARY_FLOAT TO_CHAR V10 Oracle STRING TO_CHAR TO_CHAR V10 Oracle STRING TO_CHAR OPTFCFSTCF V10 Oracle UNKNOWN BINARY_FLOAT=>CHAR With Constant Format OPTFCDSTCF V10 Oracle UNKNOWN BINARY_DOUBLE=>CHAR With Constant Format NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- TO_BINARY_FLOAT V10 Oracle NUMERIC TO_BINARY_FLOAT TO_BINARY_DOUBLE V10 Oracle NUMERIC TO_BINARY_DOUBLE TO_NCHAR V10 Oracle STRING TO_NCHAR TO_NCHAR V10 Oracle STRING TO_NCHAR OPTFCSTFCF V10 Oracle NUMERIC TO_BINARY_FLOAT OPTFCSTDCF V10 Oracle NUMERIC TO_BINARY_DOUBLE OPTFFINF V10 Oracle UNKNOWN IS INFINITE OPTFDINF V10 Oracle UNKNOWN IS INFINITE OPTFFNAN V10 Oracle UNKNOWN IS NAN OPTFDNAN V10 Oracle UNKNOWN IS NAN OPTFFNINF V10 Oracle UNKNOWN IS NOT INFINITE OPTFDNINF V10 Oracle UNKNOWN IS NOT INFINITE OPTFFNNAN V10 Oracle UNKNOWN IS NOT NAN OPTFDNNAN V10 Oracle UNKNOWN IS NOT NAN NANVL V10 Oracle NUMERIC NANVL NANVL V10 Oracle NUMERIC NANVL OPTDM V10R2 Oracle UNKNOWN Internal Data Mining Function OPT682 V10R2 Oracle UNKNOWN Unused PREDICTION V10R2 Oracle UNKNOWN PREDICTION PREDICTION_PROBABILITY V10R2 Oracle UNKNOWN PREDICTION_PROBABILITY PREDICTION_COST V10R2 Oracle UNKNOWN PREDICTION_COST NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- PREDICTION_SET V10R2 Oracle UNKNOWN PREDICTION_SET PREDICTION_DETAILS V10R2 Oracle UNKNOWN PREDICTION_DETAILS CLUSTER_ID V10R2 Oracle UNKNOWN CLUSTER_ID CLUSTER_PROBABILITY V10R2 Oracle UNKNOWN CLUSTER_PROBABILITY CLUSTER_SET V10R2 Oracle UNKNOWN CLUSTER_SET FEATURE_ID V10R2 Oracle UNKNOWN FEATURE_ID FEATURE_VALUE V10R2 Oracle UNKNOWN FEATURE_VALUE FEATURE_SET V10R2 Oracle UNKNOWN FEATURE_SET LOBNVL V10R2 Oracle UNKNOWN LOBNVL OPTDMO V10R2 Oracle UNKNOWN Internal Data Mining Function XMLCAST V11R1 Oracle UNKNOWN XMLCAST XMLEXISTS2 V11R1 Oracle UNKNOWN XMLEXISTS2 XS_SYS_CONTEXT V11R1 Oracle UNKNOWN XS_SYS_CONTEXT SYS_ROW_DELTA V11R1 Oracle UNKNOWN SYS_ROW_DELTA SYS_GET_PRIVILEGES V11R1 Oracle UNKNOWN SYS_GET_PRIVILEGES OPTXPATHOUT V11R1 Oracle UNKNOWN VALUE SYS_XMLTYPE2SQL V11R1 Oracle UNKNOWN SYS_XMLTYPE2SQL OPTXLOBSNAP V11R1 Oracle UNKNOWN SYS_OP_LOBSNAP SYS_GET_ACLIDS V11R1 Oracle UNKNOWN SYS_GET_ACLIDS SYS_XMLT_2_SC V11R1 Oracle UNKNOWN SYS_XMLT_2_SC SYS_XQCASTABLEERRH V11R1 Oracle UNKNOWN SYS_XQCASTABLEERRH NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SYS_OPTXQCASTASNQ V11R1 Oracle UNKNOWN SYS_OPTXQCASTASNQ OPTCSXUPD V11R1 Oracle UNKNOWN SYS_OP_CSX_UPD SYS_OP_CSX_PATCH V11R1 Oracle UNKNOWN SYS_OP_CSX_PATCH XMLTOOBJECT V11R1 Oracle UNKNOWN XMLTOOBJECT OBJECTTOXML V11R1 Oracle UNKNOWN OBJECTTOXML OPTXMLTOREDO V11R1 Oracle UNKNOWN XMLTOREDO SYS_SYNRCIREDO V11R1 Oracle UNKNOWN SYS_SYNRCIREDO SYS_OP_COMBINED_HASH V11R1 Oracle UNKNOWN SYS_OP_COMBINED_HASH SYS_OP_LOBLOC2ID V11R1 Oracle UNKNOWN SYS_OP_LOBLOC2ID SYS_OP_LOBLOC2TYP V11R1 Oracle UNKNOWN SYS_OP_LOBLOC2TYP SYS_OP_LOBLOC2BLOB V11R1 Oracle UNKNOWN SYS_OP_LOBLOC2BLOB SYS_OP_LOBLOC2CLOB V11R1 Oracle UNKNOWN SYS_OP_LOBLOC2CLOB SYS_OP_LOBLOC2NCLOB V11R1 Oracle UNKNOWN SYS_OP_LOBLOC2NCLOB REGEXP_COUNT V11R1 Oracle UNKNOWN REGEXP_COUNT OPTLRXCOUNT V11R1 Oracle UNKNOWN REGEXP_COUNT XMLDIFF V11R1 Oracle UNKNOWN XMLDIFF XMLPATCH V11R1 Oracle UNKNOWN XMLPATCH SYS_OP_VERSION V11R1 Oracle UNKNOWN SYS_OP_VERSION SYS_XMLTRANSLATE V11R1 Oracle UNKNOWN SYS_XMLTRANSLATE OPTDMGETO V11R1 Oracle UNKNOWN Internal Data Mining Function: GET value SYS_DM_RXFORM_NUM V11R1 Oracle UNKNOWN SYS_DM_RXFORM_NUM NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SYS_DM_RXFORM_CHR V11R1 Oracle UNKNOWN SYS_DM_RXFORM_CHR OPT793 V11R1 Oracle UNKNOWN Unused PREDICTION_BOUNDS V11R1 Oracle UNKNOWN PREDICTION_BOUNDS SYS_XMLLOCATOR_GETSVAL V11R1 Oracle UNKNOWN SYS_XMLLOCATOR_GETSVAL SYS_OP_BLOOM_FILTER V11R1 Oracle UNKNOWN SYS_OP_BLOOM_FILTER SYS_OP_PIVOT V11R1 Oracle UNKNOWN SYS_OP_PIVOT CO_AUTH_IND V11R1 Oracle UNKNOWN CO_AUTH_IND SYS_FILTER_ACLS V11R1 Oracle UNKNOWN SYS_FILTER_ACLS OPTPVTIS V11R1 Oracle UNKNOWN SYS_OP_PIVOT_IS OPTPVTAIS V11R1 Oracle UNKNOWN SYS_OP_PIVOT_IS SYS_MKXMLATTR V11R1 Oracle UNKNOWN SYS_MKXMLATTR SYS_XMLNODEID_GETPTRID V11R1 Oracle UNKNOWN SYS_XMLNODEID_GETPTRID NTH_VALUE V11R1 Oracle ARG 1 NTH_VALUE LISTAGG V11R1 Oracle ARG 1 LISTAGG LISTAGG V11R1 Oracle ARG 1 LISTAGG (window) ORA_DST_AFFECTED V11R1 Oracle UNKNOWN ORA_DST_AFFECTED ORA_DST_ERROR V11R1 Oracle UNKNOWN ORA_DST_ERROR ORA_DST_CONVERT V11R1 Oracle UNKNOWN ORA_DST_CONVERT SYS_XQTOKENIZE V11R1 Oracle UNKNOWN SYS_XQTOKENIZE SYS_SC_2_XMLT V11R1 Oracle UNKNOWN SYS_SC_2_XMLT OPTGETXMLSCHEMATYPE V11R1 Oracle UNKNOWN SYS_GETXMLSCHEMATYPE NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SYS_OP_BLOOM_FILTER_LIST V11R1 Oracle UNKNOWN SYS_OP_BLOOM_FILTER_LIST SYS_XQEXLOBVAL V11R1 Oracle UNKNOWN SYS_XQEXLOBVAL SYS_OPTLOBPRBSC V11R1 Oracle UNKNOWN SYS_LOBPRBSC OPTCSXMERGE V11R1 Oracle UNKNOWN SYS_OP_CSX_MERGE SYS_XQFORMATNUM V11R1 Oracle STRING SYS_XQFORMATNUM SYS_EXTPDTXT V11R1 Oracle UNKNOWN SYS_EXTPDTXT SYS_XMLINSTR V11R1 Oracle STRING SYS_XMLINSTR SYS_XQDURDIV V11R1 Oracle UNKNOWN SYS_XQDURDIV OPTDMGET V11R1 Oracle UNKNOWN Internal Data Mining Function: GET value SYS_OP_DV_CHECK V11R1 Oracle UNKNOWN SYS_OP_DV_CHECK OPTCONSXMLFORCSX V11R1 Oracle UNKNOWN SYS_OP_XMLCONS_FOR_CSX SYS_GETXTIVAL V11R1 Oracle UNKNOWN SYS_GETXTIVAL OPTDJS V6 Oracle UNKNOWN JULIAN=>STRING OPTDIF V6 Oracle UNKNOWN STRING=>INPUT FORMAT OPTDOF V6 Oracle UNKNOWN STRING=>OUTPUT FORMAT OPTNTI V6 Oracle UNKNOWN NUMBER=>INTERNAL INTEGER OPTCTZ V6 Oracle UNKNOWN DTYCHR=>DTYDTZ OPTCDY V6 Oracle UNKNOWN DTYCHR=>DTYDYN OPTNDY V6 Oracle UNKNOWN DTYNUM=>DTYDYN OPTDPC V6 Oracle UNKNOWN DTYCHR=>DTYDPC DUMP V6 Oracle STRING DUMP NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTTNS V6 Oracle UNKNOWN Nested Select OPTDRO V6 Oracle DATETYPE ROUND TRUNC V6 Oracle DATETYPE TRUNC FLOOR V6 Oracle NUMERIC FLOOR CEIL V6 Oracle NUMERIC CEIL DECODE V6 Oracle ARG 3 DECODE LPAD V6 Oracle STRING LPAD RPAD V6 Oracle STRING RPAD OPTITN V6 Oracle UNKNOWN DTYIIN=>DTYNUM POWER V6 Oracle NUMERIC POWER SYS_OP_TPR V6 Oracle UNKNOWN Numeric Precision TO_BINARY_FLOAT V6 Oracle NUMERIC TO_BINARY_FLOAT TO_NUMBER V6 Oracle NUMERIC TO_NUMBER TO_BINARY_DOUBLE V6 Oracle NUMERIC TO_BINARY_DOUBLE TO_NUMBER V6 Oracle NUMERIC TO_NUMBER INITCAP V6 Oracle STRING INITCAP TRANSLATE V6 Oracle STRING TRANSLATE LTRIM V6 Oracle STRING LTRIM RTRIM V6 Oracle STRING RTRIM GREATEST V6 Oracle ARG 1 GREATEST LEAST V6 Oracle ARG 1 LEAST NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SQRT V6 Oracle NUMERIC SQRT VARIANCE V6 Oracle NUMERIC VARIANCE STDDEV V6 Oracle NUMERIC STDDEV OPTLKO V6 Oracle UNKNOWN LIKE RAWTOHEX V6 Oracle STRING RAWTOHEX HEXTORAW V6 Oracle BINARY HEXTORAW NVL2 V6 Oracle ARG 2 NVL2 LNNVL V6 Oracle UNKNOWN LNNVL USERENV V6 Oracle STRING USERENV MERGE$ACTIONS V6 Oracle UNKNOWN MERGE$ACTIONS TBL$OR$IDX$PART$NUM V6 Oracle UNKNOWN TBL$OR$IDX$PART$NUM OPTTSTCF V6 Oracle UNKNOWN Internal TO_CHAR(NUMBER 'constant_format') BITAND V6 Oracle NUMERIC BITAND REVERSE V6 Oracle UNKNOWN REVERSE SYS_OP_CEG V6 Oracle UNKNOWN SYS_OP_CEG CONVERT V6 Oracle STRING CONVERT REPLACE V6 Oracle STRING REPLACE NLSSORT V6 Oracle STRING NLSSORT OPTRTB V6 Oracle UNKNOWN DTYRID=>DTYBRI OPTBTR V6 Oracle UNKNOWN DTYBRI=>DTYRID OPTR2C V6 Oracle UNKNOWN DTYRID=>CHAR NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SYS_OP_COMP V6 Oracle UNKNOWN SYS_OP_COMP SYS_OP_DECOMP V6 Oracle UNKNOWN SYS_OP_DECOMP OPTCNVTLAB V6 Oracle UNKNOWN OPTCNVTLAB SYS_OP_OPNSIZE V6 Oracle UNKNOWN SYS_OP_OPNSIZE DATAOBJ_TO_PARTITION V6 Oracle UNKNOWN DATA0BJ_TO_PARTITION PART$NUM$INST V6 Oracle UNKNOWN PART$NUM$INST OPTTUC V6 Oracle UNKNOWN Unused > V6 Oracle UNKNOWN > < V6 Oracle UNKNOWN < >= V6 Oracle UNKNOWN >= <= V6 Oracle UNKNOWN <= = V6 Oracle UNKNOWN = != V6 Oracle UNKNOWN <> OPTTIS V6 Oracle ARG 1 INTERSECT OPTTUN V6 Oracle ARG 1 UNION OPTTMI V6 Oracle ARG 1 MINUS OPTTAD V6 Oracle NUMERIC + OPTTSU V6 Oracle NUMERIC - OPTTMU V6 Oracle NUMERIC * OPTTDI V6 Oracle NUMERIC / OPTTNG V6 Oracle NUMERIC - NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- AVG V6 Oracle ARG 1 AVG SUM V6 Oracle ARG 1 SUM COUNT V6 Oracle NUMERIC COUNT MIN V6 Oracle ARG 1 MIN MAX V6 Oracle ARG 1 MAX OPTDESC V6 Oracle UNKNOWN DESC TO_NUMBER V6 Oracle NUMERIC TO_NUMBER TO_CHAR V6 Oracle STRING TO_CHAR NVL V6 Oracle ARG 1 NVL CHARTOROWID V6 Oracle BINARY CHARTOROWID ROWIDTOCHAR V6 Oracle STRING ROWIDTOCHAR OPTTLK V6 Oracle UNKNOWN LIKE OPTTNK V6 Oracle UNKNOWN NOT LIKE CONCAT V6 Oracle STRING || SUBSTR V6 Oracle STRING SUBSTR LENGTH V6 Oracle NUMERIC LENGTH INSTR V6 Oracle NUMERIC INSTR LOWER V6 Oracle STRING LOWER UPPER V6 Oracle STRING UPPER ASCII V6 Oracle NUMERIC ASCII CHR V6 Oracle STRING CHR NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SOUNDEX V6 Oracle STRING SOUNDEX ROUND V6 Oracle NUMERIC ROUND TRUNC V6 Oracle NUMERIC TRUNC MOD V6 Oracle NUMERIC MOD ABS V6 Oracle NUMERIC ABS SIGN V6 Oracle NUMERIC SIGN VSIZE V6 Oracle NUMERIC VSIZE OPTTNU V6 Oracle UNKNOWN IS NULL OPTTNN V6 Oracle UNKNOWN IS NOT NULL OPTDAN V6 Oracle DATETYPE + OPTDSN V6 Oracle DATETYPE - OPTDSU V6 Oracle NUMERIC - ADD_MONTHS V6 Oracle DATETYPE ADD_MONTHS MONTHS_BETWEEN V6 Oracle NUMERIC MONTHS_BETWEEN TO_DATE V6 Oracle DATETYPE TO_DATE OPTDSY V6 Oracle DATETYPE SYSDATE LAST_DAY V6 Oracle DATETYPE LAST_DAY NEW_TIME V6 Oracle DATETYPE NEW_TIME NEXT_DAY V6 Oracle DATETYPE NEXT_DAY OPTDSD V6 Oracle DATETYPE STRING=>DATE OPTDDS V6 Oracle STRING DATE=>STRING NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTDSI V6 Oracle UNKNOWN STRING=>INTERNAL DATE OPTDIS V6 Oracle UNKNOWN TO_CHAR OPTDID V6 Oracle UNKNOWN INTERNAL DATE=>DATE OPTDDI V6 Oracle UNKNOWN DATE=>INTERNAL DATE OPTDJN V6 Oracle UNKNOWN JULIAN=>NUMBER OPTDNJ V6 Oracle UNKNOWN JULIAN=>NUMBER OPTDDJ V6 Oracle UNKNOWN DATE=>JULIAN OPTDIJ V6 Oracle UNKNOWN INTERNAL DATE=>JULIAN OPTPLS V71 Oracle UNKNOWN PLSQL Function ATAN2 V73 Oracle NUMERIC ATAN2 ATAN V73 Oracle NUMERIC ATAN ASIN V73 Oracle NUMERIC ASIN ACOS V73 Oracle NUMERIC ACOS OPTOICSCNV V80 Oracle UNKNOWN SYS_OP_CSCONV OPTDFNR V80 Oracle UNKNOWN Deferred Name Resolution OPTBLCST V80 Oracle UNKNOWN BLOB Constructor SYS_OPTXICMP V80 Oracle UNKNOWN SYS_OPTXICMP SYS_OP_REF V80 Oracle UNKNOWN ADT REFerence SYS_OP_ATG V80 Oracle UNKNOWN SYS_OP_ATG OPTATS V80 Oracle UNKNOWN Attribute Set SYS_OP_ADTCONS V80 Oracle UNKNOWN CONStructor NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SYS_OP_DRA V80 Oracle UNKNOWN ADT DeReference And Extract Attribute SYS_OP_GUID V80 Oracle UNKNOWN SYS_OP_GUID OPTNCR V80 Oracle UNKNOWN CURSOR OPTOCHK V80 Oracle UNKNOWN Object Check DEREF V80 Oracle UNKNOWN DEREF SYS_OP_MAKEOID V80 Oracle UNKNOWN SYS_OP_MAKEOID MAKE_REF V80 Oracle BINARY MAKE_REF SYS_OP_NIX V80 Oracle UNKNOWN SYS_OP_NIX SYS_OP_DUMP V80 Oracle UNKNOWN SYS_OP_DUMP REFTOHEX V80 Oracle BINARY REFTOHEX SYS_OP_VREF V80 Oracle UNKNOWN Create Variable-length REF SYS_OP_TOSETID V80 Oracle UNKNOWN SYS_OP_TOSETID OPTBNPT V80 Oracle UNKNOWN DTYBIN=>DTYNPT OPTASNPT V80 Oracle UNKNOWN Assign NPT Values OPTCCN V80 Oracle UNKNOWN Collection Constructor OPTCAST V80 Oracle UNKNOWN CAST (expression AS type) OPTLBC V80 Oracle UNKNOWN LOB Copy Constructor OPTFCONS V80 Oracle UNKNOWN Fast CONStructor OPTICMP V80 Oracle UNKNOWN Image CoMPare OPTDGRF V80 Oracle UNKNOWN IS DANGLING OPTNDGRF V80 Oracle UNKNOWN IS NOT DANGLING NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SYS_OP_R2O V80 Oracle UNKNOWN SYS_OP_R2O EMPTY_BLOB V80 Oracle BINARY EMPTY_BLOB EMPTY_CLOB V80 Oracle BINARY EMPTY_CLOB OPTCOERCE V80 Oracle UNKNOWN Coercion OPTCSIV V80 Oracle UNKNOWN Coerce Single-Insert Value OPTSM2CM V80 Oracle UNKNOWN Segmented Mem To Contig. Mem SYS_OP_RMTD V80 Oracle UNKNOWN SYS_OP_RMTD SYS_OP_RDTM V80 Oracle UNKNOWN Ref Conversion - Disk to Memory Format SYS_OP_OIDVALUE V80 Oracle UNKNOWN SYS_OP_OIDVALUE OPTOLCIC V80 Oracle UNKNOWN Out-Of-Line Collection Image Constructor BFILENAME V80 Oracle BINARY BFILENAME CSCONVERT V80 Oracle UNKNOWN CSCONVERT NLS_CHARSET_NAME V80 Oracle STRING NLS_CHARSET_NAME NLS_CHARSET_ID V80 Oracle NUMERIC NLS_CHARSET_ID OPTLCNV V80 Oracle UNKNOWN Locator CoNVersion SYS_OP_LSVI V80 Oracle UNKNOWN SYS_OP_LSVI OPTCIOUT V80 Oracle UNKNOWN VALUE NLS_CHARSET_DECL_LEN V80 Oracle NUMERIC NLS_CHARSET_DECL_LEN OPTCLCST V80 Oracle UNKNOWN CLOB and NCLOB Constructor OPTUOP V81 Oracle UNKNOWN User-Defined Operator TRIM V81 Oracle STRING TRIM NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- TRIM V81 Oracle STRING TRIM TRIM V81 Oracle STRING TRIM SYS_OP_RPB V81 Oracle UNKNOWN SYS_OP_RPB SYS_OP_TRTB V81 Oracle UNKNOWN SYS_OP_TRTB SYS_OP_DESCEND V81 Oracle UNKNOWN SYS_OP_DESCEND SYS_OP_UNDESCEND V81 Oracle UNKNOWN SYS_OP_UNDESCEND OPTXTRCT_XQUERY V81 Oracle UNKNOWN EXTRACT OPTADIX V81 Oracle UNKNOWN SYS_OP_ADIX OPTREW V81 Oracle UNKNOWN Compile-time REWrite OPTDCC V81 Oracle UNKNOWN Ddynamic Collection Constructor SYS_OP_MAP_NONNULL V81 Oracle UNKNOWN SYS_OP_MAP_NONNULL OPTVFIL V81 Oracle UNKNOWN 307 OPTC2TM V81 Oracle UNKNOWN TO_TIME OPTC2TMZ V81 Oracle UNKNOWN TO_TIME_TZ OPTC2ST V81 Oracle UNKNOWN TO_TIMESTAMP OPTC2STZ V81 Oracle UNKNOWN TO_TIMESTAMP_TZ OPTC2IYM V81 Oracle UNKNOWN TO_YMINTERVAL OPTC2IDS V81 Oracle UNKNOWN TO_DSINTERVAL OPTTM2C V81 Oracle UNKNOWN TIME=>STRING OPTTMZ2C V81 Oracle UNKNOWN TIME WITH TIME ZONE=>STRING OPTST2C V81 Oracle UNKNOWN TIMESTAMP=>STRING NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTSTZ2C V81 Oracle UNKNOWN TIMESTAMP WITH TIME ZONE=>STRING OPTIYM2C V81 Oracle UNKNOWN INTERVAL YEAR TO MONTH=>STRING OPTIDS2C V81 Oracle UNKNOWN INTERVAL DAY TO SECOND to string OPTDIPR V81 Oracle UNKNOWN Check Datetime/Interval Precisions SYS_GUID V81 Oracle BINARY SYS_GUID OPTXTRCT V81 Oracle UNKNOWN EXTRACT OPTITME V81 Oracle UNKNOWN Internal TIME=>External OPTTMEI V81 Oracle UNKNOWN External TIME=>Internal OPTITTZ V81 Oracle UNKNOWN Internal TIME WTZ=>External OPTTTZI V81 Oracle UNKNOWN External TIME WTZ=>Internal OPTISTM V81 Oracle UNKNOWN Internal TIMESTAMP=>External OPTSTMI V81 Oracle UNKNOWN External TIMESTAMP=>Internal OPTISTZ V81 Oracle UNKNOWN Internal TIMESTAMP WTZ=>External OPTSTZI V81 Oracle UNKNOWN External TIMESTAMP WTZ=>Internal OPTIIYM V81 Oracle UNKNOWN Internal INTERVAL YM=>External OPTIYMI V81 Oracle UNKNOWN External INTERVAL YM=>Internal OPTIIDS V81 Oracle UNKNOWN Internal INTERVAL DS=>External OPTIDSI V81 Oracle UNKNOWN External INTERVAL DS=>Internal OPTITMES V81 Oracle UNKNOWN TO_CHAR OPTITTZS V81 Oracle UNKNOWN TO_CHAR OPTISTMS V81 Oracle UNKNOWN TO_CHAR NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTISTZS V81 Oracle UNKNOWN TO_CHAR OPTIIYMS V81 Oracle UNKNOWN TO_CHAR OPTIIDSS V81 Oracle UNKNOWN TO_CHAR OPTLDIIF V81 Oracle UNKNOWN STRING=>Internal Format (for input) OPTLDIOF V81 Oracle UNKNOWN STRING=>Internal Format (for output) OPTDIADD V81 Oracle UNKNOWN DATETIME + INTERVAL OPTDISUB V81 Oracle UNKNOWN DATETIME - INTERVAL OPTDDSUB V81 Oracle UNKNOWN DATETIME - DATETIME OPTIIADD V81 Oracle UNKNOWN INTERVAL + INTERVAL OPTIISUB V81 Oracle UNKNOWN INTERVAL - INTERVAL OPTINMUL V81 Oracle UNKNOWN INTERVAL * NUMBER OPTINDIV V81 Oracle UNKNOWN interval / number OPTCHGTZ V81 Oracle UNKNOWN AT OPTOVLPS V81 Oracle UNKNOWN OVERLAPS OPTOVLPC V81 Oracle UNKNOWN OVERLAPS OPTDCAST V81 Oracle UNKNOWN Casting Between Datetime Types OPTINTN V81 Oracle UNKNOWN DTYINT=>DTYNUM OPTNTIN V81 Oracle UNKNOWN DTYNUM=>DTYINT CAST V81 Oracle ARG 2 CAST SYS_CONTEXT V81 Oracle UNKNOWN SYS_CONTEXT SYS_OP_IIX V81 Oracle UNKNOWN IMAGE=>IMAGE NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SYS_OP_NII V81 Oracle UNKNOWN Get Null Image From Image GROUPING V81 Oracle NUMERIC GROUPING OPTTLC V81 Oracle UNKNOWN Truncate LONG To CHAR TO_LOB V81 Oracle BINARY TO_LOB SYS_OP_MSR V81 Oracle UNKNOWN SYS_OP_MSR SYS_OP_CSR V81 Oracle UNKNOWN SYS_OP_CSR OPTIDN V81 Oracle UNKNOWN Identity OPTIAND V816 Oracle UNKNOWN IAND OPTIOR V816 Oracle UNKNOWN IOR OPTMKNULL V816 Oracle UNKNOWN MKNULL OPTC2ITZ V816 Oracle UNKNOWN TSITZ<==>CHAR OPTITZ2C2 V816 Oracle UNKNOWN Array TSITZ=>CHAR OPTITZ2C1 V816 Oracle UNKNOWN TO_CHAR OPTSRCSE V816 Oracle UNKNOWN Searched Case Expression OPTAND V816 Oracle UNKNOWN AND OPTOR V816 Oracle UNKNOWN OR FROM_TZ V816 Oracle DATETYPE FROM_TZ SYS_CONNECT_BY_PATH V816 Oracle STRING SYS_CONNECT_BY_PATH OPTNTUB4 V816 Oracle UNKNOWN DTYNUM=>DTYUB4 OPTUB4TN V816 Oracle UNKNOWN DTYUB4=>DTYNUM OPTCIDN V816 Oracle UNKNOWN Compile Time Identity Function NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTT2TTZ1 V816 Oracle UNKNOWN Struct Time=>Arr. Time with TZ OPTT2TTZ2 V816 Oracle UNKNOWN Struct Time=>Struct Time with TZ OPTTTZ2T1 V816 Oracle UNKNOWN Struct Time with TZ=>Arr. Time OPTTTZ2T2 V816 Oracle UNKNOWN Struct Time with TZ=>Struct Time OPTTS2TSTZ1 V816 Oracle UNKNOWN Struct Timestamp=>Arr. Timestamp with TZ OPTTS2TSTZ2 V816 Oracle UNKNOWN Struct Timestamp=>Struct Timestamp with TZ OPTTSTZ2TS1 V816 Oracle UNKNOWN Struct Timestamp with TZ=>Arr Timestamp OPTTSTZ2TS2 V816 Oracle UNKNOWN Struct Timestamp with TZ=>Struct Timestamp SUM V816 Oracle NUMERIC SUM AVG V816 Oracle NUMERIC AVG COUNT V816 Oracle NUMERIC COUNT VARIANCE V816 Oracle NUMERIC VARIANCE STDDEV V816 Oracle NUMERIC STDDEV MIN V816 Oracle ARG 1 MIN MAX V816 Oracle ARG 1 MAX FIRST_VALUE V816 Oracle ARG 1 FIRST_VALUE LAST_VALUE V816 Oracle ARG 1 LAST_VALUE LAG V816 Oracle ARG 1 LAG LEAD V816 Oracle ARG 1 LEAD RANK V816 Oracle NUMERIC RANK DENSE_RANK V816 Oracle NUMERIC DENSE_RANK NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- CUME_DIST V816 Oracle UNKNOWN Window Percentile NTILE V816 Oracle NUMERIC NTILE RATIO_TO_REPORT V816 Oracle NUMERIC RATIO_TO_REPORT ROW_NUMBER V816 Oracle NUMERIC ROW_NUMBER OPTWNOBY V816 Oracle UNKNOWN ORDER BY Pseudo-Function for Window OPTWNPBY V816 Oracle UNKNOWN PARTITION BY Pseudo-Function for Window OPT335 V816 Oracle UNKNOWN UNUSED OPTDESNL V816 Oracle UNKNOWN DESC NULLS LAST OPTASCNF V816 Oracle UNKNOWN ASC NULLS FIRST COVAR_POP V816 Oracle NUMERIC COVAR_POP COVAR_SAMP V816 Oracle NUMERIC COVAR_SAMP CORR V816 Oracle NUMERIC CORR REGR_SLOPE V816 Oracle NUMERIC REGR_SLOPE REGR_INTERCEPT V816 Oracle NUMERIC REGR_INTERCEPT REGR_COUNT V816 Oracle NUMERIC REGR_COUNT REGR_R2 V816 Oracle NUMERIC REGR_R2 REGR_AVGX V816 Oracle NUMERIC REGR_AVGX REGR_AVGY V816 Oracle NUMERIC REGR_AVGY REGR_SXX V816 Oracle NUMERIC REGR_SXX REGR_SYY V816 Oracle NUMERIC REGR_SYY REGR_SXY V816 Oracle NUMERIC REGR_SXY NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- VAR_POP V816 Oracle NUMERIC VAR_POP STDDEV_POP V816 Oracle NUMERIC STDDEV_POP VAR_SAMP V816 Oracle NUMERIC VAR_SAMP STDDEV_SAMP V816 Oracle NUMERIC STDDEV_SAMP OPTDAT2TS1 V816 Oracle UNKNOWN Srray Date=>Array Timestamp OPTDAT2TS2 V816 Oracle UNKNOWN Struct DATE=>Struct TIMESTAMP OPTTS2DAT1 V816 Oracle UNKNOWN array TIMESTAMP=>Array DATE OPTTS2DAT2 V816 Oracle UNKNOWN Struct TIMESTAMP=>Struct DATE SESSIONTIMEZONE V816 Oracle DATETYPE SESSIONTIMEZONE OPTNTUB8 V816 Oracle UNKNOWN DTYNUM=>DTYUB8 OPTUB8TN V816 Oracle UNKNOWN DTYUB8=>DTYNUM PERCENT_RANK V816 Oracle NUMERIC Window PERCENT_RANK OPTITZS2A V816 Oracle UNKNOWN TS ITZ Struct=>Array OPTITZA2S V816 Oracle UNKNOWN TS ITZ Array=>Struct OPTITZ2TSTZ V816 Oracle UNKNOWN Struct TSITZ=>Struct TSTZ OPTTSTZ2ITZ V816 Oracle UNKNOWN Struct TSTZ=>Struct TSITZ OPTITZ2TS V816 Oracle UNKNOWN Struct TSITZ=>Struct TS OPTTS2ITZ V816 Oracle UNKNOWN Struct TS=>Struct TSITZ TO_TIME V816 Oracle UNKNOWN TO_TIME TO_TIME_TZ V816 Oracle UNKNOWN TO_TIME_TZ TO_TIMESTAMP V816 Oracle DATETYPE TO_TIMESTAMP NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- TO_TIMESTAMP_TZ V816 Oracle DATETYPE TO_TIMESTAMP_TZ TO_YMINTERVAL V816 Oracle DATETYPE TO_YMINTERVAL TO_DSINTERVAL V816 Oracle DATETYPE TO_DSINTERVAL NUMTOYMINTERVAL V816 Oracle UNKNOWN NUMTOYMINTERVAL NUMTODSINTERVAL V816 Oracle UNKNOWN NUMTODSINTERVAL SYS_EXTRACT_UTC V816 Oracle DATETYPE SYS_EXTRACT_UTC SYS_OP_ITR V816 Oracle UNKNOWN Image TRansformation SYS_OP_BIN2ADT V82 Oracle UNKNOWN BIN=>ADT SYS_OP_DISTINCT V82 Oracle UNKNOWN SYS_OP_DISTINCT OPTSMCSE V82 Oracle UNKNOWN Simple Case Expression NULLIF V82 Oracle ARG 1 NULLIF COALESCE V82 Oracle ARG 1 COALESCE OPTLLEN V82 Oracle NUMERIC LENGTH OPTLLENB V82 Oracle NUMERIC LENGTHB OPTLSBS V82 Oracle UNKNOWN SUBSTR OPTLSBSB V82 Oracle UNKNOWN SUBSTRB OPTLINS V82 Oracle NUMERIC INSTR OPTLINSB V82 Oracle NUMERIC INSTRB OPTLCAT V82 Oracle UNKNOWN || OPTLLPD V82 Oracle UNKNOWN LPAD OPTLRPD V82 Oracle UNKNOWN RPAD NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTLLTR V82 Oracle UNKNOWN LTRIM OPTLRTR V82 Oracle UNKNOWN RTRIM OPTLTRM V82 Oracle UNKNOWN TRIM OPTLLOW V82 Oracle UNKNOWN LOWER OPTLUPR V82 Oracle UNKNOWN UPPER OPTLNLOW V82 Oracle UNKNOWN NLS_LOWER OPTLNUPR V82 Oracle UNKNOWN NLS_UPPER OPTLNVL V82 Oracle UNKNOWN NVL OPTLLIK V82 Oracle UNKNOWN LIKE OPTLNLIK V82 Oracle UNKNOWN NOT LIKE OPTLREPL V82 Oracle UNKNOWN REPLACE SYS_OP_CL2C V82 Oracle UNKNOWN SYS_OP_CL2C SYS_OP_BL2R V82 Oracle UNKNOWN SYS_OP_BL2R PERCENTILE_CONT V82 Oracle NUMERIC PERCENTILE_CONT PERCENTILE_DISC V82 Oracle NUMERIC PERCENTILE_DISC RANK V82 Oracle NUMERIC RANK DENSE_RANK V82 Oracle NUMERIC DENSE_RANK PERCENT_RANK V82 Oracle NUMERIC PERCENT_RANK CUME_DIST V82 Oracle NUMERIC CUME_DIST OPTFSTLST V82 Oracle UNKNOWN First/Last Function OPTAGGOBY V82 Oracle UNKNOWN Pseudo Function for Ordered Aggregates NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- WIDTH_BUCKET V82 Oracle NUMERIC WIDTH_BUCKET RANKM V82 Oracle NUMERIC RANKM DENSE_RANKM V82 Oracle NUMERIC DENSE_RANKM PERCENT_RANKM V82 Oracle NUMERIC PERCENT_RANKM CUME_DISTM V82 Oracle UNKNOWN CUME_DISTM FIRSTM V82 Oracle UNKNOWN FIRSTM PERCENTILE_CONT V82 Oracle NUMERIC PERCENTILE_CONT PERCENTILE_DISC V82 Oracle NUMERIC PERCENTILE_DISC OPTWNFSTLST V82 Oracle UNKNOWN Reporting First/Last SYS_OP_VECOR V82 Oracle UNKNOWN SYS_OP_VECOR SYS_OP_VECXOR V82 Oracle UNKNOWN SYS_OP_VECXOR SYS_OP_VECAND V82 Oracle UNKNOWN SYS_OP_VECAND GROUPING_ID V82 Oracle NUMERIC GROUPING_ID GROUP_ID V82 Oracle NUMERIC GROUP_ID OPTWNUAG V82 Oracle UNKNOWN User-defined Aggregate Window Function SYS_XMLGEN V82 Oracle UNKNOWN SYS_XMLGEN EXTRACT V82 Oracle UNKNOWN EXTRACT SYS_DBURIGEN V82 Oracle UNKNOWN SYS_DBURIGEN TO_CLOB V82 Oracle STRING TO_CLOB TO_NCLOB V82 Oracle STRING TO_NCLOB SYS_MAKEXML V82 Oracle UNKNOWN SYS_MAKEXML NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SYS_UMAKEXML V82 Oracle UNKNOWN SYS_UMAKEXML SYS_XQEXTRREF V82 Oracle UNKNOWN SYS_XQEXTRREF OPTLICSCNVTST V82 Oracle NUMERIC SYS_OP_CSCONVTEST BIN_TO_NUM V82 Oracle NUMERIC BIN_TO_NUM SYS_OP_NUMTORAW V82 Oracle UNKNOWN SYS_OP_NUMTORAW SYS_OP_RAWTONUM V82 Oracle UNKNOWN SYS_OP_RAWTONUM SYS_OP_GROUPING V82 Oracle UNKNOWN SYS_OP_GROUPING OPTCELEM V82 Oracle UNKNOWN Collection ELEMent OPTDOT V82 Oracle UNKNOWN Operator for DOTted Notation SYS_AUDIT V82 Oracle UNKNOWN SYS_AUDIT OPTPCONS V82 Oracle UNKNOWN Polymorphic Constructor OPTUAG V82 Oracle UNKNOWN User-defined Aggregate OPT441 V82 Oracle UNKNOWN Unused OPT442 V82 Oracle UNKNOWN Unused TZ_OFFSET V82 Oracle UNKNOWN TZ_OFFSET ADJ_DATE V82 Oracle UNKNOWN ADJ_DATE OPTUNSED445 V82 Oracle UNKNOWN Unused OPTTFD V82 Oracle UNKNOWN Functional Dependency OPTTFDF V82 Oracle UNKNOWN Functional Dependency Foreign ROWIDTONCHAR V82 Oracle STRING ROWIDTONCHAR TO_NCHAR V82 Oracle STRING TO_NCHAR NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- RAWTONHEX V82 Oracle STRING RAWTONHEX NCHR V82 Oracle STRING NCHR SYS_OP_LBID V82 Oracle UNKNOWN SYS_OP_LBID OPTOP2C V82 Oracle UNKNOWN Opaque Type=>CHAR OPTC2OP V82 Oracle UNKNOWN CHAR=>Opaque Type COMPOSE V82 Oracle STRING COMPOSE DECOMPOSE V82 Oracle STRING DECOMPOSE ASCIISTR V82 Oracle STRING ASCIISTR UNISTR V82 Oracle STRING UNISTR LENGTH2 V82 Oracle NUMERIC LENGTH2 LENGTH4 V82 Oracle NUMERIC LENGTH4 LENGTHC V82 Oracle NUMERIC LENGTHC INSTR2 V82 Oracle NUMERIC INSTR2 INSTR4 V82 Oracle NUMERIC INSTR4 INSTRC V82 Oracle NUMERIC INSTRC SUBSTR2 V82 Oracle STRING SUBSTR2 SUBSTR4 V82 Oracle STRING SUBSTR4 SUBSTRC V82 Oracle STRING SUBSTRC OPTLIK2 V82 Oracle UNKNOWN LIKE2 OPTLIK2N V82 Oracle UNKNOWN NOT LIKE2 OPTLIK2E V82 Oracle UNKNOWN LIKE2 NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- OPTLIK2NE V82 Oracle UNKNOWN NOT LIKE2 OPTLIK4 V82 Oracle UNKNOWN LIKE4 OPTLIK4N V82 Oracle UNKNOWN NOT LIKE4 OPTLIK4E V82 Oracle UNKNOWN LIKE4 OPTLIK4NE V82 Oracle UNKNOWN NOT LIKE4 OPTLIKC V82 Oracle UNKNOWN LIKEC OPTLIKCN V82 Oracle UNKNOWN NOT LIKEC OPTLIKCE V82 Oracle UNKNOWN LIKEC OPTLIKCNE V82 Oracle UNKNOWN NOT LIKEC SYS_OP_VECBIT V82 Oracle UNKNOWN SYS_OP_VECBIT OPTNISTYP V82 Oracle UNKNOWN IS NOT OF TYPE SYS_OP_NICOMBINE V82 Oracle UNKNOWN SYS_OP_NICOMBINE SYS_OP_NIEXTRACT V82 Oracle UNKNOWN SYS_OP_NIEXTRACT SYS_OP_VVD V82 Oracle UNKNOWN SYS_OP_VVD OPTLCNVT V82 Oracle UNKNOWN CONVERT OPTOPASN V82 Oracle UNKNOWN OPaque type ASsign OPTOBY V82 Oracle UNKNOWN Pseudo Function for ORDER BY SYS_XQEXTRACT V82 Oracle UNKNOWN SYS_XQEXTRACT SYS_PXQEXTRACT V82 Oracle UNKNOWN SYS_PXQEXTRACT OPTTREAT V82 Oracle UNKNOWN TREAT OPTISTYPE V82 Oracle UNKNOWN IS OF TYPE NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SYS_TYPEID V82 Oracle UNKNOWN SYS_OP_MST SYS_OP_ADT2BIN V82 Oracle UNKNOWN ADT=>BIN OPTXMLELEMENT V92 Oracle UNKNOWN XMLELEMENT SYS_XMLANALYZE V92 Oracle UNKNOWN REWRITEANALYS OPTXMLCOLELEM V92 Oracle UNKNOWN XMLFOREST UPDATEXML V92 Oracle UNKNOWN UPDATEXML EXISTSNODE V92 Oracle UNKNOWN EXISTSNODE EXTRACTVALUE V92 Oracle UNKNOWN EXTRACTVALUE XMLTRANSFORM V92 Oracle UNKNOWN XMLTRANSFORM TO_BLOB V92 Oracle UNKNOWN TO_BLOB OPTXMLPARSE V92 Oracle UNKNOWN XMLPARSE SYS_XMLCONV V92 Oracle UNKNOWN SYS_XMLCONV SYS_OP_PAR V92 Oracle UNKNOWN SYS_OP_PAR SYS_OP_PARGID V92 Oracle UNKNOWN SYS_OP_PARGID SYS_OP_LVL V92 Oracle UNKNOWN SYS_OP_LVL SYS_OP_COUNTCHG V92 Oracle NUMERIC SYS_OP_COUNTCHG XMLISVALID V92 Oracle UNKNOWN XMLISVALID SYS_DOM_COMPARE V92 Oracle UNKNOWN SYS_DOM_COMPARE XMLCONCAT V92 Oracle UNKNOWN XMLCONCAT SYS_OP_ALSCRVAL V92 Oracle UNKNOWN SYS_OP_ALEXPCOL OPTALANYCONS V92 Oracle UNKNOWN Anydata-LOB: Anydata Constructor NAME VERSION DATATYPE DESCR ------------------------------ ------------ -------- -------------------------------------------------------------------------------- SYS_OP_CONVERT V92 Oracle UNKNOWN SYS_OP_CONVERT OPTLICONVERT V92 Oracle UNKNOWN SYS_OP_CONVERT SYS_OP_PAR_1 V92 Oracle UNKNOWN SYS_OP_PAR SYS_OP_PARGID_1 V92 Oracle UNKNOWN SYS_OP_PARGID SYS_CHECKACL V92 Oracle UNKNOWN SYS_CHECKACL SYS_XQCONCAT V92 Oracle UNKNOWN SYS_XQCONCAT XMLISNODE V92 Oracle UNKNOWN XMLISNODE SYS_XQEXVAL V92 Oracle UNKNOWN SYS_XQEXVAL SYS_XQSEQ2CON V92 Oracle UNKNOWN SYS_XQSEQ2CON SYS_XQCON2SEQ V92 Oracle UNKNOWN SYS_XQCON2SEQ SYS_XQFNBOOL V92 Oracle UNKNOWN SYS_XQFNBOOL SYS_XMLEXNSURI V92 Oracle UNKNOWN SYS_XMLEXNSURI SYS_XQFNLNAME V92 Oracle UNKNOWN SYS_XQFNLNAME SYS_XQFNNSURI V92 Oracle UNKNOWN SYS_XQFNNSURI SYS_XQFNPREDTRUTH V92 Oracle UNKNOWN SYS_XQFNPREDTRUTH SYS_OP_CSCONVTEST V92 Oracle NUMERIC SYS_OP_CSCONVTEST SYS_OP_CSCONV V92 Oracle UNKNOWN SYS_OP_CSCONV OPTLICSCNV V92 Oracle UNKNOWN SYS_OP_CSCONV OPTXMLCOLATTVAL V92 Oracle UNKNOWN XMLCOLATTVAL 921 rows selected
posted on 2009-06-16 09:13 Oracle和MySQL 阅读(514) 评论(0) 编辑 收藏 举报
