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 s...
Autor principal: | |
---|---|
Otros Autores: | |
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
Beijing ; Sebastopol, California :
O'Reilly
2003.
|
Edición: | First edition |
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626912506719 |
Tabla de Contenidos:
- 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