SELECT A.DV_CD
, A.BU_CD
, A.MEM_SEQ
, A.MEM_NM
, SUBSTR('$WORK_DAY',1,6)||LPAD(TO_CHAR(B.WORK_DAY),2,'0') AS WORK_DAY
, A.DUTY_CD
FROM MMEMBERTB A,
( SELECT ROWNUM AS WORK_DAY FROM TAB
WHERE ROWNUM BETWEEN 1 AND TO_NUMBER( TO_CHAR(LAST_DAY(TO_DATE('$WORK_DAY','YYYYMMDD')), 'DD') )
) B -- 임의로 1일부터 월최종일 까지를 추출한다.
WHERE A.DV_CD ='$_Z[dv_cd]'
AND A.MEM_SEQ ='$MEM_SEQ'
|
|
|
