총 4가지
WHERE REGEXP_LIKE(first_name, '^Ste(v|ph)en$')
REGEXP_REPLACE(country_name, '(.)', '\1 ')
REGEXP_INSTR(email, '\w+@\w+(\.\w+)+') > 0
REGEXP_SUBSTR('oracle', 'o r a c l e', 1, 1, 'x')
예) MODULE_SSO.getLoginName() 함수에서 파라미터 값이 있는 넘을 찾을때
WITH temp_t AS (
SELECT 'ts, MODULE_SSO.getLoginName()' AS jscript FROM DUAL
UNION ALL
SELECT 'ts, MODULE_SSO.getLoginName(id)' AS jscript FROM DUAL
)
SELECT * FROM temp_t WHERE REGEXP_INSTR(jscript, 'MODULE_SSO\.getLoginName\(.+\)') > 0
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_regexp.htm#ADFNS1003 (New Window)
WHERE REGEXP_LIKE(first_name, '^Ste(v|ph)en$')
REGEXP_REPLACE(country_name, '(.)', '\1 ')
REGEXP_INSTR(email, '\w+@\w+(\.\w+)+') > 0
REGEXP_SUBSTR('oracle', 'o r a c l e', 1, 1, 'x')
예) MODULE_SSO.getLoginName() 함수에서 파라미터 값이 있는 넘을 찾을때
WITH temp_t AS (
SELECT 'ts, MODULE_SSO.getLoginName()' AS jscript FROM DUAL
UNION ALL
SELECT 'ts, MODULE_SSO.getLoginName(id)' AS jscript FROM DUAL
)
SELECT * FROM temp_t WHERE REGEXP_INSTR(jscript, 'MODULE_SSO\.getLoginName\(.+\)') > 0
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_regexp.htm#ADFNS1003 (New Window)
TAG regular
View Comments,
Trackbacks
댓글을 달아 주세요