Oracle SELECT Statement
The Oracle SELECT statement is used to retrieve data from one or more than one tables, object tables, views, object views etc.
1) expressions: It specifies the columns or calculations that you want to retrieve.
2) tables:This parameter specifies the tables that you want to retrieve records from. There must be at least one table within the FROM clause.
3) conditions: It specifies the conditions that must be followed for selection.
Select Example: select all fields
Let's take an example to select all fields from an already created table named customers
Select Example: select specific fields
Select Example: select fields from multiple tables (JOIN)