Re: create table with null value

From: Andrew Allen <andrew.allen_at_handleman.com>
Date: Thu, 20 Feb 2003 17:45:49 GMT
Message-ID: <3E550741.3020206_at_handleman.com>


Try
[Quoted] [Quoted] create table toto2 as select col1, col2, col3 from toto where 1=2; insert /*+ APPEND */ into toto2 select col1, col2, NULL from toto;

--
Andrew Allen

Séb 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 ???
>
>
Received on Thu Feb 20 2003 - 18:45:49 CET

Original text of this message