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: Is there a better way than two "exists" and a union?

Re: Is there a better way than two "exists" and a union?

From: Michael Bialik <bialik_at_isdn.net.il>
Date: 15 Mar 2002 05:51:11 -0800
Message-ID: <969f8022.0203150551.9aba72d@posting.google.com> 





Try



SELECT top.*, NVL((SELECT 'YES' FROM childoftop WHERE ct_top_id =
top_id AND ROWNUM = 1),'NO') FROM top



HTH. Michael
Received on Fri Mar 15 2002 - 07:51:11 CST












Original text of this message













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