Oracle 函数返回记录类型自定义类型create type row_type as object(org_id varhcar2(20));create type table_type as table of row_type;返回记录函数create or replace function get_org_record(in_org_id varchar2) return table_type pipelined as v row_type;begin for r in
摘要由CSDN通过智能技术生成
Oracle 函数返回记录类型(表类型)
自定义类型
createtype row_type as object(org_id varhcar2(20));createtype table_type astableof row_type;
Oracle 函数返回记录类型自定义类型create type row_type as object(org_id varhcar2(20));create type table_type as table of row_type;返回记录函数create or replace function get_org_record(in_org_id varchar2) return table_type pipelined as v row_type;begin for r in