Moin

CREATE VIEW lhc_format AS SELECT * FROM
(SELECT CAST(RowNr AS NUMBER(6)) AS RowNr
,CAST(RD AS CHAR(2)) AS RD
,CAST(RA AS CHAR(2)) AS RA
,CAST(CD AS CHAR(2)) AS CD
,CAST(CA AS CHAR(2)) AS CA
,CAST(AL AS CHAR(2)) AS AL
,CAST(FNR AS VARCHAR2(7)) AS FNR
,CAST(SNR AS NUMBER(1)) AS SNR
,CAST(DEP AS CHAR(3)) AS DEP
,CAST(ARR AS CHAR(3)) AS ARR
,CAST(STD AS NUMBER(4)) AS STD
,CAST(DDC AS NUMBER(1)) AS DDC
,CAST(STA AS NUMBER(4)) AS STA
,CAST(ADC AS NUMBER(1)) AS ADC
,CAST(Mo AS NUMBER(1)) AS Mo
,CAST(Tu AS NUMBER(1)) AS Tu
,CAST(We AS NUMBER(1)) AS We
,CAST(Th AS NUMBER(1)) AS Th
,CAST(Fr AS NUMBER(1)) AS Fr
,CAST(Sa AS NUMBER(1)) AS Sa
,CAST(So AS NUMBER(1)) AS So
,CAST(ACtype AS VARCHAR2(3)) AS ACtype
,CAST(ACtypefullname AS VARCHAR2(50)) AS ACtypefullname
,CAST(AG AS CHAR(1)) AS AG
,CAST(AGfullname AS VARCHAR2(10)) AS AGfullname
,CAST(Start_Op AS DATE) AS Start_Op
,CAST(End_Op AS DATE) AS End_Op
,NVL(TO_CHAR(mo),'')
||NVL(TO_CHAR(tu),'')
||NVL(TO_CHAR(we),'')
||NVL(TO_CHAR(th),'')
||NVL(TO_CHAR(fr),'')
||NVL(TO_CHAR(sa),'')
||NVL(TO_CHAR(so),'') AS Operating_Days
FROM lhc_raw);