Difference between revisions of "Oracle SQL"
Jump to navigation
Jump to search
| Line 38: | Line 38: | ||
== Restricting Rows and Sorting Data == | == Restricting Rows and Sorting Data == | ||
===[[SUB QUERIES]]=== | |||
===[[WHERE CLAUSE]] === | ===[[WHERE CLAUSE]] === | ||
===[[DATES ]]=== | ===[[DATES ]]=== | ||
| Line 47: | Line 48: | ||
===[[NULL Operator]]=== | ===[[NULL Operator]]=== | ||
===[[ORDER BY Clause]]=== | ===[[ORDER BY Clause]]=== | ||
== AGGREGATE - SUMMARY FUNCTIONS == | == AGGREGATE - SUMMARY FUNCTIONS == | ||
=== [[TYPES ]]=== | === [[TYPES ]]=== | ||
Revision as of 20:07, 14 November 2017
Database Terminology
Database Queries
Entities and Attributes
Relationship Basics
Table Creation and Management
Create Tables
Add, Modify Tables
Constraints
TABLE PERMISSIONS - GRANT
GRANT
REVOKE
Data Manipulation and Transaction Control
Insert Command
Update Command
Delete Command
Transaction Control Statement
Joining Data from multiple Tables
Type of Joins ansi and Oracle
Natural Join
Cartesian Join or Cross Join
Equality Joins
- USING CLAUSE
Non-Equality Joins
- ON CLAUSE
Self-Joins
Inner Join
Join 3 Tables
- 4 tables also listed
Outer Joins
Set Operators
- Union
- Union All