CREATE TYPE BaseObj AS OBJECT (
id NUMBER(6),
value number(6)
NOT FINAL;
/CREATE TYPE Obj1 UNDER BaseObj (
);
/
Create Table T_Obj1 of Obj1 (Primary Key (id))
/CREATE TYPE Obj2 UNDER BaseObj (
);
/
Create Table T_Obj2 of Obj2 (Primary Key (id))
/现想把所有继承自BaseObj的按value的值排序,这个查询应该怎么写?谢谢!
id NUMBER(6),
value number(6)
NOT FINAL;
/CREATE TYPE Obj1 UNDER BaseObj (
);
/
Create Table T_Obj1 of Obj1 (Primary Key (id))
/CREATE TYPE Obj2 UNDER BaseObj (
);
/
Create Table T_Obj2 of Obj2 (Primary Key (id))
/现想把所有继承自BaseObj的按value的值排序,这个查询应该怎么写?谢谢!
select * from t_obj1 t order by t.value;
我是想把obj1和obj2的联起来查然后用value排序,不知道怎么弄。
SELECT * FROM t_obj1
UNION
SELECT * FROM t_obj2;