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).
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access