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

Actually I didn't remember to tell that the problem should be solved without assumption of specific database. At a moment the database is ORACLE.
Some day it is possible that it is some other database. The solution should work with standard SQL (was it 92, I do not remember)

So, is the answer still the same?

"Gabriel Gonzalez" <no-spam_at_no-spam.com> wrote in message news:J_6dncZNfLSQDfqjXTWcjg_at_giganews.com...
> > 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 - 13:16:49 CST