Home » Oracle FROM Clause

Oracle FROM Clause

by Online Tutorials Library

Oracle FROM Clause

FROM clause is a mandatory clause in SELECT expression. It specifies the tables from which data is to be retrieved.

Syntax:

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:

Customer Table

Execute this query:

Output:

Oracle from example

Oracle FROM Clause Example: (with two tables)

Inner Join example:

Let’s take two tables “suppliers” and “order1”.

Suppliers:

Oracle Inner Join
Oracle Inner Join supplier

Order1:

Oracle Inner Join
Oracle Inner Join order

Execute the following query:

Output:

Oracle from example 5

You may also like