Re: sequences

From: Andre Grosse <ag17_at_inf.tu-dresden.de>
Date: Tue, 12 Mar 2002 12:45:44 +0100
Message-ID: <3C8DEA68.2030707@inf.tu-dresden.de>

imho thats by far not the answer.

i look for the last generated sequence number in the whole session, not for a special table in all sessions.

this solution pays attention to session context? if 2 parallel jdbc connections write...you see?

-- 
Andre Grosse


Niall Litchfield wrote:


> 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?
>>

Received on Tue Mar 12 2002 - 05:45:44 CST