Does PL/SQL allow cursors to contain subqueries?

valexena

Does PL/SQL allow cursors to contain subqueries?
--
Posted via http://dbforums.com

Jul 19 '05 #1

Subscribe Post Reply

4688

Frans H.

valexena <me*********@dbforums.com> wrote in message news:<35****************@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

Jul 19 '05 #2

Dave

fr****@hotmail.com (Frans H.) wrote in message news:<31**************************@posting.google. com>...

valexena <me*********@dbforums.com> wrote in message news:<35****************@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.

Jul 19 '05 #3

by: Nick | last post by:

Im moving a development app (MySQL 5.0) to a different server which runs MySQL 4.0.20-standard. I am getting errors on queries that have subqueries such as... SELECT id FROM table1 WHERE id IN...

MySQL Database

avoid using cursors

by: T.S.Negi | last post by:

Hi All, I want to avoid using cursors and loops in stored procedures. Please suggest alternate solutions with example (if possible). Any suggestion in these regards will be appreciated. ...

Microsoft SQL Server

Cursors & MDI Apps

by: a | last post by:

Hello, I am doing some multithreading in an MDI app, and I can't seem to get the cursor to stay as an Hourglass. I call: Cursor.Current = cursors.wait at the beginning of my routing, and...

Visual Basic .NET

Cursors and Transactions, why?

by: Eric Ridge | last post by:

Why must a cursor be defined in an open transaction? Obviously there's a good reason, but I can't figure it out. On a high level, what would be involved in allowing a cursor to outlive the...

PostgreSQL Database

what are cursors in sql???

by: vishal | last post by:

I am new to sql and require some help on cursors? what are they and how and why are they used for??? it will be kind enough if anyone helps me in this regards.. regards vishal jain.

Microsoft SQL Server

Cursors

by: Martijn Mulder | last post by:

I am looking for a tutorial for creating and using custom cursors in a .NET application

C# / C Sharp

When to use cursors?

by: Dima Kuchin | last post by:

Hello, I was trying to find the information about when and where should I use cursors in DB2, no luck. Maybe you can point me to some article that describes just that (or tell me which page is...

DB2 Database

Clarification required while using correlated subqueries

by: muzu1232004 | last post by:

Can anyone explain me when we use correlated subqueries rather than nested subqueries. Do all the correlated subqueries can be written in nested subqueries form as well ? What are the major...