Insert/Update entire rows?
From: Ken Halsted <kenman_at_mail.snider.net>
Date: Thu, 29 Jul 1999 08:21:22 -0500
Message-ID: <rq0lde$0$37nspbj$n2p_at_corp.supernews.com>
[Quoted] I was wondering if someone can tell me if it's possible to insert/update an [Quoted] entire row using PL/SQL if all I want to change is one column which is part [Quoted] of the key. I basically want a duplicated row with a different key. Is there an easy way to do this without having to specify every column?
Date: Thu, 29 Jul 1999 08:21:22 -0500
Message-ID: <rq0lde$0$37nspbj$n2p_at_corp.supernews.com>
[Quoted] I was wondering if someone can tell me if it's possible to insert/update an [Quoted] entire row using PL/SQL if all I want to change is one column which is part [Quoted] of the key. I basically want a duplicated row with a different key. Is there an easy way to do this without having to specify every column?
One more time:
I am reading a row by using a cursor. I want to change a key columns value.
[Quoted] I then want to insert/update into the exact same table all values except one
[Quoted] key column which will make it unique.
Thanks for any help at all.
KenMan.
-- _________________ Kenneth W. Halsted Mountaire Corporation ph: (501) 399-8812 url: http://www.mountaire.com email: kenman_at_mail.snider.netReceived on Thu Jul 29 1999 - 15:21:22 CEST