sequences

From: Andre Grosse <ag17_at_inf.tu-dresden.de>
Date: Tue, 12 Mar 2002 12:29:39 +0100
Message-ID: <3C8DE6A3.1030309@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:29:39 CST