FROM - (Oracle Clauses)

The FROM clause is a fundamental part of SQL queries, including Oracle SQL. This clause specifies the table or view from which the data is retrieved in the query.

Syntax

The basic syntax of the FROM clause is as follows:

SELECT column1, column2, ...
FROM table_name;

Here, column1, column2, etc are the columns that you want to retrieve data from and table_name is the name of the table or view from which you want to retrieve data.

Example

Consider the following example, where we have a table named "employees" in a sample Oracle database:

SELECT *
FROM employees;

In this example, we're selecting all columns from the "employees" table.

Output

The output of the above query would be a table containing all the rows and columns from the "employees" table.

Explanation

In the above example, we're using the FROM clause to specify the "employees" table from which we want to retrieve data. By using the asterisk (*) symbol, we're telling the SQL engine to return all columns from the table.

Use

The FROM clause is used in almost every SQL query that retrieves data from a table or view. It specifies the source of the data and can be used to join multiple tables, filter data, and aggregate data.

Important Points

• The FROM clause is used to specify the table or view from which you want to retrieve data.
• The FROM clause is a fundamental part of most SQL queries.
• The FROM clause can be used to join multiple tables, filter data, and aggregate data.

Summary

The FROM clause is a fundamental part of SQL queries in general and Oracle SQL in particular. It is used to specify the table or view from which you want to retrieve data and is essential for filtering data, joining multiple tables, or aggregating data.