On Jul 29, 2007, at 7:00 , roopa perumalraja wrote:
I would like to know if its possible to increment the primary key
field value of stocks table without using sequences by getting the
next value of the pk field from the sequnce table ?
Why? Any other solution will cause performance issues
Hi all,
I would like to know if its possible to increment the primary key field value
of stocks table without using sequences by getting the next value of the pk
field from the sequnce table ?
insert into stocks (prim_id, date,time, code, price, volume) (select .
from temp_stocks
