Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Server Autonumber equivalent in Oracle 8i
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 - 12:08:33 CST