Does PL/SQL allow cursors to contain subqueries?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • valexena
    #1

    Does PL/SQL allow cursors to contain subqueries?


    Does PL/SQL allow cursors to contain subqueries?


    --
    Posted via http://dbforums.com
    Tags: None
    • Frans H.
      #2
      Re: Does PL/SQL allow cursors to contain subqueries?

      valexena <member43815@db forums.comwrote in message news:<3525319.1 067221651@dbfor ums.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

        Comment

        • Dave
          #3
          Re: Does PL/SQL allow cursors to contain subqueries?

          fransh@hotmail. com (Frans H.) wrote in message news:<31abf0e5. 0310270116.2478 c464@posting.go ogle.com>...
          valexena <member43815@db forums.comwrote in message news:<3525319.1 067221651@dbfor ums.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.

            Comment

            Previous template Next
            Working...