Re: PL/SQL HELP! HELP!

From: Q <quintonm_at_bellsouth.net>
Date: Fri, 12 Jun 1998 19:12:44 GMT
Message-ID: <35817D84.6134BB5D@bellsouth.net>

declare

   cursor1 is "your select statement to return the 50 rows here";    rec1 cursor1%rowtype;
   rec2 cursor2%rowtype;
begin
  for rec2 in cursor1 loop
    if (rec1 is not null ) then

       if( rec1.col1 != rec2.col21 or v_APPSTOT != v_VET ) then
          -- handle the error condition
       end if;

    end if;
    rec1 := rec2;
  end loop;
end;

erinakaz_at_my-dejanews.com wrote:

> Hi,
>
> i have a table with 38 columns and 50 lines (rows). i have FOR LOOP var
> called line_no 1..50 in the loop in have all other checking stuff, however
> there's one checking that i'm unable to do it. that is, i have to check this
> condition: line 2 col 1 NOT = line 1 col 21 or v_APPSTOT != v_VET
>
> i have tried different states with setting lineno = 2 and a small SELECT
> statement within the big loop, also i have tried the subquery SELECT. Does
> anyone know how to write the small PL/SQL select for this problem? Please show
> me. thanks a million!!!!
>
> Regards,
> -erin
>
> ps. i have state and date are the primary keys.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri Jun 12 1998 - 14:12:44 CDT