Oracle SQL

From rbachwiki
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

Equality Joins

  • USING CLAUSE

Non-Equality Joins

  • ON CLAUSE

Self-Joins

Inner Join

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