Oracle Tutorial

Where Examples

Example 1

Select *
From users u
Where u.name = 'ANIA' ;

Example 2

Select *
From books b
Where b.author = 'SMITH'
And book_name Like '%ORACLE%'



Example 3

Select id, name, create_date
From users
Where create_date > (Select create_date
From users
Where name='SCOTT' )