record类型,是否可以当成表一样查询
record类型,是否可以当成表一样查询:
如
TYPE t_Onlnbl_impivt IS RECORD(
brchno varchar2(12) null,
itemcd varchar2(15) null,
onlnbl numeric(19,2) null,
messag varchar2(100)null
);
TYPE Collection_s IS TABLE OF t_Onlnbl_impivt;
l_Onlnbl_impivt Collection_s;
将l_Onlnbl_impivt 赋值以后,
能否把该类型当成一个表进行group by
如select brchno,itmecd,sum(onlnbl) from l_Onlnbl_impivt group by brchno,itmecd 进行汇总与联合查询等操作。不想建立临时表,临时太麻烦了,太多了。