Oralce SQL Material
============================
- Structured Query language(SQL)
- Sub Languages Like DDL, DML, DRL, TCL, DCL
- Data Definition language(DDL)
- Create, Alter, Truncate, Rename, Drop
- Data Manipulation Language(DML)
- Insert, Update, Delete
- Sub Languages Like DDL, DML, DRL, TCL, DCL
- Create, Alter, Truncate, Rename, Drop
- Insert, Update, Delete
- Where Clause
- Order By Clause
- Group By Clause
- SQL Functions
- String/Char Functions
- Math/Numeric Functions
- Date Functions
- Multiple Row Functions
- Miscellaneous Functions
- JOINS Concept in Oracle
- Equi/Inner/Simple Join
- Natural Join
- Non-Equi Join
- OUTER JOIN
- LEFT OUTER JOIN
- RIGHT OUTER JOIN
- FULL OUTER JOIN
- SELF JOIN
- CROSS JOIN
- Oracle Constraints Types
- UNIQUE
- NOT-NULL
- PRIMARY KEY
- CHECK
- FOREIGN KEY
- DEFAULT
- Transaction Control Language (TCL)
- Commit
- Rollback
- Savepoint
- Data Control Language (DCL)
- Grant
- Revoke