O'Reilly logo

Oracle SQL, A Beginner's Tutorial, Second Edition by Djoni Darmawikarta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10

Regular Expressions

A regular expression is a sequence of characters that describes a search pattern. This chapter explains how to use regular expressions to search for data.

Searching without Regular Expressions

You have learned that you can use queries to do exact match searches. For example, to find the customer having the name �Standard Store�, your query would look like that in Listing 10.1.

Listing 10.1: Searching exactly for �Standard Store�

SELECT * FROM customer 
WHERE c_name = 'Standard Store';

Assuming the customer table has the following columns and rows

C_NO C_NAME        C_ADDRESS                  C_PHONE
---- ------------- -------------------------- -----------
10 Standard Store  1 University Ave M5H 3B9   416-1010-111
20 Quality Store 3030 Bunty ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required