Oracle/SQL2012. 4. 12. 00:13

์—ฐ์†๋œ ๊ณต๋ฐฑ์„ ํ•˜๋‚˜์˜ ๊ณต๋ฐฑ์œผ๋กœ ๋ณ€๊ฒฝ

์—ฐ์†๋œ ๊ณต๋ฐฑ์„ ํ•˜๋‚˜์˜ ๊ณต๋ฐฑ์œผ๋กœ ๋ณ€๊ฒฝํ•ด๋ณด์ž.


10.1 ์ด์ „ ๋ฒ„์ „์€ ์•„๋ž˜์™€ ๊ฐ™์ด REPLACE ํ•จ์ˆ˜๋ฅผ 3๋ฒˆ ์‚ฌ์šฉํ•ด์•ผ ํ•œ๋‹ค.

 -- 1
SELECT REPLACE (c1, ' ', '! ') AS c1
     , REPLACE (REPLACE (c1, ' ', '! '), ' !') AS c2
     , REPLACE (REPLACE (REPLACE (c1, ' ', '! '), ' !'), '!') AS c3
  FROM (SELECT '1 2  3   4    5     ' AS c1 FROM DUAL);

C1                                  C2              C3        
----------------------------------- --------------- ----------
1! 2! ! 3! ! ! 4! ! ! ! 5! ! ! ! !  1! 2! 3! 4! 5!  1 2 3 4 5 

1๊ฐœ์˜ ํ–‰์ด ์„ ํƒ๋˜์—ˆ์Šต๋‹ˆ๋‹ค.


10.1 ๋ฒ„์ „๋ถ€ํ„ฐ REGEXP_REPLACE ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋‹ค. 

-- 2
SELECT REGEXP_REPLACE ('1 2  3   4    5     ', ' +', ' ') AS c1
  FROM DUAL;

C1
----------
1 2 3 4 5 

1๊ฐœ์˜ ํ–‰์ด ์„ ํƒ๋˜์—ˆ์Šต๋‹ˆ๋‹ค.


'Oracle > SQL' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

์ฃผ๋ฏผ๋“ฑ๋ก๋ฒˆํ˜ธ ๋งˆ์Šคํ‚น  (0) 2012.04.30
๋‹ค์ค‘ ํ–‰์„ ๋ฌธ์ž์—ด๋กœ ์ง‘๊ณ„  (0) 2012.04.16
๊ตฌ๋ถ„์ž ํฌํ•จ ๊ฐ’์„ ํ–‰์œผ๋กœ ๋ถ„๋ฆฌ  (0) 2012.04.13
์—ฐ์† ์ƒ์Šน ๊ตฌ๊ฐ„ ์กฐํšŒ  (0) 2012.04.10
์  ์ด๋ ฅ์„ ์„ ๋ถ„ ์ด๋ ฅ์œผ๋กœ ์ „ํ™˜  (0) 2012.04.09
Posted by ์ •ํฌ๋ฝ_

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”