SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL cursors vs. SQL*plus Select statement

568919Mar 25 2007 — edited Mar 26 2007

Hi folks, hope you're doing well,

Here is a question that kept me wondering:

Why would I use cursors when i can achieve the same thing with a SQL+ Select statement which is much easier to formulate than a cursor (e.g. you need no declaration, loops etc)?.

Thanks so much,
-a

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 23 2007

Added on Mar 25 2007

4 comments

372 views