Re: DATA TYPES

rt@astro.ocis.temple.edu (rt@astro.ocis.temple.edu) wrote: : Which data type is most suitable for serial numbers that you expect to : hit 100,000 and more in the course of at least 2 years. Integer is : definately out for a column data type since it will max out and roll : over at about 37600 something. You will get some interesting queries : there! :-) Any suggestions? One of my clients uses NUMBER(9,0) for quite a few years (moyabe more than 10 years) and they haven't have any problem so far. It was used to create unique ID from a common sequence generator. The application I am working with chew up more than 100,000 sequence a month! Another application uses 6-7 million of sequences every quarter (when the lookup tables gets updated -- yep, one of them is a huge lookup table). ----------------------------- (Whatever I say and own are mine, mine and only mine! So, don't you dare claim they are yours!) Kim Ng Paradigm Computer Consulting, Inc. 20611 E Bothell-Everett Hwy SE, Suite 280 Bothell, WA 98012 U.S.A.