SQL question

From: Michael <mikeeria_at_interia.pl>
Date: 28 Apr 2004 22:10:40 -0700
Message-ID: <875e251b.0404282110.61e39780@posting.google.com>

Hi,

  Is it possible to write I) without using PL/SQL blocks. Something like II) ??  

I)
DECLARE

	CURSOR MyCursor IS
		SELECT a, MAX(b) 
 		FROM table_name GROUP BY a;
BEGIN 
	FOR col_rec IN MyCursor
         LOOP
		UPDATE table_name SET c = 'Y'
		WHERE a = col_rec.a
		AND b = col_rec.b
	END LOOP;

END; II)
UPDATE table_name SET c = 'Y' WHERE
a,b = (SELECT a,MAX(b) FROM table_name GROUP BY a);

TIA
Michal Received on Thu Apr 29 2004 - 00:10:40 CDT