REPOST: Pivot and Crosstab Queries

Uncategorized
| Jan 25, 2007
Here is another advanced concept that will come in useful when solving Oracle problems. Imagine you're trying to create a result set where the rows need to be columns, or vice versa. In essence, you need to "pivot" rows into columns, or vice versa. That is a very common requirement, and this is where you need to look at a pivot (or crosstab) query to get the job done.As always, when you want

Replacef

A function to simplify string building and debugging by replacing multiple placeholders from a collection of inputs. January 2007