Re: create table with null value

> 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 ???

On 9i you can do it like

create table toto2 as
  select
    col1,
    col2,
    cast(null as varchar2(5)) col3
  from
    toto;

hth

Rene Nyffenegger

BTW: crosspost to c.d.o.tools removed.

-- 
  no sig today