CRITICAL SKILL 7.6
Use JDBC
JDBC is based upon an industry standard. Java packages are a method of organizing related Java classes. They are different than PL/SQL packages. JDBC contains two types of packages. The standard JDBC packages work with different database vendors. Vendor-specific packages address vendor-specific functionality. Oracle provides an additional set of packages for JDBC that support Oracle specific features. To use JDBC, at least the standard JDBC packages need to be accessible within your program. An import statement defines where Java can find packages. Additional Oracle packages can be used to leverage Oracle data types (oracle.sql) and Oracle specific (oracle.jdbc) database features.
import java.sql.*; import oracle.sql.*; ...
Get Oracle Database 10g: A Beginner's Guide 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.
