Oracle WHERE

The Oracle WHERE clause can be used in a SELECT statement, UPDATE statement, or DELETE statement.

Oracle WHERE example

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

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

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