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))