Re: Question about adding new record in table with primary key

> What do you mean with the "sequence" here and how can I use it for this
> task?

Here I'll ask you to RTFM (read the freekin' manual). Go to technet.oracle.com and read the documentation. Search for "sequence" or "create sequence"

How to use it? Simple (you'll understand this example as you erad the manuals):

select my_sequence.nextval into tmp from dual; insert into my_table (id, other value) (tmp, 'whatever');

You have some reading to do... Received on Thu Mar 06 2003 - 12:18:03 CST