All codes were tested in the following environment:

Windows XP
JRE 1.3.1
Eclipse 2.1
ORACLE 9.2.0.1
Apache

• Dealing with various modes of procedure arguments

• OracleCallableStatement.getCursor
• CallableStatement.getObject

• Get lob locator from a ResultSet
• Passing, receiving lobs: OracleCallableStatement.getClob, setClob, getBLOB, setBLOB
• OraclePreparedStatement.setClob, setBLOB
• Update LOB data the right way

• Retrieving and inserting unicode string
• The NVARCHAR2, NCHAR syntax
• Writing unicode data to clob

• Statement.addBatch, Statement.executeBatch

• 3 Types of resultset in JDBC 2.0 API

• Passing VARRAY

• Using ResultSetMetaData

• OraclePreparedStatement.setARRAY, OracleResultSet.getARRAY

• Select with Statement.executeQuery
• Select with PreparedStatement.executeQuery
• Get column with ResultSet.findColumn

• PreparedStatement.executeUpdate using bind variables
• Updatable Resultset: ResultSet.moveToInsertRow, ResultSet.insertRow

• DDL with Statement.executeUpdate