Re: Does PL/SQL allow cursors to contain subqueries?

From: Dave <slimdave_at_yahoo.com>
Date: 27 Oct 2003 09:45:01 -0800
Message-ID: <c502cdfc.0310270945.246e866f_at_posting.google.com>

fransh_at_hotmail.com (Frans H.) wrote in message news:<31abf0e5.0310270116.2478c464_at_posting.google.com>...
> valexena <member43815_at_dbforums.com> wrote in message news:<3525319.1067221651_at_dbforums.com>...
> > Does PL/SQL allow cursors to contain subqueries?
>
> A cursor can contain any query you want, but please read the pl/sql
> manual before proceeding your work/class
>
> Frans

Prior to 9i there was the issue that PL/SQL used a SQL engine that lagged the main sql engine in features, so you could only do CASE statements for example by bypassing the PL/SQL engine (using dynamic SQL). 9i+, this is not a problem. Received on Mon Oct 27 2003 - 18:45:01 CET

This message: [ Message body ]
Next message: bigbinc: "Re: sql comparison and flag"
Previous message: Henry: "Re: What is the efficient way to select data from huge database?"
Maybe in reply to: valexena: "Does PL/SQL allow cursors to contain subqueries?"
In reply to Frans H.: "Re: Does PL/SQL allow cursors to contain subqueries?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message