DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2000
    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

    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.


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.