Re: SQL problem

From: <michael_bialik_at_my-deja.com>
Date: Mon, 17 Jan 2000 20:24:20 GMT
Message-ID: <85vtp0$q3u$1@nnrp1.deja.com>

Hi.

Write a small PL/SQL program to do it.

Michael.

In article <3882CC42.52D0896F_at_informasa.es>, Michael Francis Horrocks <M.F.Horrocks_at_informasa.es> wrote:
> 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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 17 2000 - 14:24:20 CST