SELECT statement in Oracle - to select your specific row/rows

The Oracle SELECT statement is used to retrieve data from

>One or more than one tables,

>Object tables,

>Views,

>Object views

Syntax:

SELECT expressions  
FROM tables  

Example:

SELECT *  
FROM students; 

Output:

Example: (select specific fields)

select student_id,sname from students;