On Aug 16, 7:04 pm, Serge Rielau <srie...@ca.ibm.com> wrote:
> Rahul B wrote:
> > It fails in DB2, but works in Oracle.
>
> What's the type of such a NULL in Oracle?
> If I do:
> CREATE TABLE T(c1) AS (SELECT NULL FROM DUAL)
>
> What is c1?
>
> Cheers
> Serge
>
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab

Hi,

It seems we cannot create a table in Oracle with null as a column but
only a view or a simple select statement like
select null as xyz from dual;

It gives the error saying zero length columns are not allowed.

Rahul