Re: PL/SQL and Cursors

certainly, you can nest cursors......

	for csr1 in (
		select	col1 
		from	tab1
	)loop
		for csr2 in (
			select  col2
			from	tab2 tab
			where	tab.col1 = csr1.col1
		)loop
			--process the data
			.
			.
			.
		end loop; --csr2
	end loop; --csr1

Bryan J. Gentile wrote:
>
> Is it possible with PL/SQL to nest a cursor within another cursor? If
> so, how can I do this, some sample code would be very beneficial.
> Thanks in advance. If possbile, can you email me a response as well as
> replying to this posted message?
>
> --

-- 
The views expressed here are mine and do not reflect the official
position of my employer or the organization through which the 
Internet was accessed.