DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: null column in table

  1. #1
    Join Date
    Nov 2000
    Posts
    14

    Exclamation

    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.

  2. #2
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    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.

  3. #3
    Join Date
    Nov 2000
    Posts
    14
    then how is it possible in creating a view with a null value giving a alias.

  4. #4
    Join Date
    Jul 2000
    Posts
    296
    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
  •  


Click Here to Expand Forum to Full Width