SQL problem
From: Michael Francis Horrocks <M.F.Horrocks_at_informasa.es>
Date: Mon, 17 Jan 2000 09:02:49 +0100
Message-ID: <3882CCA9.3B2B7524_at_informasa.es>
All,
Date: Mon, 17 Jan 2000 09:02:49 +0100
Message-ID: <3882CCA9.3B2B7524_at_informasa.es>
All,
[Quoted] I am a newbie DBA and one of my Users has laid the following
problem on my desk
can anyone help?
I have a table with the following columns:
field1 VARCHAR2(50) field2 LONG RAW (store graphical)
this table has 1,500 rows
The problem is that I have to update the long raw field in 1,4999 rows [Quoted] with the one row which is correct (I know which one is correct) How can I do it? I can't use sub queries with long raw type.
Regards,
Michael Received on Mon Jan 17 2000 - 09:02:49 CET