Oracle regular expressions: pocket reference by Jonathan Gennick
By Jonathan Gennick
Help for normal expressions in SQL and PL/SQL is likely one of the most enjoyable beneficial properties of Oracle Database 10G. Oracle has lengthy supported the ANSI-standard LIKE predicate for rudimentary development matching, yet standard expressions take trend matching to a brand new point. they supply a robust option to opt for information that fits a trend, in addition to to control, rearrange, and alter that info. This concise pocket consultant is a component educational and half quick-reference. it really is compatible when you have by no means used commonplace expressions sooner than, in addition to those that have adventure with Perl and different languages aiding average expressions. The ebook describes Oracle Database 10G's aid for normal expressions, together with globalization help and changes among Perl's syntax and the POSIX syntax supported via Oracle 10G. It additionally presents a entire reference, together with examples, to all supported usual expression operators, features, and blunder messages. O'Reilly's Pocket References became a favourite between builders and database directors all over the place. through supplying a wealth of significant information in a concise, well-organized structure, those convenient books carry simply what you want to entire the duty to hand. no matter if you are utilizing general expressions for the 1st time or utilizing your talents from different languages to the newest model of Oracle, the Oracle commonplace Expressions Pocket Reference is the ebook to have within reach.
Read Online or Download Oracle regular expressions: pocket reference PDF
Best oracle books
За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle types, так и администраторам - используйте PL/SQL на полную мощь.
Grasp Oracle Streams 11g Replication allow real-time details entry and knowledge sharing throughout your disbursed framework utilizing the professional info during this Oracle Press consultant. Oracle Streams 11g info Replication explains the right way to manage and administer a unified firm info sharing infrastructure.
Oracle software show four Recipes offers an example-based method of studying software convey - the ground-breaking, speedy software improvement platform integrated with each Oracle Database license. The recipes structure is perfect for the quick-study who simply wishes a great instance or to kick begin their considering and get pointed within the correct path.
- OCA: Oracle 10g Administration I Study Guide (1Z0-042)
- Oracle Database 11g The Complete Reference (Oracle Press)
- Beginning Oracle PL/SQL 2nd edition by Bales, Donald (2015) Paperback
- OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062
- Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c
- Expert Oracle SQL: Optimization, Deployment, and Statistics
Additional resources for Oracle regular expressions: pocket reference
Backreferences REGEXP_REPLACE allows the use of regular expression backreferences in the replacement text string. Such backreferences refer to values matching the corresponding subexpressions in the pattern argument. The following example makes use of backreferences to fix doubled word problems: SELECT park_name, REGEXP_REPLACE(description, '([[:space:][:punct:]]+)([[:alpha:]]+)' || '([[:space:][:punct:]]+)\2' || '[[:space:][:punct:]]+', '\1\2\3') description FROM park WHERE REGEXP_LIKE(description, '([[:space:][:punct:]]+)([[:alpha:]]+)' || '([[:space:][:punct:]]+)\2' || '[[:space:][:punct:]]+'); Look carefully at the subexpressions in the pattern expression, and you'll see that the subexpressions have the following meanings: \1 The space and punctuation preceding the first occurrence of the word.
Is used to return the second line containing characters. +$',1,2,'m') FROM dual; Brighten the corner! The first line is 'Do not', and is skipped because the fourth parameter requests line two. The second line is a NULL line, which is skipped because it contains no characters. The third line is returned from the function because it's the second occurrence of the pattern: a line containing characters. Just as the asterisk can be applied to bracket expressions and subexpressions, so can the plus.
ORA-12731: invalid collation class in regular expression You specified a collation element that does not exist in your current sort order. ] when NLS_SORT is other than XSPANISH or XCZECH will cause this error, because other languages never treat the combination 'ch' as a single character. Check your expression to be sure that each use of [= and =] is valid, and check your NLS_SORT setting.