Database Reference
In-Depth Information
Figure 5.5
A Second Filter
Reduces the Result
from 39 Rows to 4
Rows.
the text in the TITLE column of each row with the text on the right side of
the operator. The percentage signs (%) are wild cards. A wild card character
matches any character or string of characters. So, any title containing “Me”
anywhere within the song title will pass this test and be returned. The result
is shown in Figure 5.5.
SELECT S.TITLE, S.RECORDING_DATE
FROM SONG S
WHERE S.RECORDING_DATE > '01-JUL-2001'
AND S.TITLE LIKE '%Me%';
That's enough examples for now. Let's look at how we can build
WHERE clause comparisons between left and right sides of expressions.
Followed by that we will examine joining together multiple compared sets
using logical operators.
5.2
WHERE Clause Expression Conditions
Available in Oracle SQL are a number of what could be called
conditional
comparisons
:
