Oracle Database 11g: Subqueries and Regular Expressions

Overview/Description
To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.

Target Audience
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisites
Familiarity with data processing concepts and techniques

Expected Duration (hours)
1.8

Lesson Objectives

Oracle Database 11g: Subqueries and Regular Expressions

• identify the steps for writing multiple-column and scalar subqueries.
• recognize the steps for solving problems by using correlated subqueries and the WITH clause.
• write multiple-column, correlated, and scalar subqueries in a given scenario and solve a problem using the WITH clause.
• recognize the benefits of implementing complex match logic in the database, using regular expressions.
• identify the steps for using regular expressions functions and for accessing subexpressions.
• use regular expressions functions to search for, replace, and manipulate data, and also add a CHECK constraint to a column.