Re: create table with null value

I explain.
I have a table toto with 2 columns col1, col2. I want to create a table toto2 (col1, col2, col3) [Quoted] And then insert into toto2 select col1, col2, null from toto.

I want to insert the values at the creation of the table such as : create table toto2 as select col1, col2, null from toto.

How it is possible ??

"Séb" <spribetich_at_auchan.com> wrote in message news:b32u20$1qk$1_at_reader1.imaginet.fr...
> 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 - 17:26:25 CET