import java.lang.*;
import java.io.*;
import java.sql.*;
import java.util.*;

public class Main
{
	public static void main(String argv[])
	{
	try
	{
		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
		Connection myCom =
		DriverManager.getConnection("jdbc:oracle:thin:@everest:1521:GEN","SCOTT","TIGER");
		Statement stmt = myCom.createStatement();

		try {
		  stmt.executeUpdate("drop table sud");
	        } catch (SQLException sqle) { };

		stmt.executeUpdate(
			"create table sud (name char(10), age integer)");

		stmt.executeUpdate(
				"insert into sud values ('Sudarshan', 33)");
		stmt.executeUpdate(
				"insert into sud values ('Siva', 38)");
		stmt.executeUpdate(
				"insert into sud values ('Rao', 57)");

		ResultSet rset = stmt.executeQuery(
				"select name, age from sud where age < 50");
		while (rset.next()) {
		     System.out.println(rset.getString(1) + "  " + rset.getInt(2));
		}
		stmt.executeUpdate("drop table sud");
	}
	catch (SQLException sqle)
	{ 
		System.out.println("SQLException : " + sqle);
	}
	}
}