Browsing: PL/SQL


When I was confronted with the challenge to import about 260 tables from two different Rdb’s into a single Oracle…

Data Warehousing & BI
4 Pivoting in SQL using the 10g Model Clause

In this post we discuss pivoting of records in SQL – either splitting or merging records. Typically this is done using PL/SQL based Table Functioins, UNION (for splitting records) and fairly complex, tricky SQL statements. In Oracle 10g, using the MODEL clause, there is a clean, fairly straightforward way to achieve elegant pivoting – even nested pivoting – in single SQL statements. This post shows the pivot operation using the Model clause.

1 20 21 22 23 24