55555

select a.c_port_code, a.c_port_name, to_char(A1.D_ASTSTAT,'yyyy-mm-dd') D_ASTSTAT, CASE WHEN A.C_DAT_CODE in ('ASS_FOF','ASS_QDII') THEN NVL(A11.DWJZ, ......