oracle中数据的行列转秩
create table colandrow (tid varchar2(10),
tdate date,
tname varchar2(50),
tmoney number(10,2)
)
insert into colandrow values('1',to_date('2008-1-12','yyyy-mm-dd'),'sun',100);
insert into colandrow values('2',to_date('2008-1-12','yyyy-mm-dd'),'张', 100);
insert into colandrow values('3',to_date('2008-1-13','yyyy-mm-dd'), 'sun', 100);
insert into colandrow values('4',to_date('2008-1-19','yyyy-mm-dd'), '张', 300);
insert into colandrow values('5',to_date('2008-2-12','yyyy-mm-dd') ,'sun', 120);
insert into colandrow values('6',to_date('2008-2-19','yyyy-mm-dd') ,'张' ,300);
insert into colandrow values('7',to_date('2008-3-12','yyyy-mm-dd') ,'sun', 130);
页:
[1]