Difference between revisions of "Oracle SQL"

From rbachwiki
Jump to navigation Jump to search
Line 19: Line 19:
===[[Equality Joins USING CLAUSE]]===
===[[Equality Joins USING CLAUSE]]===


===[[Non-Equality Joins]]===
===[[Non-Equality Joins ON CLAUSE]]===
 
===[[Self-Joins]]===
===[[Self-Joins]]===
===[[Outer Joins]]===
===[[Outer Joins]]===

Revision as of 00:58, 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

Self-Joins

Outer Joins

Set Operators

Restricting Rows and Sorting Data

WHERE CLAUSE

DATES

COMPARISON OPERATORS

BETWEEN AND Operator

IN OPERATOR

LIKE Operator

LOGICAL Operators

NULL Operator

ORDER BY Clause

Retrieved from "https://www.r512.com/index.php?title=Oracle_SQL&oldid=1023"