select mysequence.currval from dual;
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Andre Grosse" <ag17_at_inf.tu-dresden.de> wrote in message
news:3C8DE6A3.1030309_at_inf.tu-dresden.de...
> under MS-SQL 'SELECT @@IDENTITY' delivers the last generated autoindex
> value of any table in the current session.
> i know, how to emulate MSSQL-like autoindices with sequences und
> before-insert triggers, but how could i emulate this 'SELECT
> @@IDENTITY', i.e. with something similar like 'SELECT ???IDENTITY???
> FROM DUAL'?
> i have some problems with the session context. any ideas?
>
>
> --
> Andre Grosse
>
Received on Tue Mar 12 2002 - 05:39:35 CST
