I have a empty table A that I am trying to populate.

Insert into A(primary_key, Name)
Select sequence.NEXTVAL, name
From Table B

The problem is that name in B have duplicate values and I cant use DISTINCT with SELECT because of the sequence. How do I make name distinct and still populate the primary key with the sequence.

Any help would be great!!! Thanks!!!

I am not sure but may be you can create another table C based on table B.
Create table C
SELECT DISTINCT name FROM table b;
Then
Insert into A(primary_key, Name)
Select sequence.NEXTVAL, name
From Table C

Try if this works.

Regards,
Mahesh Kumar

I'm rusty with my SQL, but couldn't you do this?

INSERT INTO A(primary_key, Name)
SELECT sequence.NEXTVAL, name
FROM SELECT DISTINCT name
FROM B;

INSERT INTO A(Primary_key, Name)
SELECT
XX.NextVal
,XX.Name
FROM (SELECT
MIN(sequence.NEXTval) AS NextVal
,Name
FROM TABLE B
GROUP BY Name) XX