Loading…

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...

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Gennick, Jonathan
Other Authors: Linsley, Peter
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