Access locally installed Oracle 11g through PL/SQL Developer 9


To make both oracle 11g(64-bit) (version 11.2) and PL/SQL Developer (version 10.0.2) work in the same machine because PL/SQL Developer needs 32 bit oracle client installed when oracle does not require client when working in local machine.

Read more of this post

SQL WITH clause tricks

Starting in Oracle9i release 2 we saw an incorporation of the SQL-99 WITH clause (a.k.a. subquery factoring), a tool for materializing subqueries to save Oracle from having to re-compute them multiple times.

The SQL WITH clause is very similar to the use of Global temporary tables (GTT), a technique that is often used to improve query speed for complex subqueries. Here are some important notes about the Oracle WITH clause:

Read more of this post