Difference between revisions of "Oracle SQL"
Jump to navigation
Jump to search
| Line 18: | Line 18: | ||
===[[Cartesian Join or Cross Join ]]=== | ===[[Cartesian Join or Cross Join ]]=== | ||
===[[Equality Joins]]=== | ===[[Equality Joins]]=== | ||
*USING CLAUSE | |||
===[[Non-Equality Joins]]=== | ===[[Non-Equality Joins]]=== | ||
*ON CLAUSE | |||
===[[Self-Joins]]=== | ===[[Self-Joins]]=== | ||
===[[Outer Joins]]=== | ===[[Outer Joins]]=== | ||
Revision as of 01:01, 25 October 2017
Database Terminology
Database Queries
Entities and Attributes
Relationship Basics
Table Creation and Management
Create Tables
Add, Modify Tables
Constraints
Data Manipulation and Transaction Control
Insert Command
Update Command
Delete Command
Transaction Control Statement
Joining Data from multiple Tables
Natural Join
Cartesian Join or Cross Join
Equality Joins
- USING CLAUSE
Non-Equality Joins
- ON CLAUSE