The Basic JDBC 2.0 Samples demonstrate the usage of various new features introduced in JDBC Specification defined by Sun Microsystems.
All the samples have also been certified on Red Hat Linux Advanced Server 2.1  

Accessing PL/SQL Stored Procedures [29-Jan-2003]
This sample application demonstrates how to invoke PLSQL Stored Procedures from the database using JDBC APIs. Oracle JDBC drivers support execution of PL/SQL stored procedures from java applications.
Download Now (JAR, 21KB)
Readme
Source

Date Datatype [29-Jan-2003]
This sample shows how to access DATE datatype columns from Java applications sample using JDBC APIs.
Download Now (JAR, 18KB)
Readme
Source

Data Manipulation [29-Jan-2003]
This sample application demonstrates how to perform basic SQL operations like SELECT, INSERT, UPDATE, and DELETE from a java application using JDBC APIs.
Download Now (JAR, 23KB)
Readme
Source

Refcursor Sample [29-Jan-2003]
This sample application demonstrates how to retrieve and process a REFCURSOR from a java application using JDBC APIs. The sample creates a PLSQL Function that returns a REFCURSOR. This PLSQL Function is invoked from the application and the REFCURSOR returned by the function is processed using JDBC APIs.
Download Now (JAR, 22KB)
Readme
Source

Rowid Sample [29-Jan-2003]
This sample application illustrates how to access rows in a database table through its ROWID from a java application. ROWIDs can be accessed either as a string, or as a oracle.sql.ROWID type using the JDBC APIs.
Download Now (JAR, 23KB)
Readme
Source

Long Datatype [29-Jan-2003]
This application shows how to perform the data manipulation on a LONG column of a database table from a java application using JDBC APIs. To access the data in a LONG column, you can get the column as a java InputStream and use the read() method of the InputStream object.
Download Now (JAR, 30KB)
Readme
Source

LongRaw Datatype [29-Jan-2003]
This sample application demonstrates how to perform the data manipulation on a LONGRAW column of a database table from a java application using JDBC APIs.
Download Now (JAR, 29KB)
Readme
Source

Varchar2 and Char Datatypes [29-Jan-2003]
This sample application demonstrates how to access Varchar2 and Char columns of a database table using JDBC APIs.
Download Now (JAR, 22KB)
Readme
Source