oracle last inserted
| From: | almir | Date: | Sat, 24 Mar 2001 23:08:13 +0000 |
| Subject: | oracle last inserted | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-45452@lists.php.net to get a copy of this message | ||
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