Javatpoint Logo
Javatpoint Logo

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


oracle select output 1

Select Example: select specific fields


oracle select output 2

Select Example: select fields from multiple tables (JOIN)


oracle select output 3
Next TopicOracle Insert

Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA