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

Home -> Community -> Usenet -> c.d.o.server -> Re: I need to test whether I am getting a result back from a query is it possible?

Re: I need to test whether I am getting a result back from a query is it possible?

From: John Chiu <johnc_at_relsol.com>
Date: Thu, 30 Sep 1999 11:51:16 -0400
Message-ID: <7t00iu$gmn$1@newsmaster.pathcom.com> 





Yes, because there is no row returned from the query.



John Chiu




tony wrote in message ...


>I need to determine if I get a value back from a query, it there is a value


I


>use it, otherwise I want to put a string value.  I tried


>


>decode(A.SUPPLIER, NULL, 'NFP', A.SUPPLIER)


>


>and


>


>nvl(A.SUPPLIER, 'NFP')


>


>but I get no results back.


>


>is that because when there is no data I don't really get a null? what can I


>look for to do this




Received on Thu Sep 30 1999 - 10:51:16 CDT












Original text of this message













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