// Compile it by
//   javac oracle.java
//
// Run it by
//   java -cp .:$ORACLE_HOME/jdbc/lib/classes111.zip Hello

import java.io.*;
import java.sql.*;

class Hello
{
  public static void main(String args[]) throws Exception
  {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection conn = DriverManager.getConnection(
      "jdbc:oracle:thin:@dbserv.dc.umd.edu:1521:SC424",
      "YOUR_USERNAME", "YOUR_PASSWORD");

    //create table
    Statement stat = conn.createStatement();
    stat.executeUpdate("CREATE TABLE hello (key int, value CLOB)");

    //insert CLOB
    stat.executeUpdate("INSERT INTO hello VALUES(1, 'hello world')");

    //select query
    ResultSet res = stat.executeQuery("SELECT value FROM hello ");
    if (res != null)
      for(; res.next();)
      {
        Clob clob = res.getClob(1);
        long n = clob.length();
        for(long i = 1; i <= n; i += 4)  //get CLOB part by part
          System.out.println("clob: " + clob.getSubString(i, 4));
      }
    res.close();

    stat.close();
    conn.close();
  }
}