Oracle anydata数据类型:
SQL> CONN TEST/TEST
已连接。
SQL> DESC ANYDATA
METHOD
------
STATIC FUNCTION CONVERTNUMBER RETURNS ANYDATA
参数名称 类型 输入/输出默认值?
------------------------------ ----------------------- ------ --------
NUM NUMBER IN
............
METHOD
------
MEMBER FUNCTION ACCESSBDOUBLE RETURNS BINARY_DOUBLE
METHOD
------
MEMBER FUNCTION ACCESSUROWID RETURNS ROWID
SQL> COL OBJECT_NAME FOR A30
SQL> SELECT object_name, object_type
2 FROM dba_objects
3 WHERE object_name like '%ANY%'
4* AND wner = 'SYS';
OBJECT_NAME OBJECT_TYPE
-----------------------------