Printable View
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.
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.
then how is it possible in creating a view with a null value giving a alias.
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.