Posts Tagged ‘full outer join’

Oracle 11g: Another New Algorithm

By Grégory Guillou — October 11th, 2007 at 10:50 am
Posted in Group Blog Posts • Oracle
Tags: •

If you are or have ever been a SQL developer, it’s very likely you’ve been asked to return the rows from two joined tables, including all the rows from both tables that do not have a corresponding row in the other table. Oracle 9i introduced the FULL OUTER JOIN syntax to better address this scenario. Now it looks as if 11g has introduced a new algorithm to handle that.

So how can you get a look at this? (more…)

/* be the first to comment */