column sin views
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: column sin views

  1. #1
    Join Date
    Aug 2000
    Posts
    19
    Does anyone know if there is a cut-off as to how many columns one can use in a view? I am using Oracle 8.1.5.

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi

    A view is created on a table on one or more tables so Iam sure there is no cut off as to how many columns one can use in a view

    Simple View is created from a single table so Iam sure you can have all the columns and all rows if you need to which are there on the table

    Comples view is created from more then one table Iam not sure if there is restriction on the no of columns on this view I personally feel there should not be any restriction

    Once we had a table of 265 columns and we were able to create a simple view of all columns in that table.

    Regards
    Santosh

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