SQL problem

From: Michael Francis Horrocks <M.F.Horrocks_at_informasa.es>
Date: Mon, 17 Jan 2000 09:01:06 +0100
Message-ID: <3882CC42.52D0896F@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 the long raw field in 1,4999 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 Mon Jan 17 2000 - 02:01:06 CST