Oracle SQL

From bachWiki
Jump to: navigation, search

Database Terminology[edit]

Database Queries[edit]

Entities and Attributes[edit]

Table Creation and Management[edit]

Create Tables[edit]

Add, Modify Tables[edit]

Constraints[edit]

TABLE PERMISSIONS - GRANT[edit]

GRANT[edit]

REVOKE[edit]

Data Manipulation and Transaction Control[edit]

Insert Command[edit]

Update Command[edit]

Delete Command[edit]

Transaction Control Statement [edit]

Joining Data from multiple Tables[edit]

Type of Joins ansi and Oracle[edit]

Natural Join[edit]

Cartesian Join or Cross Join [edit]

Equality Joins[edit]

  • USING CLAUSE

Non-Equality Joins[edit]

  • ON CLAUSE

Self-Joins[edit]

Inner Join[edit]

Join 3 Tables[edit]

  • 4 tables also listed

Outer Joins[edit]

Set Operators [edit]

  • Union
  • Union All

Restricting Rows and Sorting Data[edit]

SUB QUERIES[edit]

WHERE CLAUSE[edit]

DATES [edit]

COMPARISON OPERATORS[edit]

BETWEEN AND Operator[edit]

IN OPERATOR[edit]

LIKE Operator[edit]

LOGICAL Operators[edit]

NULL Operator[edit]

ORDER BY Clause[edit]

AGGREGATE - SUMMARY FUNCTIONS[edit]

TYPES [edit]

GROUP BY CLAUSE[edit]

GROUP BY[edit]

SYNTAX FOR GROUP HAVING ORDER BY[edit]

FUNCTIONS[edit]

NUMERIC BUILT IN FUNCTIONS[edit]

CHARACTER BUILT IN FUNCTIONS[edit]

DATE BUILT IN FUNCTIONS[edit]

CASE STATEMENT[edit]

PSEUDO COLUMNS[edit]

TYPES OF PSEUDO COLUMNS[edit]

VIEWS[edit]

View[edit]

SYNONYM[edit]

SYNONYM[edit]

SEQUENCES[edit]

Sequences [edit]

INDEXES[edit]

INDEX[edit]