[오라클] oracle | REPLACE

 

[오라클] oracle | replace

- SQL Language Reference

 

REPLACE(char, search_string, replacement_string)

 

[Oracle Database SQL Language Reference]

https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions153.htm#SQLRF00697

---

 

[Oracle 11g] 테스트 예제 1)

SELECT REPLACE('AaBbCc', 'A', 'D') AS CHANGE
  FROM DUAL

테스트 결과 1)

CHANGE

----------

DaBbCc

---

[Oracle 11g] 테스트 예제 2)

SELECT REPLACE('AaBbCc', 'a', 'D') AS CHANGE
  FROM DUAL

테스트 결과 2)

CHANGE

----------

ADBbCc

---

2021.07.06 신규

2021.07.08 수정 - 오라클 문서 URL 추가