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 other languages supporting regular expressions. The book describes Oracle Database 10G's support for regular expressions, including globalization support and differences between Perl's syntax and the POSIX syntax supported by Oracle 10G. It also provides a comprehensive reference, including examples, to all supported regular expression operators, functions, and error messages.
Oracle Regular Expressions Pocket Reference
und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr
| ||||||||||||||||||
Kurzbeschreibung
Wird oft zusammen gekauft
Produktinformation
|
Mehr über den Autor
Entdecken Sie Bücher, lesen Sie über Autoren und mehr
Produktbeschreibungen
Synopsis
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 other languages supporting regular expressions. The book describes Oracle Database 10G's support for regular expressions, including globalization support and differences between Perl's syntax and the POSIX syntax supported by Oracle 10G. It also provides a comprehensive reference, including examples, to all supported regular expression operators, functions, and error messages.
Über den Autor
Jonathan Gennick is an O'Reilly & Associates editor specializing in database and programming titles. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management. Jonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. Recent projects include Oracle SQL"Loader (O'Reilly & Associates, 2001); Oracle SQL"Plus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly & Associates, 2002) and editing Practical PostgreSQL (O'Reilly & Associates, 2002). Jonathan is certified as an Oracle DBA and is a member of MENSA and the Oracle Technology Network. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at jonathan@gennick.com, and you can learn more about him personally by visiting his website at http: //gennick.com.
Peter Linsley began his career in the computer industry as a localization engineer focusing on QA of the Oracle Database. He later relocated to Oracle headquarters in California where he acted as a Globalization consultant specializing in the database, and was responsible for developing solutions to aid database character set migration to Unicode. Peter first met with regular expressions in a SED class at Napier University of Edinburgh and has been a devoted UNIX command line addict ever since. During his tenure at Oracle, he dreamt of a world where all developers had access to regular expressions and decided to make it a personal mission to ensure that would become a reality for users of Oracle. In 2003, Peter was fortunate enough to realize this dream and landed a pivotal role in the design and implementation of Oracle Regular Expressions.
In diesem Buch
(Mehr dazu)
Kundenrezensionen
Die hilfreichsten Kundenrezensionen
1 von 1 Kunden fanden die folgende Rezension hilfreich
Von Gregor Theis
Format:Taschenbuch|Von Amazon bestätigter Kauf
"ORACLE Regular Expressions" ist ein Buch über die neuen ORACLE SQL Funktionen, die reguläre Ausdrücke verarbeiten können.
Es werden die Parameter dieser Funktionen und die ORACLE Regular Expression Engine Muster besprochen.
Das Buch teil sich in fünf Kapitel auf:
- Einführung in reguläre Ausdrücke
- Wie unterstützt ORACLE Reguläre Ausdrücke (Funktionen, Sprachumfang, NLS Support, Perl vs. ORACLE REGEXP usw.)
- Reguläre Ausdrücke Schnellreferenz
- ORACLE REGEXP% Funktionen
- ORA- Fehler zu REGEXP% Funktionen
Leider hat ich zum dem Zeitpunkt, als ich diese Rezension geschrieben habe, noch keinen Zugriff auf eine ORACLE 10g Datenbank, so dass ich die Funktionen und die Beispiele nicht testen konnte. Ich freue mich schon auf die neue Version, um die Funktionen testen zu können.
Dieses Buch ist meiner Meinung nach nicht ausreichend, um Reguläre Ausdrücke und deren Verwendung neu zu lernen. Wenn man reguläre Ausdrücke nicht kennt, empfehle ich "Reguläre Ausdrücke" von J. Friedl. Danach kann man sich "ORACLE Regular Expressions" zur Hand nehmen, um die ORACLE Implementation zu verstehen. Der Unfang, der Inhalt und die Form dieses Buches ist gut geeignet, um die ORACLE REGEXP Funktionen zu verwenden.
Gut gefallen hat mir der Vergleich mit dem Perl Regexp Support. Leider fehlt mir ein Beispiel für das Anlegen eines Function-Based-Indexes, um bei REGEXP_LIKE einen Full Table Scan zu vermeiden (wird nur kurz erwähnt).
Diese "Pocket Reference" von O'Reilly hat keinen alphabetischen Suchindex, was meiner Meinung nach OK ist, da das Inhaltsverzeichnis sehr ausführlich ist und die Seitenzahl sehr gering.
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com:
4.0 von 5 Sternen
5 Rezensionen
6 von 7 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen
All you need to use Oracle regular expressions
19. Januar 2007
Von Jan Goyvaerts
- Veröffentlicht auf Amazon.com
Format:Taschenbuch
This pocket-sized 60-page booklet covers only one topic: the regular expression support in Oracle Database 10g. And it covers it well. Though the book's cover says "pocket reference", the book actually contains both a short tutorial and a reference.
The tutorial does a good job of explaining basic regular expression concepts. It doesn't provide a lot of examples or detailed explanations. But if you're apt and don't mind to experiment a little, it'll probably be all you need. Oracle's regular expression flavor is fairly limited, so there aren't many tricky concepts to explain.
The second half of the book is the actual reference. The first part of the reference lists all of the available regular expression tokens, along with a brief but clear description of what the token matches, and one or two examples. The examples use only literal text, so you can try them in Oracle without needing a particular example database.
The second part of the reference describes Oracle's four regular expression functions: REGEXP_INSTR, REGEXP_LIKE, REGEXP_REPLACE and REGEXP_SUBSTR. All the parameters that these four functions accept are fully explained, with clear indications of what all the possible values for these parameters will do. The book shows several examples for each function, again using only literal text. You can easily replace the strings with column names in your actual SQL code.
The final part of the reference lists all 10 error codes that the regexp functions can trigger, along with a one-paragraph description explaining exactly what the error is about (which isn't always obvious from the error messages themselves).
All in all this is an excellent little book. It's probably all you need to successfully use regular expressions with Oracle.
Many people recommend Mastering Regular Expressions to go along with the Oracle book. I disagree. Oracle implements POSIX regular expressions, which are a fairly limited subset of modern Perl-style regular expressions. (Actually, Perl's regex syntax is a significant extension of POSIX.) Mastering Regular Expressions barely mentions POSIX, and never mentions Oracle. It mostly talks about the advanced regex features in Perl, Java, .NET and PHP. If you use any of these languages, buying both Mastering Regular Expressions and Oracle Regular Expressions is certainly a good idea. But if you're a database administrator working solely with Oracle, the Oracle Regular Expressions Pocket Reference is all you need.
The tutorial does a good job of explaining basic regular expression concepts. It doesn't provide a lot of examples or detailed explanations. But if you're apt and don't mind to experiment a little, it'll probably be all you need. Oracle's regular expression flavor is fairly limited, so there aren't many tricky concepts to explain.
The second half of the book is the actual reference. The first part of the reference lists all of the available regular expression tokens, along with a brief but clear description of what the token matches, and one or two examples. The examples use only literal text, so you can try them in Oracle without needing a particular example database.
The second part of the reference describes Oracle's four regular expression functions: REGEXP_INSTR, REGEXP_LIKE, REGEXP_REPLACE and REGEXP_SUBSTR. All the parameters that these four functions accept are fully explained, with clear indications of what all the possible values for these parameters will do. The book shows several examples for each function, again using only literal text. You can easily replace the strings with column names in your actual SQL code.
The final part of the reference lists all 10 error codes that the regexp functions can trigger, along with a one-paragraph description explaining exactly what the error is about (which isn't always obvious from the error messages themselves).
All in all this is an excellent little book. It's probably all you need to successfully use regular expressions with Oracle.
Many people recommend Mastering Regular Expressions to go along with the Oracle book. I disagree. Oracle implements POSIX regular expressions, which are a fairly limited subset of modern Perl-style regular expressions. (Actually, Perl's regex syntax is a significant extension of POSIX.) Mastering Regular Expressions barely mentions POSIX, and never mentions Oracle. It mostly talks about the advanced regex features in Perl, Java, .NET and PHP. If you use any of these languages, buying both Mastering Regular Expressions and Oracle Regular Expressions is certainly a good idea. But if you're a database administrator working solely with Oracle, the Oracle Regular Expressions Pocket Reference is all you need.
2 von 3 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen
A quick ease reference... and translator!!!
11. März 2008
Von J. Brutto
- Veröffentlicht auf Amazon.com
Format:Taschenbuch
This book provides not only the basics and some extras on the built-in Oracle utilities for regular expression handling, but also provides a nice "translation manuscript" if you are used to working with regular expressions in languages such as Perl, Java, C++, etc.
Great little reference and especially useful for translating your regular expressions between engines.
Great little reference and especially useful for translating your regular expressions between engines.
5.0 von 5 Sternen
Oracle Regular Expressoins
25. September 2012
Von cyn
- Veröffentlicht auf Amazon.com
Format:Taschenbuch|Von Amazon bestätigter Kauf
I think that this book was good in that it helped me understand the connotations of regular expressions.
I think the one weakness is that some of the files they recommended for download were available but not
executable in my insitutional Oracle SQLPLUS environment. I suggest you own your own download copy version
of Oracle SQL.
I think the one weakness is that some of the files they recommended for download were available but not
executable in my insitutional Oracle SQLPLUS environment. I suggest you own your own download copy version
of Oracle SQL.
›
Gehen Sie zu Amazon.com, um alle 5 Rezensionen zu sehen
4.0 von 5 Sternen
Waren diese Rezensionen hilfreich?
Wir wollen von Ihnen hören.
Kunden diskutieren
|
Das Forum zu diesem Produkt
Fragen stellen, Meinungen austauschen, Einblicke gewinnen Aktive Diskussionen in ähnlichen Foren
Kundendiskussionen durchsuchen
|
Ähnliche Foren
|
||||||||||||||||||||||||||||||||||
Lieblingslisten
|
|
Ähnliche Artikel finden
Ihr Kommentar
Möchten Sie die Produktinformationen aktualisieren oder Feedback zu den Produktabbildungen geben?
|
