Oracle SELECT

The Oracle SELECT statement uses to retrieve data from tables, views, or materialized views.

Oracle SELECT example

Select *
From users u 
Where u.user_id > 50;

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

Select *
From users u
Where u.user_id In (Select ul.user_id
From users_log ul
Where u.user_id = ul.user_id);