책 이미지
책 정보
· 분류 : 외국도서 > 컴퓨터 > 데이터베이스 관리 > 일반
· ISBN : 9780596006013
· 쪽수 : 60쪽
· 출판일 : 2003-10-14
책 소개
목차
Introduction
Tutorial
Patterns
Regular Expressions
Bracket Expressions
The Escape Character
Subexpressions
Alternation
Greediness
Backreferences
Fuzziness
Oracle's Regular Expression Support
Regular Expression Functions
Regular Expression Locale Support
Regular Expression Matching Options
Standards Compliance
Differences Between Perl and Oracle
Regular Expression Quick Reference
\ (Backslash)
\1 through \9 (Backslash)
. (Period)
^ (Caret)
$ (Dollar Sign)
[ ] (Square Brackets)
[. .] (Collation Element)
[: :] (Character Class)
[= =] (Equivalence Class)
* (Asterisk)
+ (Plus Sign)
? (Question Mark)
{ } (Curly Braces)
Vertical Bar (|)
( ) (Parentheses)
Oracle Regular Expression Functions
REGEXP_INSTR
REGEXP_LIKE
REGEXP_REPLACE
REGEXP_SUBSTR
Oracle Regular Expression Error Messages
ORA-01760: illegal argument for function
ORA-12722: regular expression internal error
ORA-12725: unmatched parentheses in regular expression
ORA-12726: unmatched bracket in regular expression
ORA-12727: invalid back reference in regular expression
ORA-12728: invalid range in regular expression
ORA-12729: invalid character class in regular expression:
ORA-12730: invalid equivalence class in regular expression
ORA-12731: invalid collation class in regular expression
ORA-12732: invalid interval value in regular expression
