Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help - Variables and loops

Re: Help - Variables and loops

From: G.H VITTAL <vittal_at_india.hp.com>
Date: Wed, 14 Apr 1999 13:00:54 +0530
Message-ID: <3714442D.AA6559B6@india.hp.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US