Chapter 12. SQLJ Data Access and Best Practices

In this chapter, we’ll look at Oracle SQL data manipulation using SQLJ and then best practices with SQLJ.

Manipulating Oracle SQL and PL/SQL Data Types with SQLJ

SQL and PL/SQL data are manipulated in SQLJ through SQLJ host variables/expressions, result expressions, and iterator accessors. This section explains the SQLJ mechanisms to manipulate SQL data, using frequent references to the corresponding sections in Chapter 8.

Oracle SQLJ Type-Mapping Summary

Because Oracle SQLJ leverages the Oracle JDBC drivers and its wrapper classes, the mapping of SQL data types in SQLJ is almost identical to JDBC mapping, as summarized in Table 3.2. However, there are additional SQLJ-specific mappings. See Table 12.1 ...

Get Oracle Database Programming using Java and Web Services 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.