Re: Nested Cursor

From: Alexander V. Silantiev <silantiev_at_bashkortostan.ru>
Date: Sat, 21 Jul 2001 21:23:25 GMT
Message-ID: <9hrkj9$pbc$1@poikc.bashnet.ru>

яХКЮМРЭЕБ ю.б. <silantiev_at_bashkortostan.ru> сообщил в новостях следующее:9hrjjj$ise$1_at_poikc.bashnet.ru...
>
> Bala <kmbase_at_usa.net> ЯННАЫХК Б МНБНЯРЪУ
> ЯКЕДСЧЫЕЕ:7d52c6a5.0106280138.d4f83a5_at_posting.google.com...
> > Hi,
> > Is it possible to have a nested cursor. That is
> > for instance, while declaring the first cursor i
> > will issue a select statement. And while looping
> > this cursor and based on the value of some columns
> > returned by this cursor is it possible to built
> > another cursor.If so,will u give me sample code.
> > Thanks in advance
> >
> > Regards,
> > Bala
>

You can to use subcursors with parameters: CURSOR cursor_name [(parameter[, parameter]...)]

IS select_statement;

see the PL/SQL User's Guide and Reference

Alexander Received on Sat Jul 21 2001 - 16:23:25 CDT