Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: create table with null value
Try
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:Received on Thu Feb 20 2003 - 11:45:49 CST
> 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 ???
>
>