In Oracle database SYS.ANYDATA can be used as a generic datatype
that can be used to represent any datatype as shown in the
example below. A table can have a column with a datatype of
SYS.ANYDATA and can be used to store dates, VARCHAR2, number,
BLOB
and
CLOB.
Note: UNION ALL has to be used to avoid the ORA-22950 error (cannot ORDER objects without MAP or ORDER method)
Oracle registered trademark of Oracle Corporation.