null column in table

[gsweta]

in mind benders, on this site, u have specified that a view can be created with a null as a column ie create view myview as select null a from dual,
when i try the same on creating a table with a null coulmn it does not accept why is it so? can anyone pls. answer this.

[raghucharan]

When u creating a table with column name 'null','null' is a key word here while creating .

Even if u try creating a table with column 'null' as select clause from another table with an alias,it wont allow u to create that table.

[gsweta]

then how is it possible in creating a view with a null value giving a alias.

[akkerend]

Creating a table with null column is impossible, because columns need a length in Oracle. There is no problem is selecting null, and a view is basically a select statement.