Re: VARCHAR vs NUMBER

Richard Frazier (rfrazier_at_mailstorm.dot.gov) wrote: [Snip!]
: We have applications that generate case id codes by simply
: selecting max(id) +1.

Are you serious ? You might get away with it, providing :-

1. the table is small, or there is an index available AND
2. the concurrency doesn't get you - I can see the potential for duplicates here ...

What is the aversion to using sequence generators, which are fast, efficient and don't have concurrency problems ?

--
Mark Bluemel	Unix/Oracle Trainer and Consultant
		My opinions are my own, but I'll share them
		All solutions to problems are offered "as is"
		and without warranty - you have been warned :-)