The Database Design Resource Center

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.

SQL programmingThis 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.
Ref Cursor tipCreating 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.
Oracle ref cursor in JavaUsing 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.
Customer ServiceAt 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
Database fundamentals

Return to Database Design Home

Exclusive interviews with:
Steven Feuerstein, PLSQL expert
Donald Burleson, Top IT consultant

Free eBook

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

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

Read more Testimonials

Database Normalization eBook:

Database Normalization eBook

Copyright © /
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: 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.