MySQL -> Oracle

[Anon]

Hello, i'm converting a PHP-driven site from using a MySQL database to using a Oracle 8 database instead, BUT: i cant seem to find any replacemwnt for the MySQL auto_number ... Anyone know if it excists such a operator in Oracle ??

In advance Thanks!

[[deleted]]

Yes it exists. 'real' databases like oracle call it 'sequence'.

It's not a column type, its define as a property of the table. Also, unlike MySQL, Oracle can you have several sequences per table, so you have to make sure you are using the right one.

Read more about it in the oracle documentation.