Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: subqueries in cursors?
On Fri, 09 Jan 1998 14:29:43 +0100, Peter Rak <prak_at_vsz.sk> wrote:
>
>
>Thomas Kyte wrote:
>
>> On Thu, 08 Jan 1998 17:17:29 GMT, Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de
>> (Gerhard Moeller) wrote:
>>
>> >Hi,
>> >
>> >I just experienced that there are no subqueries allowed in PL/SQL
>
> Hi,
>But try this one:
>
>declare
> cursor foo is
> select DUMMY from ( select DUMMY from DUAL WHERE UPPER(DUMMY)='Y');
>begin
> for x in foo loop
> dbms_output.put_line( x.DUMMY );
> end loop;
>end;
>
>Why it doesn't work???
>I can't use function on column in subquery...
>
> Peter.
That would be bug 388972 after looking into it. Patches exist if you call support.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Jan 09 1998 - 00:00:00 CST