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 -> select in a loop

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

Original text of this message

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