-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|