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: Null Field Displays Value

Re: Null Field Displays Value

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 31 Oct 2002 09:11:31 -0800
Message-ID: <2687bb95.0210310911.e4cdea5@posting.google.com>


robert.b.clodfelter_at_verizon.com (Ben Clodfelter) wrote in message news:<572dcbb0.0210301128.612cad0f_at_posting.google.com>...
> I have a table that has a number field that is nullable. There are 3
> records in the field. The number field is null in every record. If I
> select all records from the table where the number field is NULL it
> returns 3 rows and displays the number field as null. If I select all
> of the fields from the table specifying each field name the number
> field is displayed with the letter n in it.
>
> Select number_field from mytable where number_field is NULL;
>
> This returns the null value
>
> select abc, number_field, xyz from mytable;
>
> This displays an 'n' in the number_field column.
>
> Has anyone seen this before.
>
> TIA
Ben is the table really a view? If so the author could be setting the values for nulls with the nvl or decode functions. If it is not a view then Srivewu was probably correct and the "show null" command will give you the current setting for displaying null values in SQLPLUS. UT1> show null
null ""
UT1>

HTH -- Mark D Powell -- Received on Thu Oct 31 2002 - 11:11:31 CST

Original text of this message

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