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

http://stackoverflow.com/questions/18738101/how-to-acess-locally-installed-oracle-11-g-throught-pl-sql-developer-9

Objective/Problem:

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

http://www.dba-oracle.com/t_sql99_with_clause.htm

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