How to select a primary key?

From: Konrad Den Ende <konrad_at_voxway.com>
Date: Fri, 5 Jul 2002 12:12:48 +0200
Message-ID: <ag3rf0$17m$1@news.gu.se>

When i execute the example on Suns website: "INSERT INTO COFFEES " +
"VALUES ('Colombian', 101, 7.99, 0, 0)"); then everything is fine the first time.

What i expected it to do the next time i execute the very same line is to UPDATE row 'Colombian' with (the same) values provided.

To my amazment i get more and more rows with the same name. I understand that Oracle believs i don't want to use any primary key. Why? How to solve this?

--

Vänligen
Konrad
-------------------------------------------------------
URL: http://konrads.webbsida.com
E-Mail: konrad_at_voxway.com
Phone: (+46) 0708 - 70 73 92
ICQ: 132 250 451

Received on Fri Jul 05 2002 - 05:12:48 CDT