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 -> what value to use in NVL for columns that may contain a NULL

what value to use in NVL for columns that may contain a NULL

From: NeelSing <bytetwo_at_hotmail.com>
Date: 13 Sep 2001 11:31:19 -0700
Message-ID: <d3852a1b.0109131031.66eb3eef@posting.google.com> 





In Pro*C, 


EXEC SQL DECLARE myCursor CURSOR FOR


 SELECT NVL( db_field, ??),



            ...

            ...



so that I may detect the value read as an empty string



strcmp(var_db_field_read_in, "") == 0


...


Please suggest.



Cheers!
Received on Thu Sep 13 2001 - 13:31:19 CDT












Original text of this message













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