JDBCSample

import java.sql.*;
class JDBCSample {
  public static void main (String[] args) throws Exception
  {
   Class.forName("oracle.jdbc.OracleDriver");

   /*Connection conn = DriverManager.getConnection
     ("jdbc:oracle:thin:@//localhost:1521/orcl", "system", "admin");
                        // @//machineName:port/SID,   userid,  password*/
   Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","scott", "tiger");
   try {
     Statement stmt = conn.createStatement();
     try {
       ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");
      // ResultSet rset = stmt.executeQuery("select 'Shalini' from dual");
       try {
         while (rset.next())
           System.out.println (rset.getString(1));   // Print col 1
       }
       finally {
          try { rset.close(); } catch (Exception ignore) {}
       }
     }
     finally {
       try { stmt.close(); } catch (Exception ignore) {}
     }
   }
   finally {
     try { conn.close(); } catch (Exception ignore) {}
   }
  }
}