oracle 8 and auto increment

From: Thorsten Ottosen <nesotto_at_cs.auc.dk>
Date: Tue, 1 Mar 2005 14:24:20 +0100
Message-ID: <42246db5$0$29284$14726298@news.sunsite.dk>

Hi All,

I'm converting some mssql code to oracle 8. In mssql we can say IDENTITY (1,1) to make unique incrementing column for use as row ID.

In oracle 8 we use sequences and triggers. My question is how do I get the last ID that was generated? (This is done by @@IDENTIY in mssql).

Thanks in advance

Thorsten

-- 
Thorsten Ottosen
----------------------------
www.dezide.com
www.cs.aau.dk/index2.php?content=Research/bss
www.boost.org
www.open-std.org/JTC1/SC22/WG21/

Received on Tue Mar 01 2005 - 07:24:20 CST