Re: Autonumbering

From: kev <kevin.porter_at_fast.no>
Date: Mon, 26 Jul 1999 17:22:17 +0100
Message-ID: <379C8B39.79870D91@fast.no>

Steve Dancisin wrote:

> Plus a tigger on the table.
>

Oh dear. I am, of course, a bit of a newbie. So: What's a trigger?
Do I need one in this case?

ta,

>
> -sd
>
> Kingsley Sawyers wrote in message <7nhu31$po3$1_at_lure.pipex.net>...
> >This is done by creating a Sequence object, which can de referred to in the
> >insert query. Check out the 'CREATE SEQUENCE' command.
> >
> >Kingsley
> >
> >kev wrote in message <379C79EA.3CA8B12A_at_fast.no>...
> >>Hi,
> >>
> >>I'm designing a database and need the id fields of my tables
> >>Autonumbered (ie incremented with every 'insert into...'.
> >>This is automatic on, say, M$ Access, but how do I do it in Oracle?
> >>
> >>- Kev
> >>
> >
> >

--
Kevin Porter
Web Programmer
FAST Web Media
Suite 320, Sunlight House, Quay St, Manchester England, M3 3JZ

Phone: 44 (0) 161 835 3525
Email: kevin.porter_at_fast.no

Home Page:              http://www.fast.no

All The Web:            http://www.alltheweb.com

FAST FTP Search:        http://ftpsearch.lycos.com

FAST MP3:               http://mp3.lycos.com

FAST Soccer:            http://www.fa-premier.com

FAST Entertainment:     http://www.innit.com

Received on Mon Jul 26 1999 - 11:22:17 CDT