Skip to content

查询表中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]|