Oracle: FROM Clause

As we all know that in Oracle we need to work with different tables to retrieve data. To read or update a particular data we need to specify on which table that data is present. After that, we can retrieve the specified table and work on that. 

FROM Clause in SQL helps to retrieve data from the specified table. It is considered to be the most important part of a SELECT Statement.

Syntax

SELECT Column_Name FROM Table_Name;

Or

DELETE FROM Table_Name
Where(Condition...);

In both of the above examples, you can see that the FROM Clause specifies the Table from which data need to be deleted or selected.

Example

we have a table of Students that details of marks of Students. To see the particular table, we execute the following query:

SELECT * FROM Student;

Output

The Output displayed the values from Student Table.