Difference between revisions of "Oracle SQL"

From rbachwiki
Jump to navigation Jump to search
Line 31: Line 31:
===[[LOGICAL Operators]]===
===[[LOGICAL Operators]]===
===[[NULL Operator]]===
===[[NULL Operator]]===
===[[[ORDER BY Clause]]]===
===[[ORDER BY Clause]]===

Revision as of 19:59, 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

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