Difference between revisions of "Oracle SQL"

From rbachwiki
Jump to navigation Jump to search
Line 23: Line 23:


== Restricting Rows and Sorting Data ==
== Restricting Rows and Sorting Data ==
===[WHERE CLAUSE] ===
===[WHERE CLAUSE] ===

Revision as of 16:34, 24 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

Cartesian Join or Cross Join

Equality Joins

Non-Equality Joins

Self-Joins

Outer Joins

Set Operators

Restricting Rows and Sorting Data

[WHERE CLAUSE]

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