1. Home
  2. SQL
  3. Mastering Oracle SQL

Chapter 17. Regular Expressions

One of the most exciting SQL features in Oracle Database 10g is support for regular expressions. Open source databases such as MySQL and PostgreSQL have supported regular expressions for years. Frankly, we were tired of having that thrown in our faces, of feeling one-upped by the open source competition. In the Oracle Database 10g release, Oracle has implemented regular expression support with a vengeance. We were surprised and delighted at what we found. You will be, too.



    		Mastering Oracle SQL, 2nd Edition
    		Preface
    		Chapter 1. Introduction to SQL
    		Chapter 2. The WHERE Clause
    		Chapter 3. Joins
    		Chapter 4. Group Operations
    		Chapter 5. Subqueries
    		Chapter 6. Handling Temporal Data
    		Chapter 7. Set Operations
    		Chapter 8. Hierarchical Queries
    		Chapter 9. DECODE and CASE
    		Chapter 10. Partitioning
    		Chapter 11. PL/SQL
    		Chapter 12. Objects and Collections
    		Chapter 13. Advanced Group Operations
    		Chapter 14. Advanced Analytic SQL
    		Chapter 15. SQL Best Practices
    		Chapter 16. XML
    		Chapter 17. Regular Expressions
    		17.1 Elementary Regular Expression Syntax
    		17.2 Advanced Function Options
    		17.3 Advanced Regular Expression Syntax
    		Chapter 18. Model Queries
    		Appendix A. Oracle's Old Join Syntax
    		Colophon