SQL Tutorial : DRL / DQL - SELECT

Hello Everyone,

Let's learn about the below topic:

DRL:

- DATA RETREIVAL LANGAUGE :

SCHEMA :

TABLES USED:

EMPLOYEES

DEPARTMENTS

LOCATIONS

EMP_HISTORY

JOB_HISTORY

JOBS

SELECT:

SELECT * FROM TAB

SELECT => COLUMNS
FROM => TABLES

SELECT TABLE_NAME
FROM USER_TABLES

DESC EMPLOYEES

DESCRIBE EMPLOYEES

SELECT * FROM EMPLOYEES

SQL STATEMENTS:

****************

* NOT CASE SENSITIVE

* CAN BE ON DIFFERENT LINES

* USUALLY CLAUSES ARE PLACED IN SEPARATE LINES

* KEY WORDS CANNOT BE ABBREVIATED

* COLUMNS HEADINGS ARE CENTERED AND CAPITALISED

* CHARACTERS AND DATE ARE LEFT JUSTIFIED

* NUMBERS ARE RIGHT JUSTIFIED