SnippetyJoe's Blog
Happy First Anniversary SQL Snippets!
And Now for Something Completely Different
Google Street View
Getting IT Right
The Task Spiral
The Choice
It's Alive!
You Find Snippets in the Strangest Places
The Journey Begins
About SnippetyJoe

SQL Techniques Tutorials
Columns to Rows
UNPIVOT (11g)
UNION ALL Method
Collection Method
MODEL Method
Performance Comparison
Setup
Cleanup
Columns to String
Comma Separated Values (CSV)
XML Fragments
Setup
Cleanup
Custom Feedback Messages
Changing the Footer
Changing the Header and Footer
Other Techniques
Setup
Cleanup
Hierarchical Selective Expansion
Method 1 - UNION ALL
Method 2 - FROM Clause Subquery
Setup
Cleanup
Integer Series Generators
Integer Table Method
MODEL Method
ROWNUM + a Big Table Method
CONNECT BY LEVEL Method
CUBE Method
CUBE Method - Explained
Type Constructor Expression Method
Type Constructor + Cartesian Product Method
Pipelined Function Method
Performance Comparison - Small Numbers
Performance Comparison - Large Numbers
Multiple Integer Series
Join Method
MODEL Method
CONNECT BY LEVEL Method
Setup
Cleanup
Pattern Matching Over Rows
String Aggregation
Finding Patterns using REGEXP Functions
Measures
Setup
Cleanup
Rows to Columns
Aggregating Values (11g)
Aggregating Values
Transposing One to One
Transposing Many to One
Transposing Many to One With Unknown Pivot Keys
Distributing Left to Right
Distributing Left to Right - Other Methods
Distributing Top to Bottom - 1
Distributing Top to Bottom - 2
See Also
Setup
Cleanup
Rows to String
MAX DECODE Method
LEAD Method
MODEL Method 1
MODEL Method 1 - Explained
MODEL Method 2
MODEL Method 2 - Explained
MODEL Method 3
MODEL Method 3 - Explained
Hierarchical Method
Hierarchical Method - Explained
Object Method
Object + MODEL
Tom Kyte's STRAGG
Tom Kyte's STRAGG - With Sorting
XML Method
XML - CSV Method
Other Techniques
Performance Comparison Charts
Setup
Cleanup
Serial Numbers
Serial Number Generator
Generator With INSERT Commands
Generator With UPDATE Commands
Generator With UPDATE - Exceptions
Generator With UPDATE - Gotchas
Precreated Serial Numbers
Precreated Serial Numbers - API Code
Acknowledgements
Setup
Cleanup
String to Columns
Fixed Format
Quoted Values
Quoted Values - 10g+
Separated Values
Separated Values - 10g+
XML Values - 1
XML Values - 2
Setup
Cleanup
String to Rows
UNION ALL Method
Integer Series Generator Method
Integer Series Generator Method - 10g+
Hierarchical Methods
Dynamic PL/SQL Method
MODEL Method
XML Method
Performance Comparison
Setup
Cleanup
Transformations
Numbers to Words
Setup
Cleanup
Varying IN Lists
Separate Variables Method
Dynamic SQL Method
LIKE Method
Integer Series Generator Method
MODEL Method
Setup
Cleanup

Linking to SQL Snippets

To link to this page in Oracle Technology Network Forums or OraFAQ Forums cut and paste this code.

[url=http://www.sqlsnippets.com/en/topic-10141.html]SQL Snippets: Site Map[/url]

To link to this page in HTML documents or Blogger comments cut and paste this code.

<a href="http://www.sqlsnippets.com/en/topic-10141.html">SQL Snippets: Site Map</a>

To link to this page in other web sites use the following values.

Link Text : SQL Snippets: Site Map
URL (href): http://www.sqlsnippets.com/en/topic-10141.html

SQL Snippets: Tutorials for Oracle Developers

Site Map

Linking to SQL Snippets