sql11g_08 (1)

sql11g_08 (1) - Oracle 11g: SQL Chapter 8 Restricting Rows...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
Oracle 11g: SQL Chapter 8 Restricting Rows and Sorting Data
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Objectives Use a WHERE clause to restrict the rows returned by a query Create a search condition using mathematical comparison operators Use the BETWEEN…AND comparison operator to identify records within a range of values Specify a list of values for a search condition using the IN comparison operator Oracle 11g: SQL 2
Background image of page 2
Objectives (continued) Search for pattern matches using the LIKE comparison operator Identify the purpose of the % and _ wildcard characters in patterns Join multiple search conditions using the appropriate logical operator Perform searches for NULL values Specify the order for the presentation of query results using an ORDER BY clause Oracle 11g: SQL 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
WHERE Clause Syntax A WHERE clause is used to retrieve rows based on a stated condition Requires: Column name Comparison operator Value or column for comparison Non-numeric values must be in single quotes String values are case sensitive Oracle 11g: SQL 4
Background image of page 4
WHERE Clause Example List WHERE clause after FROM clause Oracle 11g: SQL 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Comparison Operators Indicate how the data should relate to the given search value Oracle 11g: SQL 6
Background image of page 6
Arithmetic Comparison Operators Oracle 11g: SQL 7
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Other Comparison Operators Oracle 11g: SQL 8
Background image of page 8
BETWEEN…AND Operator Finds values in a specified range (inclusive) 9
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 23

sql11g_08 (1) - Oracle 11g: SQL Chapter 8 Restricting Rows...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online