Oracle SQL question

From: Michael Francis Horrocks <M.F.Horrocks_at_informasa.es>
Date: Fri, 14 Jan 2000 13:20:46 +0100
Message-ID: <387F149E.E3B58C5E@informasa.es>

All,

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 1.499 rows 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 Fri Jan 14 2000 - 06:20:46 CST