Hello All,

 Please help us to write a query to insert rows without having unique constraint error.
Requirement is insert following 8 activites to all 5 projects listed below. Provide generic query which will help us for other projects as well. 
Note: Ativites are only 8 and will not change i.e we can hard-code them in query. And assume projects and activities are provided in Excel.
I will use excel formulas for insert statements for each project with given 8 activities.

Activities List:
TOWER
ELECTRICAL
WOODWORK
PAINTING
FLOORING
PLUMBING
KITCHEN
MAINHALL

Projects:
123456
123457
123458
123459
123450

Create a table.

[code]

SQL> CREATE TABLE project_tbl (project_id VARCHAR2(11) NOT NULL,  activity_id VARCHAR2(10) NOT NULL);

Table created

[/code]

create a PRIMARY KEY constraint on "project_id" and "activity_id" columns.

[code]

SQL > ALTER TABLE project_tbl ADD PRIMARY KEY (project_id, activity_id);

[/code]

Insert rows into table.

[code]

Insert into project_tbl values ('123456', 'TOWER');
Insert into project_tbl values ('123457', 'ELECTRICAL');
Insert into project_tbl values ('123458', 'WOODWORK');
Insert into project_tbl values ('123459', 'PAINTING');

SQL> Insert into project_tbl values ('123456', 'TOWER');

1 row created.

SQL> Insert into project_tbl values ('123457', 'ELECTRICAL');

1 row created.

SQL> Insert into project_tbl values ('123458', 'WOODWORK');

1 row created.

SQL> Insert into project_tbl values ('123459', 'PAINTING');

1 row created.

[/code]

Output would be like, if take project 123456, it should have all rows along with the one we inserted in above insert statement.

Thank You!