Oracle FROM Clause
FROM clause is a mandatory clause in SELECT expression. It specifies the tables from which data is to be retrieved.
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".
Execute this query:
Oracle FROM Clause Example: (with two tables)
Inner Join example:
Let's take two tables "suppliers" and "order1".
Execute the following query: