Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL nested select ...
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;
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