Database/Oracle
[Oracle] like 문 바인드 변수 적용법
codewar
2010. 4. 28. 16:28
SELECT EAS220_DOC_SEQ,
EAS220_DOC_NO,
EAS220_FORM_CD,
EAS220_TITLE,
to_char(EAS220_MADE_DT, 'yyyy-mm-dd')EAS220_MADE_DT,
EAS220_MAKER_NM,
EAS200_NM_KOR,
COM020_DOMINO_NM_KOR,
EAS220_DEPT_CD,
EAS220_OWNER_ID
FROM EAS200TL ,EAS220TL ,COM020TL
WHERE EAS220_DOC_DIV = EAS200_CODE
AND EAS220_DEPT_CD = COM020_DOMINO_DPT_CD
AND EAS220_APP_DIV != 'D'
AND EAS220_DOC_NO LIKE '%' || ? || '%' AND EAS220_YEAR = ?
EAS220_DOC_NO,
EAS220_FORM_CD,
EAS220_TITLE,
to_char(EAS220_MADE_DT, 'yyyy-mm-dd')EAS220_MADE_DT,
EAS220_MAKER_NM,
EAS200_NM_KOR,
COM020_DOMINO_NM_KOR,
EAS220_DEPT_CD,
EAS220_OWNER_ID
FROM EAS200TL ,EAS220TL ,COM020TL
WHERE EAS220_DOC_DIV = EAS200_CODE
AND EAS220_DEPT_CD = COM020_DOMINO_DPT_CD
AND EAS220_APP_DIV != 'D'
AND EAS220_DOC_NO LIKE '%' || ? || '%' AND EAS220_YEAR = ?