Oracle Clause | Oracle From Clause - oracle tutorial - sql tutorial
![Oracle from clause](https://wikitechy.com/tutorials/oracle/img/oracle-images/oracle-from-clause.gif)
Learn oracle - oracle tutorial - Oracle from clause - oracle examples - oracle programs
What is Oracle FROM clause ?
- FROM clause is a mandatory clause in SELECT expression.
- It specifies the tables from which data is to be retrieved.
- The Oracle/PLSQL FROM clause is used to list the tables and any join information required for the Oracle query.
Syntax:
FROM table_name...
Expressions...
click below button to copy the code. By - oracle tutorial - team
Oracle FROM Clause Example: (with one table)
- Let's take an example to explain how to use FROM clause to retrieve data from one table. Consider a table "customers".
Customer table:
CREATE TABLE "CUSTOMERS"
( "NAME" VARCHAR2(4000),
"AGE" NUMBER,
"SALARY" NUMBER,
"STATE" VARCHAR2(4000)
)
/
click below button to copy the code. By - oracle tutorial - team
![customer table from clause](https://wikitechy.com/tutorials/oracle/img\oracle-images\customer-table-clause.png)
Execute this query
SELECT *
FROM customers
WHERE salary >= 20000
ORDER BY salary ASC;
click below button to copy the code. By - oracle tutorial - team
Output:
![oracle from clause one output](https://wikitechy.com/tutorials/oracle/img\oracle-images\oracle-from-clause-one-output.png)
Oracle FROM Clause Example: (with two tables)
Inner Join example
- Let's take two tables "suppliers" and "order1".
Suppliers:
![supplier table](https://wikitechy.com/tutorials/oracle/img\oracle-images\supplier-table.png)
![supplier data](https://wikitechy.com/tutorials/oracle/img\oracle-images\supplier-data.png)
Order1:
![supplier order](https://wikitechy.com/tutorials/oracle/img\oracle-images\supplierid-order1.png)
![supplier order](https://wikitechy.com/tutorials/oracle/img\oracle-images\supplierid-order2.png)
Execute the following query:
SELECT suppliers.supplier_id, suppliers.supplier_name, order1.order_number
FROM suppliers
INNER JOIN order1
ON suppliers.supplier_id = order1.supplier_id;
click below button to copy the code. By - oracle tutorial - team
Output:
![supplier order output](https://wikitechy.com/tutorials/oracle/img\oracle-images\supplier-output.png)