[Oracle] like 문 바인드 변수 적용법
2010. 4. 28. 16:28ㆍDatabase/Oracle
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 = ?
'Database > Oracle' 카테고리의 다른 글
[Oracle] 오라클 Imp할 때 테이블 스페이스 변경해서 올리기 (0) | 2010.05.26 |
---|---|
[Oracle] substr 함수 (0) | 2010.04.28 |
[Oracle] <> != 는 같은 표현식 (1) | 2010.04.28 |
[Oracle] 1. 유저 권한 grant 하기 2. synonym 하기 (0) | 2010.04.28 |
[Oracle] 오라클 칼럼 추가 , 삭제 예제 (0) | 2010.04.28 |