O'Reilly logo

Oracle Database Programming using Java and Web Services by Kuassi Mensah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required