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.

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

FROM customers;   

elect Example: select specific fields


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