Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 483 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

 

Cursors in database management systems

Available for Members. This is an off-site link.  Please review our Terms of Service (bottom of page) for additional information.  See Related Articles


 Article Abstract:

(John Charles Olamendy) This article is intended to show the principles and uses of cursors in relational database management systems. We're going to discuss how cursors are implemented in Microsoft SQL Server and Oracle database and how you can use it in your applications. I want to explain that this is another technique for data retrieval, and I recommend using cursors as the last option for querying your data because they consume a lot of memory, lock resources, and create excessive amounts of code, thus it's better to use SQL statements because is a lower-cost set-based language.

 Read this article...

 Related Articles - For Members.
Oracle 2-Day DBA in x Days Post 8; Watching Oracle Background Processes
Oracle Easier to Adminster than Microsoft SQL Server?
Oracle 2-Day DBA in x Days Post 7; Initialization Parameters
Using Oracle Heterogeneous Services in an Operational Data Store or Data Warehouse
Oracle 2-Day DBA in x Days Post 4; Getting Enterprise Manager (dbconsole) to work
Oracle 2-Day DBA in x Days Post 1
Oracle 11g Software Installation on LinuxCentOS-5
Things Your Mother Never Mentioned About Setting Up an Oracle Database - Steps 3 to 5
Things Your Mother Never Mentioned About Setting Up An Oracle Database - Steps 1 and 2
Oracle 2-Day DBA in x Days Post 13; Viewing Oracle Storage Structures part II



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content


No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   




 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004