December 2002
Intermediate to advanced
745 pages
17h 26m
English
book
Oracle® Web Application Programming for PL/SQL® Developers
by Susan Boardman, Melanie Caffrey, Solomon Morse, Benjamin Rosenzweig
Content preview from Oracle® Web Application Programming for PL/SQL® Developers
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Unit 19.6. Searching and Replacing Text
Regular Expressions
Though PL/SQL’s INSTR and SUBSTR functions perform efficient text manipulation, the OWA_PATTERN package provides procedures and functions that perform more complex text manipulation than is possible with their PL/SQL predecessors. Regular expressions make this sophistication possible. A regular expression is a string/pattern of characters used to find matches within another string of characters. Chances are you have used a simple regular expression to perform wildcard file searches using commands such as ls *.txt, dir *.txt, and Oracle’s LIKE statement with the wildcard character, %. Additionally, you learned about JavaScript regular expressions in Chapter 14, “JavaScript Form Validation.” ...