Oracle: Select Statement

To select data from the database, we use the SELECT keyword.


SELECT * from Table_Name 

The statement is used to display the entire data stored in the table.


To create table follow this article and for insertion of data read here.

1. Select All Value in a Table

SELECT * from stu;


select all data oracle

2. To Select value of a column by column name

Suppose we need to select all the values in NAME column:

SELECT name from stu;


select particular column oracle

You can select more than one column by separating them with comma.

​SELECT name, section from stu;