Oracle News for the Oracle Community
Thursday, Jul 29, 2010
Sample PL/SQL Cursor Loops
Thanks to Michael McLaughlin for this story
22 Jan - 11:53am
A few of my students wanted me to post sample cursor loops, so here are examples of simple, FOR, and WHILE loops. There are a couple variations on approaches that demonstrate %TYPE and %ROWTYPE anchoring to data dictionary table definitions and local cursors.
Featured Content
- Dell and HP to Certify and Resell all Three Oracle Operating Systems – Oracle Solaris, Oracle Enterprise Linux and Oracle VM – on their x86 Server Computers
- Leupold & Stevens Benefits from a Clearer View of Business Operations with the Oracle E-Business Suite Release 12
- Cox Communications Reduces Environmental Impact with Oracle
- Oracle Launches Oracle + Sun Product Strategy Event Series
LATEST WHITEPAPERSWHITEPAPERS RSS
Whitepaper Search Results:
- Learn how to switch from the Red Hat network to the Oracle Unbreakable Linux Network (ULN)
- Tips & Techniques at implementing and optimizing your database storage using ASM & SAN.
- Oracle Enterprise Linux and Oracle Database 11g R1 Deployment Best Practice
Whitepaper Search Results:
- Learn how to switch from the Red Hat network to the Oracle Unbreakable Linux Network (ULN)
- Tips & Techniques at implementing and optimizing your database storage using ASM & SAN.
Whitepaper Search Results:
- Oracle Enterprise Linux and Oracle Database 11g R1 Deployment Best Practice
- This white paper covers the example system design of RAC on Oracle VM.
Latest VideosVideo RSS
Latest podcastsPopcasts RSS
