Re: create table with null value

Séb (spribetich_at_auchan.com) wrote:
: Hello,
: When I create a table toto2 as
: select
: col1,
: col2,
: null col3
: from toto;

: I have the error 'column with length equal to zero is not possible'.

: How can I do that ???

E.G.

	create table try2
	as 
	select 1 ONE
	     , 2 TWO
	     ,  decode(rownum,-1,' ','') THREE
	from dual ;

SQL> select * from try2 where three is null ;

       ONE TWO T
---------- ---------- -

         1 2

1 row selected. Received on Thu Feb 20 2003 - 14:50:33 CST