Re: create table with null value
From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 20 Feb 2003 12:50:33 -0800
Message-ID: <3e553f99_at_news.victoria.tc.ca>
Date: 20 Feb 2003 12:50:33 -0800
Message-ID: <3e553f99_at_news.victoria.tc.ca>
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'.
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 - 21:50:33 CET