How to Install Oracle 11g Release 2 on OEL 5.4 on VirtualBox: Installing Grid Infrastructure

Installing Oracle 11g inside an Xubuntu Linux VMWare Image

Columns to Rows - UNPIVOT (11g)

Installing Oracle 11g RAC on virtual servers using VMware

This post describes the installation of Oracle 11g RAC on virtual servers.

How to install Oracle 11g on various Linux Distributions

11g on Redhat EL 4, 5
11g on Ubuntu 7.4
11g on Enterprise Linux
11g on Debian
11g on Centos 4.5
11g on Xubuntu 7.04

Pivot in 11g

Pivoting is a key technique in data warehouses. In it, you transform multiple rows of input into fewer and generally wider rows in the data warehouse. When pivoting, an aggregation operator is applied for each item in the pivot column value list. The pivot column cannot contain an arbitrary expression. If you need to pivot on an expression, then you should alias the expression in a view before the PIVOT operation. The basic syntax is as follows:

SELECT ....
FROM
PIVOT
(
aggregate-function()
FOR IN (, ,..., )
) AS
WHERE .....

Example: Pivoting

The following statement illustrates a typical pivot on the channel column:

SELECT * FROM
(SELECT product, channel, amount_sold
FROM sales_view
) S PIVOT (SUM(amount_sold)
FOR CHANNEL IN (3 AS DIRECT_SALES, 4 AS INTERNET_SALES,
5 AS CATALOG_SALES, 9 AS TELESALES))
ORDER BY product;

PRODUCT DIRECT­_SALES INTERNET_SALES CATALOG_SALES TELESALES
---------------------- ------------ -------------- ------------- ---------
...
Internal 6X CD-ROM 229512.97 26249.55
Internal 8X CD-ROM 286291.49 42809.44
Keyboard Wrist Rest 200959.84 38695.36 1522.73

Documentation here