select in a loop

From: <alexander.stuckenholz_at_fernuni-hagen.de>
Date: Wed, 11 Jul 2007 06:40:37 -0700
Message-ID: <1184161237.461538.109210@n60g2000hse.googlegroups.com>

Hello everyone,

I just started with PL/Sql and directly have a problem. I want to iterate in a loop and use an entry in a where-statement of a pretty complex query.

I did the following:

BEGIN
  FOR item IN
  (
    SELECT * FROM test
  )
  LOOP
    select * from (pretty complex subquetries...) where something.id = item.id
  END LOOP;
END; Unfortunately this does not seem to work. Does anybody of you have an idea?

Best regards,

Alex Received on Wed Jul 11 2007 - 08:40:37 CDT