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: Null and empty string program? ( Urgent !!! )

Re: Null and empty string program? ( Urgent !!! )

From: DriftWood <drift_wood_at_my-deja.com>
Date: Thu, 09 Mar 2000 21:22:54 GMT
Message-ID: <8a94n7$52v$1@nnrp1.deja.com>


Additionally, an 'empty' varchar value will not be stored (you will get a NULL instead). This is peculiar to the VARCHAR2 data type:

SQL> create table test1 (value1 varchar2(10));

Table created.

SQL> INSERT INTO test1 VALUES ('');

1 row created.

SQL> COMMIT; Commit complete.

SQL> select * from test1;

VALUE1


SQL> select nvl(value1,'null') from test1;

NVL(VALUE1



null

SQL>
--

-cheers
  DW



"It is a kind of good deed to say well; and yet words are not deeds.   -William Shakespeare"

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 09 2000 - 15:22:54 CST

Original text of this message

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