SQL Techniques Tutorials: Columns to Rows

SQL Snippets: Tutorials for Oracle Developers

Home SQL Features SQL Techniques Miscellany About Blog Site Map

- SQL Techniques
+	Columns to Rows
+	Columns to String
+	Custom Feedback Messages
+	Hierarchical Selective Expansion
+	Integer Series Generators
+	Pattern Matching Over Rows
+	Rows to Columns
+	Rows to String
+	Serial Numbers
+	String to Columns
+	String to Rows
+	Transformations
+	Varying IN Lists

Next >

Columns to Rows:

Read Using SQL Snippets before using any of this site's code or techniques on your own systems.

Columns to Rows

This section presents techniques for transforming a single row of data with values in multiple columns, like this one

KEY C1    C2    C3
--- ----- ----- -----
r1  v1    v2    v3

into multiple rows with values in a single column, like this.

KEY SOURCE VAL
--- ------ -----
r1  C1     v1
r1  C2     v2
r1  C3     v3

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-12027.html]SQL Snippets: SQL Techniques Tutorials - Columns to Rows[/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-12027.html">SQL Snippets: SQL Techniques Tutorials - Columns to Rows</a>

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

Link Text : SQL Snippets: SQL Techniques Tutorials - Columns to Rows
URL (href): http://www.sqlsnippets.com/en/topic-12027.html

Ads by NSC Cards

Mabel's Labels™-- Labels for the stuff kids lose!™

Ads by Joe

Pay it Forward

Did the free information on this site help you? Consider repaying the favour by helping others.

Next time you see a discussion forum question or blog topic about something you've seen covered on SQL Snippets help out by replying with a link to the SQL Snippets topic.

It's easy to do. Simply cut and paste code from the Linking to SQL Snippets section at the bottom of this page.

Terms and Conditions of Use Disclaimer Privacy Policy

This page was first published on April 5, 2007.

This page was last updated on November 18, 2007.

The views expressed on this site are my own and do not necessarily reflect the views of Oracle.

Columns to Rows:

Columns to Rows

Tags

Linking to SQL Snippets