Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Null and empty string program? ( Urgent !!! )
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
SQL>
--
-cheers
DW
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Mar 09 2000 - 15:22:54 CST