Oracle Database. Insert a copy of a row to the same table (Duplicate key error message)

Question

In Oracle database I have one table with primary key GAME_ID. I have to insert a copy of a row where game_name = 'Texas holdem' but it tells me:

An UPDATE or INSERT statement attempted to insert a duplicate key.

This is query I am using:

INSERT INTO GAME (SELECT * FROM GAME WHERE NAME = 'Texas Holdem');

Answer 1

Assuming your game_id is generated by a sequence, you can get a new as part of the select statement:

INSERT INTO GAME (game_id, name, col_3)
SELECT seq_game_id.nextval, name, col_3
FROM GAME 
WHERE NAME = 'Texas Holdem';

Answer 2

Let me just offer a slightly more abstract point of perspective...

• In a relational database, table is a physical representation of the mathematical concept of relation.
• Relation is a set (of tuples, i.e. table rows/records).
• A set either contains given element or it doesn't, it cannot contain the same element multiple times (unlike multiset).
• Therefore, you can never have two identical rows in the table, and still call your database "relational".¹

You can insert a similar row through, as other answers have demonstrated.

---

¹ Although practical DBMS (including Oracle) will typically allow you to create a table without any key, making identical duplicates physically possible. However, consider it a big red flag if you ever find yourself doing that.