Programming against databases

Programming against databases - Tips and resources

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.

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:

"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

HOME \| NEWSLETTER \| WATERCOOLER
	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. 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 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
Theory & Practice DB Normalization Analysis Phase Database Keys DB Glossary Appl.Architecture Oracle DBA MySQL DBA SQL Server DBA Install Oracle Install SQL Server Proj.Management Oracle Constraint Programming Tips Database Normalization eBook:
Copyright © www.databasedesign-resource.com / 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.

Programming against databases - Tips and resources

Free eBook

What visitors say...

Database Normalization eBook: