Useful article on regex in Oracle 10g
cdhas written an introductory article on regular expressions in the 10g database. As he doesn't have a blog (imagine!) he has posted it in the OTN PL/SQL forum. In this first article
cdshows how we can use Oracle's regular expressions to determine whether a string contains a valid number.
For those who don't know, regular expressions are a way of searching text for patterns rather than literal matchings. It's a cool way of manipulating large amounts of text, including .CSV files and programs. I'll just mention a little utility I have found very useful: the Regex Coach. This nifty piece of freeware (written in Lisp!) provides us with a sandbox in which we can test regular expressions against a target piece of text to see what they will find. It handles replace too. Very useful if you are just starting to find your way around regex. Check it out.
Regex is a topic big enough for a whole book. The book I have found useful is the Mastering Regular Expressions) by Jeffrey E.F. Friedl and published by O'Reilly. Even though reading it does make me think I ought to know more about perl than I actually do.
cdhas subsequently published two further articles about Regular Expressions in the OTN forums:
Part Two deals with testing Regular Expressions.
Part Three looks at complex formats such as IP addresses and discusses the 10gR2 enhancements.