Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Server Autonumber equivalent in Oracle 8i

SQL Server Autonumber equivalent in Oracle 8i

From: Robert Martin <rwmartin_at_sisconet.com>
Date: Mon, 20 Nov 2000 10:38:52 -0500
Message-ID: <8vbgkh02kif@enews3.newsguy.com>

I am a newbie to Oracle and I have read that I can create an SQL Server Autonumber equivalent by using a sequence and a trigger. My problem is, I have never written a trigger. I created my sequence, and from the looks of it in the OEM it appears to be fine. How do I write the trigger? Does anyone know of any good documentation on the net on writing Oracle triggers? Please help. Thanks :)

Oh and I am working in NT



Robert Martin (rwmartin_at_sisconet.com)
Design Engineer
SISCO Inc,
6605 19 1/2 Mile Road
Sterling Heights, MI 48314-1408
Phone : 810-254-0020 (ext 125)
Fax : 810-254-0053 Received on Mon Nov 20 2000 - 09:38:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US