create table AA
(
al VARCHAR2(100),
ssl VARCHAR2(100),
qlj VARCHAR2(100),
ssr VARCHAR2(100),
as_of_date DATE
)
create or replace VIEW aa_v as
select
as_of_date,
al,
title,
amt
from aa t
unpivot(amt for title IN(
SSL,
QLJ,
SSR))
select * from AA
select * from AA_V t