Re: 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 > 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 only thing i can imagine is to give this function > the name of ID column and read name of table with regex and then do > select max(parametar_id) from regex_table > and then to do commit , > this way is somehow realy stupid but is my only solution in this moment so > if you have any better ideas plese help > > almir > > > >