Re: Newbie: Max no. of fields?
Date: 1995/06/12
Message-ID: <3rhbnj$c8e_at_tpd.dsccc.com>#1/1
Mr Robert J Canner (rmjdrjc_at_rs6-svr-1.pubhealth.ucl.ac.uk) wrote:
:> What is the maximum number of fields Oracle will handle
:> in one table/database?
:> I currently use dBase/Clipper/FoxPro which often
:> give me limits of about 128 or 256 fields.
:> I would like to have several hundred or several thousand
:> fields . . .
255 or 256 I forget which.
I would find it very hard to believe you require them in a correctly
normalized database. Just looking at your return address, the database
would have lookup tables for city, street, person, and STD.
Next you would have intersect tables for
person/STD
person/contacts (which points back to the person table)
The person table
would have keys from city and street and the other fields would
be first/last/middle name, age, sex, ...
-- This posting represents the personal opinions of the author. It is not the official opinion or policy of the author's employer. Warranty expired when you opened this article and I will not be responsible for its contents or use.Received on Mon Jun 12 1995 - 00:00:00 CEST