* POSIX Operators         ==> http://goo.gl/KevzQ

- POSIX Character Class ==> http://goo.gl/OSdcS

ex) [abcdefghijklmnopqrstuvwxyz] ==> [:lower:]


    * PERL-Influenced Extensions to POSIX Standard ==> http://goo.gl/Avm1I




    * Or operator: |

- 'ski|ull' = 'ski' or 'ull'

- 'sk(i|u)ll' = 'skill' or 'skull'

- 'ski|ull|ful' = 'ski' or 'ull' or 'ful'

- '^ski|ull$' = '^ski' or 'ull$'


    * Matching Character List operator: [ ]

- all operators except these are treated as literals:

~ Range operator: -

~ POSIX character class: [: :]

~ POSIX collation element: [. .]

~ POSIX character equivalence class: [= =]


- '[a-d]' = IN ('a', 'b', 'c', 'd')

- '[skill]' = IN ('s', 'k', 'i', 'l')

- '[ski|ull]' = IN ('s', 'k', 'i', '|', 'u', 'l')

- '[[:alpha:]]' = all alphabetic characters

- '[^skill$]' = ???, 아래 NonMatching Character List operator 참조


   * NonMatching Character List operator: [^ ]

- '[^a-d]' = NOT IN ('a', 'b', 'c', 'd')

- '[^skill$]' = NOT IN ('s', 'k', 'i', 'l', '$')


- '[^ski|ull$]' = NOT IN ('s', 'k', 'i', '|', 'u', 'l', '$')

- '[^sk(i|u)ll]'= all except for ...

'Oracle > SQL Fundamentals II' 카테고리의 다른 글

15일차 # 테스트  (0) 2012.04.24
15일차 # 8 Regular Expression (정규표현식)  (0) 2012.04.24
15일차 # 추가  (0) 2012.04.24
15일차 # sys_connect_by_path 함수  (0) 2012.04.24
15일차 # 정렬: Order siblings by  (0) 2012.04.24

+ Recent posts