컬럼의 특정 문자열 치환

UPDATE tb_rising_item_kospi 
SET    row_id = REPLACE(row_id, '20170101', '20170622')

tb_rising_item_kospi 테이블의 row_id 컬럼에 있는 '20170101' 값을 '20170622'로 수정.

WITH BASE AS 
(
    SELECT  '20170101' AS COLUMN1
    FROM DUAL
)

SELECT  REPLACE(COLUMN1, '20170101', '20170102') AS REPLACE_COLUMN
FROM    BASE