Oracle InsertId

[Yamakazi]

Hello again,

We are migrating from a MySQL DB to a Oracle DB.

Now i used to have a auto increment on MySQL and it worked fine. During the mirgation i created a sequence on those tables and a trigger and that works fine.

Now my question: i used to use the mysql_insertid() function to get the insert id but in the oracle functions i'm using there doesn't seem to be an equivalent. Has somebody solved this problem? i don't know that much about Oracle yet so it may be a simple question. Maybe there is a query you can fire to get that id or something.

TIA

[ultraslacker]

http://www.weberdev.com/ViewArticle.php3?ArticleID=84

[Yamakazi]

Thx for the link but this is what I had. My problem differs from this one.

I got all of that working my problem is i need to know that Ali G got ID 1 in PHP.

If you would do this with mysql the function mysql_insertid will give 1. I need the equivalent for Oracle.

[nemonoman]

Look into oracle SEQUENCES. I don't remember the exact syntax, but the keyword to look up is NEXTVAL