Generate an auto increment primary key in Oracle

[Anonymous]

I want to create a primary key auto increment under oracle!
I had created an output table (Oracle)  and  I want to add an automatic primary key! how can I do that ?


 

[Anonymous]

Use an oracle sequence. This demonstrated reasonably well here ( https://help.talend.com/search/all?query=Using+an+Oracle+sequence+while+inserting+data&content-lang=...)

[Anonymous]

 Thanks for your reply but it doesn't work ! I get this error 
ORA-00957: duplicate column name

[Anonymous]

You are adding an extra ID column. Your schema already includes it and you are adding a new one with your advanced settings. Change the "Before" to "Replace" in the advanced settings.

[Anonymous]

Even when I change the "Before" to "Replace", I still get the same error 😕  

[Anonymous]

Simply set the ID column in the schema as inactive or better remove it.

[Anonymous]

You need to change "Colonne de ref" to "ID" if you haven't. You are essentially replacing the value that would have been placed in this column with the next value of the sequence. 
EDIT: ....or do what Jlolling said. Either will work