Oracle SQL

From rbachwiki

Revision as of 00:59, 25 October 2017 by Bacchas (talk | contribs) (→‎Cartesian Join or Cross Join)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

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

USING CLAUSE

Equality Joins

Non-Equality Joins

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=1026"