Re: Why Oracle don't have AUTO_INCREMENT as in MySQL

On Sat, 14 Apr 2007, damorgan_at_psoug.org wrote:
> howa wrote:

>> Seems AUTO_INCREMENT is very handy and natural, anyone agree?

Has its merit. I like the way sequences are not tied to a single table. Gives one much more flexibility.

> No. Autoincrement is a brain-damaged way of creating surrogate
> keys.

And what, may I ask, is the non-brain damaged way of using sequences?

-- 
Galen Boyer