17,140
社区成员




create or replace view aaa as
(select cid,'data001' datatype,data001 datas,sendtime from ta
union all
select cid,'data002',data002,sendtime from ta
union all
select cid,'data003',data003,sendtime from ta
union all
select cid,'data004',data004,sendtime from ta);
select cid,'data001',data001,sendtime from ta
union all
select cid,'data002',data002,sendtime from ta
union all
select cid,'data003',data003,sendtime from ta
union all
select cid,'data004',data004,sendtime from ta