WITH t AS
(
SELECT 'aaa' v FROM dual
UNION ALL SELECT 'aAa' FROM dual
UNION ALL SELECT 'bcd' FROM dual
)
SELECT v
FROM t
-- WHERE UPPER(v) LIKE UPPER('%aA%')
-- WHERE LOWER(v) LIKE LOWER('%aA%')
-- WHERE REGEXP_LIKE(v, 'aA', 'i')
;
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.