Oracle 11g RAC On Windows 2003 Using VMware Server

11g on Windows (32-bit) is out!

How to Give Your System a Break from Oracle XE

How to install 10g on various Linux Distributions

# 10g Release 2 on Centos 5 (and hence on RHEL5 generally)
# 10g Release 2 64-bit on 64-bit Linux (the one exception to the above rule!)
# 10g Release 2 on Fedora 7 64-bit
# 10g Release 2 on Oracle Enterprise Linux
# 10g Release 2 on Solaris 10 (x86)
# 10g Release 2 on Centos 4.x (and hence RHEL4 generally)
# 10g Release 2 on Suse 10 (works unchanged for Suse 10.1 and 10.2, too)
# 10g Release 2 on Ubuntu (describes Ubuntu 5.10 and 6.06)
# 10g Release 2 on Fedora Core 5

Installing Oracle 11g RAC on virtual servers using VMware

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

Backing Up Apex Application(s)

Are you looking for a way to automate the task of exporting applications?
1. Automatically Backing Up Your Apex Application(s)
2. Java export utility

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

Now I'm official technorati member :)
Technorati Profile

Implementing AJAX into APEX applications

Create dynamic interfaces that minimize page refresh with Oracle Application Express.
Step-by-Step Instructions for Adding Tooltips