Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: help in writing an sql

Re: help in writing an sql

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 2 Feb 2005 05:40:12 -0800
Message-ID: <1107351612.026596.183340@g14g2000cwa.googlegroups.com>


One way would be to do a full outer join, on tab1 where X with tab1 where Y (joining the table with itself). You would then need to use the nvl function in the decode statement. Received on Wed Feb 02 2005 - 07:40:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US