BigDecimal aBigDecimal = null;
String aString = null;
Timestamp aTimestamp = null;
int rows = 0;
ResultSet rslt = null;
Statement stmt = null;
try {
stmt = conn.createStatement();
rslt = stmt.executeQuery(
"select to_char( NULL ), " +
" to_date( NULL ), " +
" to_number( NULL ) " +
"from sys.dual");
if (rslt.next()) {
rows++;
aString = rslt.getString(1);
aTimestamp = rslt.getTimestamp(2);
aBigDecimal = rslt.getBigDecimal(3);
System.out.println("a String = " + aString);
System.out.println("a Timestamp = " + aTimestamp);
System.out.println("a BigDecimal = " + aBigDecimal);
}
rslt.close();
rslt = null;
stmt.close();
stmt = null;
}
catch (SQLException e) {
System.err.println(e.getMessage());
}
finally {
if (rslt != null)
try { rslt.close(); } catch (SQLException ignore) { }
if (stmt != null)
try { stmt.close(); } catch (SQLException ignore) { }
}
