Oracle Tutorial

What is Oracle
SQL Keywords

Oracle Wildcards

Oracle Wildcards

Oracle Aliases

Oracle Aliases

MySQL Tutorial

MySQL Tutorial

PL/SQL Tutorial

PL/SQL Tutorial

Oracle Interview Questions

Oracle Interview Questions and Answers


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:

Syntax

SELECT col1,col2,col3,...
FROM tablename

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:

Example

SELECT firstName, lastName, address FROM tblCustomerLoan;

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:

Example

SELECT B.banks, A.accountName FROM tblbankdemataccountcharges A 
Inner Join tblbankheadquartersandaddress B LIMIT 5;