WITH temp AS (
SELECT '168.188.1.0' ip FROM DUAL UNION ALL
SELECT '10.0.0.1' FROM DUAL UNION ALL
SELECT '211.254.1.1' FROM DUAL
)
SELECT 'xxx' || substr(ip, instr(ip, '.')) from temp;
by 김귀염
[2018.02.06 10:28:29]
너무 감사합니다. 도움이 됬어요
by 우리집아찌
[2018.02.06 10:22:27]
WITH T AS (
SELECT '168.188.1.0' IP FROM DUAL UNION ALL
SELECT '10.0.0.1' IP FROM DUAL UNION ALL
SELECT '211.254.1.1' IP FROM DUAL
)
SELECT REGEXP_REPLACE( IP , '^[^.]+' , 'XXX' ) COVERT_IP
FROM T
by 김귀염
[2018.02.06 10:28:40]
정규표현식으로 하면 이런 방법도 있었군요
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.