HOW TO USE BASIC "SELECT" STATEMENT IN ORACLE DATABASE?

# SELECT specific column:

SELECT (column_name)
FROM (table_name)

In this syntax SELECT statement contain those column which we want to query.

If you want to query the department_id and salary of the employees table then the SELECT statement is like this___

SELECT department_id, salary
FROM employees;

Note:
#Columns are separated by comma(,).
# semi colon(;) must be use At the end of the statement.
________________________________________________
SELECT all column:

SELECT *
FROM employees;

When you want to query all column of a table you need to use the above SELECT* syntax.
________________________________________________