Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help - Variables and loops
I assume all these values are stored in the table. you can
issue single update stmt as
UPDATE TNAME
SET f1 = decode(f1,'','bad cell'),
f2 = decode(f2,'','bad cell'), . f6 = decode(f6,'','bad cell');
regards
vittal
NetScans wrote:
> Could someone tell me the correct syntax, my co-workers and I can not
> get anything to work. Some background, I have a matrix, with some gaps
> that I need to plug.
>
> col
> f1 f2 f3 f4 f5 f6
> a b c
> a b c d
> a b d e
> a b c d e f
>
> loop 1...5
> update f1 = 'Bad cell' where f1 is null and f2 is not null;
> loop
>
> I want to change the 1 to the loop value and 2 to the loop value +1. I
> hope I have explained myself.
>
> Thanks to everyone,
> Moises
Received on Wed Apr 14 1999 - 02:30:54 CDT