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;
6 Views