Chapter 2. Relational Databases, SQL, and PL/SQL

As you now know, SQLJ enables you to access a database using SQL statements in your Java programs. Therefore, to use SQLJ, you need to know about databases and SQL. This chapter provides a basic introduction to relational databases, SQL, and Oracle's proprietary PL/SQL procedural language. It cannot possibly cover these large subjects in depth, but it will give you a strong enough foundation for you to be productive and to understand the rest of this book. For a detailed discussion of SQL, I recommend the book Oracle 8i: The Complete Reference by Kevin Loney and George Koch (Oracle Press). If you want to learn more about PL/SQL, I recommend Oracle PL/SQL Programming by Steven Feuerstein and Bill Pribyl (O'Reilly).

Get Java Programming with Oracle SQLJ 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.