Re: [PHP] oracle last inserted

On Mon, Mar 26, 2001 at 10:19:28AM +0800, Chien-pin Wang wrote: > > If you use sequence to generate your last_inserted_id, then you can always > get that ID by calling > > SELECT sequence_name.CURRVAL > FROM DUAL; > > within the same session. re, tc > > Chien

Re: [PHP] oracle last inserted

If you use sequence to generate your last_inserted_id, then you can always get that ID by calling SELECT sequence_name.CURRVAL FROM DUAL; within the same session. Chien-pin On Sun, 25 Mar 2001, almir wrote: > is there a way to get last inserted id from oracle as > mys

[PHP] oracle last inserted

is there a way to get last inserted id from oracle as mysql_inerted_id() or SELECT @@IDENTITY AS LastId in mssql server i have a function that does only that, takes insert statement and returns last id, but this function have to work for all tables (different triggers in oracle) , right now the