PL/SQL Select

Syntax:

select * from table;
select column_name1, column_name2 from table_name;
select column_name1, column_name2 from table_name where condition;

Examples:

select * from employees;
select * from employees where dep_id=10;
select name, salary from employees where dep_id=10;