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
>
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
