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

On Wed, 25 Apr 2007, damorgan_at_psoug.org wrote:

> The problem with autoincrementing, to repeat myself, is lack of
> flexibility. Consider the implications of autoincrementing on RAC
> and Data Guard or numerous other Oracle technologies not implemented
> in those other products. It could be a potential nightmare keeping
> things in synch.

So I guess the usage of sequences in Oracle is risky at best? Considering the implications of using sequences for autoincrementing on RAC and Data Guard ... (you know, the PL/SQL kind of autoincrementing with sequences which you posted in this very thread with)

-- 
Galen Boyer