ANYDATA is a new data type introduced with Oracle 9i. As the name implies, it allows the user to store values of any data type (Oracle Defined/User defined) in it.
ANYDATA data type, could be used for defining a column in Database Table or to declare a variable in PL/SQL block.
EX:
CREATE TABLE tab_anydata (id ANYDATA);
PL/SQL Block:
DECLARE
v_any ANYDATA;
BEGIN
NULL;
END;
Built-ins to work with ANYDATA.
- convertXXXX
- accessXXXX
- getXXXX
- getTypeName
- getType
You will come to learn about the above specified built-ins in my succeeding articles on ANYDATA data type.
Key: ORACLE, ANYDATA, 9i New Features, Generic Data Types
