Oracle REF Cursor | Oracle REF Cursor in Java

Programming against databases - Tips and resources

To use your database, you need to do some programming. Designing a good relational database, whether it is Oracle, MS Access or SQL Server, gives you the neccessary platform for building your application(s). While this site is dedicated to database analysis and design, we would like to provide you with some tips, strategies and other helpful resources on the net.

This site is about database design, not programming, really. However, I use SQL statements here and there, as well as I include them in my ebooks. I also have chapters on ref cursor usages. So I have set up an introduction page on SQL programming to get you started, if you are new to the SQL language.
Creating a ref cursor: Read about defining ref cursors in a database package in Oracle, including complete definition of programming a package specification and a package body, with a sample function returning a ref cursor. By using ref cursors and database packages, you can access Oracle data from (virtually) any application and programming language.
Using an Oracle ref cursor in Java.: In the above example, I illustrated how you can create a database package with one (or more) functions and/or procedures in it. Now, how can you use that in an application?

While I am concentrating on the theoretical issues,Surbhi has a more direct approach to Oracle databases. Check out her site: Oracle DBA - Tutorials, Articles, Scripts. She has lots of articles, based on long personal experience, on many subjects related to the use of Oracle databases, and with helpful links as well.

For those of you who are using MS Access, a very good and informative site for junior and intermediate MS Access VBA programmers is the Manxman's Access Databaselessons. He has lots of articles, based on long personal experience, on many subjects related to the use of MS Access databases, and with helpful links as well.

Here is a great resource for Software Project Management Training. Bas de Baar has a complete website dedicated to managing software projects. Great place!

At Customer Service Point, Erwin Steneker runs his site with great focus on customer support and service, an area many more should pay attention to.

Other important resources on this site:

Oracle DBA
SQL Server DBA
Application Architecture
Software tools
Programming tips
Database fundamentals

Return from Ref cursor to Programming

Interview with
Donald Burleson

Interview with
Steven Feuerstein

What visitors say...

"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."

Mike, USA

Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:

Workshop

On rare occasions, I may perform a Database Design Workshop . Unfortunately, I am currently unable to, but maybe later...

Influence me

Influence the content on this site: I want to know what database information you need the most: Participate in my Database Design Content investigation. I would appreciate it if you took the time...

Theory & Practice
Database eBooks
DB Normalization
Analysis Phase
Database Keys
Software Tools
DB Glossary
Appl.Architecture
Oracle DBA
MySQL DBA
SQL Server DBA
Install Oracle
Install SQL Server
Proj.Management
Oracle Constraint
Programming Tips
Bookstore
Worst DB Designs
Internet biz.
Website Design

Database Normalization eBook:

ADD TO YOUR SOCIAL BOOKMARKS:

Blink

Del.icio.us

Digg

Furl

Google

Simpy

Spurl

Technorati

Y! MyWeb

Copyright © 2004-2009 www.databasedesign-resource.com / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
*Disclaimer: www.databasedesign-resource.com does not warrant any company, product, service or any content contained herein.
Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.