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 -> Re: PL/SQL nested select ...

Re: PL/SQL nested select ...

From: Peter H. Larsen <plarsen_at_dc.dynares.com>
Date: 1998/06/12
Message-ID: <358123BC.B28D8A37@dc.dynares.com>#1/1

Hi!

Huh??
SQL> declare
  2 cursor c1(a number) is

  3      select Q.* from (select * from dba_tables where a=1) q
  4      where q.table_name = 'ABC';
  5  begin
  6     for w1 in c1(1) loop
  7       null;
  8     end loop;

  9 end;
 10 /

PL/SQL procedure successfully completed.

What version are you running this on?

Wlad.M wrote:
>
> Hello All !
>
> Please help
> Why PL/SQL dont understand this:
>
> cursor curs(param integer) is
> select Q.* from (select * from some_table where id<param) Q where Q.txt
> is not null;
>
> Regards, Wlad.M.
Received on Fri Jun 12 1998 - 00:00:00 CDT

Original text of this message

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