PL/SQL HELP! HELP!

From: <erinakaz_at_my-dejanews.com>
Date: Fri, 12 Jun 1998 18:50:04 GMT
Message-ID: <6lrt8s$5so$1@nnrp1.dejanews.com>

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 - 13:50:04 CDT