Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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)
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 - 10:26:25 CST