Chapter 7. SQLJ

By now you've learned a number of SQL commands and worked with a database a bit, creating tables, entering data, and performing queries. All of this has been interactive at an SQL prompt in SQL*Plus—great for learning but not very useful for a programmer. You've also learned how to program using PL/SQL—which is great for discrete procedures and functions but not for building complete applications that a user can interact with. That is a task for a higher-level host language such as Java. In this and the remaining chapters, we'll learn how to write Java programs that interact with the database procedurally.

We start with SQLJ because it is the most direct approach. SQLJ allows you to imbed SQL statements directly in your Java ...

Get Java™ Oracle® Database Development 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.