Oracle join operator

How to rewrite this:

select tab1.id, tab2.id, tab3.id 
from tab1, tab2, tab3 
where tab1.col1 = tab2.col1(+) and tab2.col2 = tab3.col2(+);

using OUTER JOIN syntax?

Answers


select tab1.id, tab2.id, tab3.id 
from tab1
left outer join tab2 on tab1.col1 = tab2.col1
left outer join tab3 on tab2.col2 = tab3.col2;

Need Your Help

How do I check a string, using python, against some specific ABNF rules?

python regex python-2.7

I need to check a string if is in conformance with this rules: http://www.w3.org/TR/widgets/#zip-rel-path

JNA: conversion between void** and void*

java c jna ftdi jnaerator

I generated a JNA from a header file and here is the two functions of interest.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.