Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Why Oracle don't have AUTO_INCREMENT as in MySQL

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

From: howa <howachen_at_gmail.com>
Date: 14 Apr 2007 20:44:28 -0700
Message-ID: <1176608668.259483.173360@d57g2000hsg.googlegroups.com> 





> No. Oracle has something called SEQUENCE which isn't bound to any

> column, or table. THIS is very handy.

>

> --

> Sybrand Bakker

> Senior Oracle DBA




i agreed SEQUENCE is flexible, but in 99% of my applications,
AUTO_INCREMENT is far than enough.



so i just wonder why Oracle implements like this.



i heard before using SEQUENCE will have some benefits related to
performance, but i forgot...
Received on Sat Apr 14 2007 - 22:44:28 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US