Re: index

See the FAQ below.

    Search for AUTONUMBER.

Note - this question has come up twice
in this forum in the last seven days.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



Rainer Wiener wrote in message ...


>Hi,

>

>I search for an create table option to set a id number to the next

>number if there is no id given. So like this. there are id numbers

>from 1-10 and in the next entry there is no id set so it should

>automaticly get the 11 and so on. Is there a way to let make oracle

>this by itīs self or must I control this by my interface?

>

>thx for any help.

>

>cu

>Rainer