---

Oracle From Clause

The Oracle FROM Clause is used to select some records from a table. It is very important clause in Oracle because it tell from which table you want to retrieve the records.

Oracle FROM CLAUSE Syntax

To retrieve records from existing table, use the following syntax:

Parameters:

tablename: The table name from which you want to remove all records.

Oracle FROM CLAUSE example retrieve data from one table

The following Oracle statement to retrieve records from "tblCustomerLoan" table:

Note:

In the above example, we have fetched records from "tblCustomerLoan"

Show FROM CLAUSE Example with retrieve data from two tables with inner join

To retrieve data from multiple tables using INNER JOIN from existing tables, use the following syntax:

---

---