Devart Forums

Code: Select all

CREATE TABLE ANYDATA_TEST
(
  NUM_COL      NUMBER,
  VC_COL       VARCHAR2(100),
  ANYDATA_COL  SYS.ANYDATA
);

insert into anydata_test
(num_col, vc_col, anydata_col)
values
(1, '1', SYS.ANYDATA.convertVarchar2('test'));

insert into anydata_test
(num_col, vc_col, anydata_col)
values
(2, '2', SYS.ANYDATA.convertNumber(2));

insert into anydata_test
(num_col, vc_col, anydata_col)
values
(3, '3', SYS.ANYDATA.convertDate(sysdate));

commit;

Code: Select all

select a.rowid, a.*
from anydata_test a