Re: sequence
From: willevolve <member27377_at_dbforums.com>
Date: Sat, 14 Jun 2003 10:12:00 +0000
Message-ID: <3002504.1055585520_at_dbforums.com>
Date: Sat, 14 Jun 2003 10:12:00 +0000
Message-ID: <3002504.1055585520_at_dbforums.com>
If I have a table like:
create table my_table
(
spec_id,
spec_num,
...
)
and then create a primary key like:
alter table task add primary key (spec_id, spec_num)
How do i build a seqence?
spec_id is a foreign key to another table spec_num should be a sequence number within spec_id
examples of spec_id, spec_num combinations:
131, 1 131, 2 131, 3 132, 1
same problem
-- Posted via http://dbforums.comReceived on Sat Jun 14 2003 - 12:12:00 CEST