title: Oracle Database. Insert a copy of a row to the same table (Duplicate key error message)
body: <p>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: </p>
  
  <blockquote>
    <p>An UPDATE or INSERT statement attempted to insert a duplicate key.</p>
  </blockquote>
  
  <p>This is query I am using: </p>
  
  <pre><code>INSERT INTO GAME (SELECT * FROM GAME WHERE NAME = 'Texas Holdem');
  </code></pre>