Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: create table with null value

Re: create table with null value

From: Séb <spribetich_at_auchan.com>
Date: Thu, 20 Feb 2003 17:26:25 +0100
Message-ID: <b32ur9$23b$1@reader1.imaginet.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US