今天重新测试了一下,可以支持子类插入(算是支持泛型?),但如何取出这个子类的属性? 哪位大神指导下。
drop table tab1;
drop type obj_real;
drop type obj_ref;
drop type obj_base;
CREATE OR REPLACE TYPE obj_base AS OBJECT (
col1 varchar2(100)
) not final NOT INSTANTIABLE;
create or replace type obj_real under obj_base(col2 varchar2(100));
create or replace type obj_ref as object(col1 obj_base);
create table tab1 of obj_ref;
insert into tab1(col1) values(obj_real('test1','test2'));
selet * from tab1,只能取出obj_base