POSIX BRE( Basic Regular Expression )
- ^
- $
- .
- *
- \
- (
- {
- [
3. . ( Period )
구문 ( Syntax )
<period> ::= .
설명 ( Description )
- 임의의 한 문자를 의미한다.
- newline 문자( ASCII(10)인 Line Feed(\n) ), NULL은 매칭하지 않는다.
예제 ( Examples )
SQL> SELECT REGEXP_SUBSTR( 'A', '.' ) AS RESULT FROM DUAL; RESULT -------------------- A SQL> SELECT REGEXP_SUBSTR( 'a', '.' ) AS RESULT FROM DUAL; RESULT -------------------- a SQL> SELECT REGEXP_SUBSTR( '7', '.' ) AS RESULT FROM DUAL; RESULT -------------------- 7 SQL> SELECT REGEXP_SUBSTR( '%', '.' ) AS RESULT FROM DUAL; RESULT -------------------- % SQL> SELECT REGEXP_SUBSTR( '_', '.' ) AS RESULT FROM DUAL; RESULT -------------------- _ SQL> SELECT REGEXP_SUBSTR( CHR(10), '.' ) AS RESULT FROM DUAL; RESULT -------------------- NULL SQL> SELECT REGEXP_COUNT( CHR(10), '.' ) AS RESULT FROM DUAL; RESULT ---------- 0 SQL> SELECT REGEXP_SUBSTR( NULL, '.' ) AS RESULT FROM DUAL; RESULT -------------------- NULL SQL> SELECT REGEXP_COUNT( NULL, '.' ) AS RESULT FROM DUAL; RESULT ---------- NULL
'IT > Regular Expression' 카테고리의 다른 글
| [REGEX] :: POSIX BRE Meta Character '' 5. \ ( back slash ) '' (0) | 2019.07.16 |
|---|---|
| [REGEX] :: POSIX BRE Meta Character '' 4. * ( asterisk ) '' (0) | 2019.07.02 |
| [REGEX] :: POSIX BRE Meta Character '' 2. $ ( dollar ) '' (1) | 2019.06.07 |
| [REGEX] :: POSIX BRE Meta Character '' 1. ^ ( caret ) '' (0) | 2019.06.07 |
| [REGEX] :: 정규 표현식의 기본 개념 (2) | 2019.04.23 |
차트
소소한 일상 C코드 DB 항상 행복하게^-^★