Oracle regular expressions : pocket reference /
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 sel...
Call Number: | Libro Electrónico |
---|---|
Main Author: | |
Other Authors: | |
Format: | Electronic eBook |
Language: | Inglés |
Published: |
Beijing ; Sebastopol, CA :
O'Reilly,
2003.
|
Edition: | 1st ed. |
Subjects: | |
Online Access: | Texto completo (Requiere registro previo con correo institucional) |
Table of 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)
- 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