自定义table :create or replace type type_channel_table as table of type_channel;
自定义object:create or replace type type_channel as object (
id varchar2(10) ,
channelid number(10),
pv varchar2(10),
uv varchar2(10),
currentTime date,
advTitle varchar2(200),
areacode number(10),
areaname varchar2(20),
starttime date,
endtime date,
AdvertisementChannelName varchar2(200),
SecondChannelCode varchar2(10),
SecondChannelName varchar2(200),
FirstChannelCode varchar2(10),
FirstChannelName varchar2(200)
)
定义函数:create or replace function YJMT_T_GETALLCHANNELINFO return type_channel_table is----
使用方法:select * from table(YJMT_T_GETALLCHANNELINFO )