...

Database Managment - Oracle

Back to Course

Lesson Description


Lession - #1417 Oracle SELECT


Oracle SELECT Statement

The Oracle SELECT articulation is utilized to recover information from at least one than one tables, object tables, sees, object sees and so forth.
Syntax

SELECT expressions  
FROM tables  
WHERE conditions;   

Parameters: 1>
articulations: It indicates the sections or estimations that you need to recover. 2>
tables:This boundary indicates your desired tables to recover records from. There should be no less than one table inside the FROM condition.

Select Example: select all fields

Let's take an example to select all fields from an already created table named customers

SELECT *  
FROM customers;   


elect Example: select specific fields

Example

SELECT age, address, salary  
FROM customers  
WHERE  age < 25  
AND salary > '20000'  
ORDER BY age ASC, salary DESC;