Re: Autonumbering

Kingsley Sawyers wrote:

> This is done by creating a Sequence object, which can de referred to in the
> insert query. Check out the 'CREATE SEQUENCE' command.

OK, I've had a look, it seems that will do the job. Next question is, where do I declare/define it, and when do I run the SQL code (presumably stored in a .sql file)? At database creation time? From within the database creation script?
Records will be added via the web (using PHP), if that makes any difference.

Thanks,

• Kev

>
>
> 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