Sql Concept using Oracle

CONTENTS	DESCRIPTION
SELECT	DATA RETRIEVAL
INSERT UPDATE DELETE	DATA MANIPULATION LANGUAGE (DML)
CREATE ALTER DROP RENAME TRUNCATE	DATA DEFINATION LANGUAGE (DDL)
COMMIT ROLLBACK SAVEPOINT	TRANSACTION CONTROL LANGUAGE (TCL)
GRANT REVOKE	DATA CONTROL LANGUAGE (DCL)

SQL	DESCRIPTION
*/{DISTINCT} COLUMN	For retrive data All/Not repeted
ARITHMETIC OPERATIONS(* , / ,+, -)	Mathematical Operations
COLUMN ALLIASES (BY USING AS / ””)	Define another name of column
CONCATENATION (||)	Concate more than one string or columns
DESC / DESCRIBE	Show the schema of any table or view
WHERE CLAUSE
COMPARISION OPERATORS (= , <, <=, >, >=, <>)	Use of comparision operators
BETWEEN ….. AND Condition	Use of between and condition
IN CONDITION	Use of IN Condition
LIKE CONDITION	Use of LIKE Condition
NULL CONDITION	Use of NULL Condition
LOGICAL CONDITION (AND, OR, NOT)	Use of logical Operators
ORDER BY CLAUSE (ASC / DESC)	Show data in ASC/DESC Order