Oracle regular expressions : pocket reference / Jonathan Gennick and Peter Linsley.

Format:

Book

Author/Creator:

Gennick, Jonathan.

Contributor:

Linsley, Peter.

Language:

English

Subjects (All):

Oracle (Computer file)--Handbooks, manuals, etc.

Oracle (Computer file).

Electronic data processing--Handbooks, manuals, etc.

Electronic data processing.

Text processing (Computer science)--Handbooks, manuals, etc.

Text processing (Computer science).

Physical Description:

1 online resource (66 p.)

Edition:

First edition.

Other Title:

Oracle regular expressions pocket reference

Place of Publication:

Beijing ; Sebastopol, California : O'Reilly, 2003.

Language Note:

English

System Details:

text file

Summary:

Support for regular expressions in SQL and PL/SQL is one of the most exciting features of Oracle Database 10G. Oracle has long supported the ANSI-standard LIKE predicate for rudimentary pattern matching, but regular expressions take pattern matching to a new level. They provide a powerful way to select data that matches a pattern, as well as to manipulate, rearrange, and change that data. This concise pocket guide is part tutorial and part quick-reference. It's suitable for those who have never used regular expressions before, as well as those who have experience with Perl and o

Contents:

Contents; Oracle Regular Expressions Pocket Reference; 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; String literal issues; NULL versus empty strings; Perl-specific syntax; Syntax Perl does not support; Negating character classes; Lazy quantifiers (non-greediness)

Experimental featuresBackreferences; Backslash differences; 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 ErrorMessages; ORA-01760: illegal argument for function

ORA-12722: regular expression internal errorORA-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

Notes:

"New in Oracle database 10g"--Cover.

"Tutorial & quick reference"--Cover.

Description based on online resource; title from PDF title page (ebrary, viewed October 2, 2013).

ISBN:

9780596552497

0596552491

9781306817066

1306817064

9780596528874

0596528876