Re: max columns per table?

From article <1993Aug6.081915.18786_at_dk.oracle.com>, by bengsig_at_dk.oracle.com (Bjorn Engsig):

> Article <23s4kj$lh2_at_crl.crl.com> by mcgredo_at_nntp.crl.com (Donald R. McGregor) says:
 

> |What's the maximum number of columns allowed per table in Oracle?
> |If it varies by server version, is this stored in the system tables
> |anywhere?
 

> That's 254 in version 6 and 7. All limits are listed in appendix H in the
> V6 DBA guide, and appendix D in the ORACLE7 Server adm. guide. As far as I
> remember, the limit was also 254 back in version 3, 4, and 5.

All such limits (including e.g. maximum length of an error message returned by oermsg()) should also be defined in header files for use by applications using embedded SQL, but I don't think they are.

  __   __    Paul Singleton (Dr)           JANET: paul_at_uk.ac.keele.cs
 |__) (__    Computer Science Dept.        other: paul_at_cs.keele.ac.uk
 |  .  __).  Keele University, Newcastle,    tel: +44 (0)782 583477 << NEW for
             Staffs ST5 5BG, ENGLAND         fax: +44 (0)782 713082     1993