查询表中VARRAY数据
示例
sql
--查询udt整体:
SELECT id, udt_varryofobj FROM varry_tab;
//查询结果
ID | UDT_VARRYOFOBJ |
------------------------------------------------------------------------------
2 | [[1,2层,udt_obj_type,2021-08-24 00:00:00],[1,2层,udt_obj_type,2021-08-24 00:00:00]]|
2 | [[1,2层,udt_obj_type,2021-08-24 00:00:00],[1,2层,udt_obj_type,2021-08-24 00:00:00]]|
SELECT udt_varryofobj_type(
udt_obj_type(
1.0,'2层','udt_obj_type','2021-08-24 00:00:00') ,
udt_obj_type(
1.0,'2层','udt_obj_type','2021-08-24 00:00:00') )
FROM DUAL;
//查询结果
EXPR1 |
------------------------------------------------------------------------------
[[1,2层,udt_obj_type,2021-08-24 00:00:00],[1,2层,udt_obj_type,2021-08-24 00:00:00]]|
--查询udt的部分属性:
SELECT udt_varryofobj(1) ,udt_varryofobj(2) FROM varry_tab;
//查询结果
EXPR1 | EXPR2 |
------------------------------------------------------------------------------
[1,2层,udt_obj_type,2021-08-24 00:00:00]| [1,2层,udt_obj_type,2021-08-24 00:00:00]|
[1,2层,udt_obj_type,2021-08-24 00:00:00]| [1,2层,udt_obj_type,2021-08-24 00:00:00]|