How To Use Select Statement In OraclePLSQL
Description
Select statement is used to retrieve the data from one or more tables in Oracle/PLSQL.
Syntax
The syntax for Select statement in Oracle/PLSQL is given below-
- Select Expression
- from Tables
- Where Conditions;
Example
- Select * from Employee;
- select Emp_id, salary, Dept_no
- from employee
- where emp_id<7005
- and salary > '20000'
- order by Dept_no ASC, Salary DESC;
Summary
Thus, we learnt, Select statement is used to retrieve the data from one or more tables and how to use select statement in Oracle with an example.