SQL table create w/ concat key?

[ThatRickGuy]

Anyone out there know the SQL (Oracle 8i style) to make a table with a concat Primary key?

like in a linking table, where each of the fields will have repetitions in itself, but the 2 fields together will be unique.

ex:
A | B
-----
1 | 1
1 | 2
1 | 3
2 | 1
2 | 2
2 | 3

 

[karluk]

If your table already exists:

alter table your_table add constraint pk_1 primary key (a, b);

If you are creating the table:

create table your_table(a varchar2(10) not null, b varchar2(10) not null,
constraint pk_1 primary key (a, b));