Re: SQL Server Autonumber equivalent in Oracle 8i
Date: Mon, 20 Nov 2000 18:08:33 GMT
Message-ID: <8vbpap$mjr$1_at_nnrp1.deja.com>
In article <8vbgkh02kif_at_enews3.newsguy.com>,
"Robert Martin" <rwmartin_at_sisconet.com> wrote:
> 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
My question is very similar to yours. See: creating sequence for autonumber. I am too wondering about triggers. I will let you know what I can find out.
JIm
> -------------------------------------------
> 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
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Nov 20 2000 - 19:08:33 CET