LISTING 3: Using the ANYDATA Datatype

SQL> create table t(x sys.anyData);
Table created.


SQL> insert into t values(sys.anyData.convertNumber(5));
SQL> insert into t values(sys.anyData.convertDate(sysdate));
SQL> insert into t values(sys.anyData.convertVarchar2('hello world'));