일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 | 31 |
- switch
- php
- 날짜
- java
- maven
- Oracle
- JSTL
- 오라클
- exception
- 네이버스마트 에디터
- 전자정부 표준프레임워크
- 한글
- null
- SSL
- MYSQL
- 호환성
- jquery
- @RequestBody
- 문자열
- checbox
- HTML5
- DB
- 스크립트
- 이클립스
- html
- spring form tag
- 웹 플랫폼 설치 관리자
- json
- RADIO
- 톰캣
- Today
- Total
개인적인 정리
[Oracle]REPLACE() 본문
오라클 REPLACE
REPLACE()
-
REPLACE(char, search_string)
REPLACE(char, search_string, replacement_string)
의 형태
REPLACE returns char with every occurence of search_string replaced with replacement_string. If replacement_string is omitted or null, then all occurence of search_string are removed. If search_string is null, then char is returned.
Both search_string and replacement_string, as well as char, can be any of the data types CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The string returned is in the same character set as char. The function returns VARCHAR2 if the first argument is not a LOB and returns CLOB if the first argument is a LOB.
REPLACE provides functionality related to that provided by the TRANSLATE function. TRANSLATE provides single-character, one-to-one substitution. REPLACE lets you substitute one string for another as well as remove character strings.
SQL> SELECT REPLACE('JACK and JUE', 'J', 'BL') FROM DUAL ;
--> BLACK and BLUE
'DB > ORACLE' 카테고리의 다른 글
[Oracle]RPAD() (0) | 2020.06.11 |
---|---|
[Oracle]ROW_NUMBER() (0) | 2020.06.11 |
[Oracle]ROUND(number) (0) | 2020.06.10 |
[Oracle]ROUND(date) (0) | 2020.06.10 |
[Oracle]REMAINDER() (0) | 2020.06.10 |
[Oracle]REGEXP_SUBSTR() (0) | 2020.06.08 |
[Oracle]REGEXP_REPLACE() (0) | 2020.06.08 |
[Oracle] REGEXP_INSTR() (0) | 2020.04.21 |