eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TYPE: SYS.ANYDATASET

Object Details

Object Name:	ANYDATASET
Object Type:	TYPE
Owner:	SYS
Subobject Name:
Status:	VALID

Type Details

Type Code:	ANYDATASET
Predefined:	NO
Incomplete:	NO

Methods

Name	Parameters	Result
BEGINCREATE	TYPECODE(PL/SQL PLS INTEGER) RTYPE(ANYTYPE) ASET(ANYDATASET)
ADDINSTANCE	SELF(ANYDATASET)
PIECEWISE	SELF(ANYDATASET)
SETNUMBER	SELF(ANYDATASET) NUM(NUMBER) LAST_ELEM(PL/SQL BOOLEAN)
SETDATE	SELF(ANYDATASET) DAT(DATE) LAST_ELEM(PL/SQL BOOLEAN)
SETCHAR	SELF(ANYDATASET) C(CHAR) LAST_ELEM(PL/SQL BOOLEAN)
SETVARCHAR	SELF(ANYDATASET) C(VARCHAR2) LAST_ELEM(PL/SQL BOOLEAN)
SETVARCHAR2	SELF(ANYDATASET) C(VARCHAR2) LAST_ELEM(PL/SQL BOOLEAN)
SETRAW	SELF(ANYDATASET) R(RAW) LAST_ELEM(PL/SQL BOOLEAN)
SETBLOB	SELF(ANYDATASET) B(BLOB) LAST_ELEM(PL/SQL BOOLEAN)
SETCLOB	SELF(ANYDATASET) C(CLOB) LAST_ELEM(PL/SQL BOOLEAN)
SETBFILE	SELF(ANYDATASET) B(BFILE) LAST_ELEM(PL/SQL BOOLEAN)
SETOBJECT	SELF(ANYDATASET) OBJ(PL/SQL LONG RAW) LAST_ELEM(PL/SQL BOOLEAN)
SETOBJECT	SELF(ANYDATASET) OBJ(PL/SQL LONG RAW) LAST_ELEM(PL/SQL BOOLEAN)
SETREF	SELF(ANYDATASET) RF(PL/SQL LONG RAW) LAST_ELEM(PL/SQL BOOLEAN)
SETCOLLECTION	SELF(ANYDATASET) COL(PL/SQL LONG RAW) LAST_ELEM(PL/SQL BOOLEAN)
ENDCREATE	SELF(ANYDATASET)
GETTYPENAME	SELF(ANYDATASET)	VARCHAR2
GETTYPE	SELF(ANYDATASET) TYP(ANYTYPE)	PL/SQL PLS INTEGER
GETINSTANCE	SELF(ANYDATASET)	PL/SQL PLS INTEGER
GETNUMBER	SELF(ANYDATASET) NUM(NUMBER)	PL/SQL PLS INTEGER
GETDATE	SELF(ANYDATASET) DAT(DATE)	PL/SQL PLS INTEGER
GETCHAR	SELF(ANYDATASET) C(CHAR)	PL/SQL PLS INTEGER
GETVARCHAR	SELF(ANYDATASET) C(VARCHAR2)	PL/SQL PLS INTEGER
GETVARCHAR2	SELF(ANYDATASET) C(VARCHAR2)	PL/SQL PLS INTEGER
GETRAW	SELF(ANYDATASET) R(RAW)	PL/SQL PLS INTEGER
GETBLOB	SELF(ANYDATASET) B(BLOB)	PL/SQL PLS INTEGER
GETCLOB	SELF(ANYDATASET) C(CLOB)	PL/SQL PLS INTEGER
GETBFILE	SELF(ANYDATASET) B(BFILE)	PL/SQL PLS INTEGER
GETOBJECT	SELF(ANYDATASET) OBJ(PL/SQL LONG RAW)	PL/SQL PLS INTEGER
GETOBJECT	SELF(ANYDATASET) OBJ(PL/SQL LONG RAW)	PL/SQL PLS INTEGER
GETREF	SELF(ANYDATASET) RF(PL/SQL LONG RAW)	PL/SQL PLS INTEGER
GETCOLLECTION	SELF(ANYDATASET) COL(PL/SQL LONG RAW)	PL/SQL PLS INTEGER
GETCOUNT	SELF(ANYDATASET)	PL/SQL PLS INTEGER
SETTIMESTAMP	SELF(ANYDATASET) TS(TIMESTAMP) LAST_ELEM(PL/SQL BOOLEAN)
SETTIMESTAMPTZ	SELF(ANYDATASET) TS(TIMESTAMP WITH TZ) LAST_ELEM(PL/SQL BOOLEAN)
SETTIMESTAMPLTZ	SELF(ANYDATASET) TS(TIMESTAMP WITH LOCAL TZ) LAST_ELEM(PL/SQL BOOLEAN)
SETINTERVALYM	SELF(ANYDATASET) INV(INTERVAL YEAR TO MONTH) LAST_ELEM(PL/SQL BOOLEAN)
SETINTERVALDS	SELF(ANYDATASET) INV(INTERVAL DAY TO SECOND) LAST_ELEM(PL/SQL BOOLEAN)
SETNCHAR	SELF(ANYDATASET) NC(NCHAR) LAST_ELEM(PL/SQL BOOLEAN)
SETNVARCHAR2	SELF(ANYDATASET) NC(NVARCHAR2) LAST_ELEM(PL/SQL BOOLEAN)
SETNCLOB	SELF(ANYDATASET) NC(NCLOB) LAST_ELEM(PL/SQL BOOLEAN)
GETTIMESTAMP	SELF(ANYDATASET) TS(TIMESTAMP)	PL/SQL PLS INTEGER
GETTIMESTAMPTZ	SELF(ANYDATASET) TS(TIMESTAMP WITH TZ)	PL/SQL PLS INTEGER
GETTIMESTAMPLTZ	SELF(ANYDATASET) TS(TIMESTAMP WITH LOCAL TZ)	PL/SQL PLS INTEGER
GETINTERVALYM	SELF(ANYDATASET) INV(INTERVAL YEAR TO MONTH)	PL/SQL PLS INTEGER
GETINTERVALDS	SELF(ANYDATASET) INV(INTERVAL DAY TO SECOND)	PL/SQL PLS INTEGER
GETNCHAR	SELF(ANYDATASET) NC(NCHAR)	PL/SQL PLS INTEGER
GETNVARCHAR2	SELF(ANYDATASET) NC(NVARCHAR2)	PL/SQL PLS INTEGER
GETNCLOB	SELF(ANYDATASET) NC(NCLOB)	PL/SQL PLS INTEGER
SETBFLOAT	SELF(ANYDATASET) FL(BINARY_FLOAT) LAST_ELEM(PL/SQL BOOLEAN)
SETBDOUBLE	SELF(ANYDATASET) DBL(BINARY_DOUBLE) LAST_ELEM(PL/SQL BOOLEAN)
SETUROWID	SELF(ANYDATASET) RID(UROWID) LAST_ELEM(PL/SQL BOOLEAN)
GETBFLOAT	SELF(ANYDATASET) FL(BINARY_FLOAT)	PL/SQL PLS INTEGER
GETBDOUBLE	SELF(ANYDATASET) DBL(BINARY_DOUBLE)	PL/SQL PLS INTEGER
GETUROWID	SELF(ANYDATASET) RID(UROWID)	PL/SQL PLS INTEGER

Dependencies

[top of page]

SYS.ANYDATASET references the following:

SYS: ANYTYPE; DBMS_ANYDATASET_LIB; STANDARD - show dependent code

SYS.ANYDATASET is referenced by following:

MDSYS: POINTINPOLYGON_IMP_T; POINTINPOLYGON_IMP_T; SDO_POINTINPOLYGON
PUBLIC: ANYDATASET
SYS: ANYDATASET; CUBE_TABLE; DBMS_FREQUENT_ITEMSET - show dependent code; OLAPRANCURIMPL_T; OLAPRC_TABLE; OLAP_TABLE; SYS_NT_COLLECT; SYS_NT_COLLECT_IMP