Oracle select | select - oracle tutorial - sql tutorial
Learn oracle - oracle tutorial - Oracle select from table - oracle examples - oracle programs
What is Oracle Select ?
- SELECT statement is used to retrieve records from one or more tables.
- The result is stored in a result table, called the result-set.
Syntax:
SELECT expressions
FROM table_name;
click below button to copy the code. By - oracle tutorial - team
Parameters or Arguments:
expressions
- The columns or calculations that you wish to retrieve.
- Use * if you wish to select all columns.
tables
- The tables that you wish to retrieve records from.
- There must be at least one table listed in the FROM clause.
Example:
SELECT * FROM wikitechy_emp;click below button to copy the code. By - oracle tutorial - team
- Oracle SQL statement selects all the columns from the "wikitechy_emp" table:
- Note: Asterik(*) symbol indicates the selection of all the Columns from the table.
- Click Run button to execute the query.
- We can see all the columns from the wikitech_emp table.
Learn oracle - oracle tutorial - Oracle select from table using where - oracle examples - oracle programs
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql
Syntax:
SELECT expressions
FROM table_name WHERE condition;
click below button to copy the code. By - oracle tutorial - team
Parameters or Arguments:
expressions
- The columns or calculations that you wish to retrieve.
- Use * if you wish to select all columns.
tables
- The tables that you wish to retrieve records from.
- There must be at least one table listed in the FROM clause.
WHERE conditions
- Optional.
- The conditions that must be met for the records to be selected.
- If no conditions are provided, then all records will be selected
Example:
SELECT * FROM wikitechy_emp WHERE City='Bangalore';
click below button to copy the code. By - oracle tutorial - team
- Oracle SQL statement selects particular columns from the "wikitechy_emp" table:
- Note: Asterik(*) symbol indicates the selection of all the Columns from the table. WHERE conditions that must be met for the records from the table.
- Click Run button to execute the query.
- We can see the particular columns from the wikitech_emp table.
Oracle Select Query Example
