Part III. Relational SQL

In Part III, we’ll discuss the use of JDBC with relational SQL. Why the term relational SQL? With Oracle, you have three options as to how you use the database:

  • Use the database strictly as a relational database storing information in tables.

  • Use tables to store your data and use object views and INSTEAD OF triggers to provide an object-oriented presentation.

  • Create relational objects to store and present your information.

So which option is the right choice? That’s a matter of argument we won’t cover in this book, but I will describe how to use JDBC with all three. To that end, this part of this book covers option one, relational SQL.

Get Java Programming with Oracle JDBC now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.