Please enable JavaScript.

Coggle requires JavaScript to display documents.

SQL Languange - Coggle Diagram

- - - - PRIOR is a unary operator that causes Oracle to use the value of the parent row in the column
        
        One expression in condition must be qualified with the PRIOR operator to refer to the parent row
        
        The hierarchical queries in ORACLE go:
        
        Join
        
        CONNECT BY
        
        WHERE clauses
- - - - A key values in one data set must fall within the specified range (“band”) of the second data set
    - - It combines rows that have equivalent values for the specified columns
    - - It returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition.
    - - It combines each row of one table with each row of the other.
    - - It is a join of two or more tables that returns only those rows that satisfy the join condition.
    - - It returns rows from the left side of the predicate for which there are no corresponding rows on the right side of the predicate.
    - - It returns rows that match an EXISTS subquery without duplicating rows from the left side of the predicate when multiple rows on the right side satisfy the criteria of the subquery.
    - - It is a join of a table to itself