ORACLE (PL/SQL) REPLACE 用法

REPLACE(字串 or COLUMN,字符 or 字串,替代字符 or 替代字串)

EX：
REPLACE( ' &a&b&c&d& ' , ' & ' , ' * ' )

→ *a*b*c*d*



TABLE
COLUMN_A → &a&b&c&d
COLUMN_B → *a*b*c*d
  
SELECT REPLACE ( COLUMN_A , ' & ' , ' ^ ' ) AS CLUMN_1 ,
               REPLACE ( COLUMN_B , ' * ' , ' ^ ' ) AS CLUMN_2 FROM TABLE

COLUMN_1 → ^a^b^c^d
COLUMN_2 → ^a^b^c^d