Table of Contents
-
(Here)
Aggregated Lists: Creating Aggregated List Strings - ListAgg() Function.
-
(Here)
Aggregated Lists: Decomposing an Aggregated List of Values (De-ListAgg).
-
(Here)
Analytic Functions: LAG( ) -- Grab a value from a previous row.
-
(Here)
Analytic Functions: Rank() Dense_Rank() and Row_Number().
-
(Here)
Dates: Grouping date-time values into (n) minute buckets.
-
(Here)
Date-Time: Calculate & Display a Date-Time Duration as Days-HH:MM:SS.
-
(Here)
Hierarchical Queries, A Self-Referencing table, Using the "Connect By" Clause.
-
(Here)
Overlapping Intervals (both numeric or date): Do they overlap? By how much?
-
(Here)
RegExp: Use Regular Expressions to Extract Values from CSV-Type String Records.
-
(Here)
SQL-Loader: The Step by Step Basics - Example 1 (CSV file).
-
(Here)
SQL-Loader: The Step by Step Basics - Example 2 (fixed-field).
-
(Here)
SQL-Loader: Using SQL-Loader to Load CSV Data Into an Oracle Table.
-
(Here)
SQL-to-CSV: Using a SQL query to dump data directly to a CSV file.
-
(Here)
Tricks and Tips: Creating a Character-Based Bar-Graph.
-
(Here)
Update: Updating Values in a main table using Look-UP values from a secondary table.
-
(Here)
WITH Clause: Sub-queries and Sub-query Factoring (Great for sample or test data!)
-
(Here)
WITH Clause: Using the Recursive Query Ability of the WITH Clause.
-
(Here)
Using the Decode() Function to Interpret Inequalities.
-
(Here)
Inline Functions (declared within a SQL Query).
-
(Here)
Selecting Top(n) or Nth ranked rows (Top-N Analysis)
-
(Here)
Fun - Prime Factorization
-
(Here)
Fun - Query Generated Calendar
