import java.sql.*;
import sqlj.runtime.ref.DefaultContext;
import oracle.sqlj.runtime.Oracle;

#sql iterator MyIter (String ename, int empno, float sal);

public class MyExample
{
    public static void main (String args[]) throws SQLException
    {
        Oracle.connect
            ("jdbc:oracle:thin:@localhost:1521:prod", "scott", "tiger");

        #sql { insert into emp (ename, empno, sal)
                values ('SALMAN', 32, 20000) };

        MyIter iter;

        #sql iter={ select ename, empno, sal from emp };
        while (iter.next()) {
            System.out.println
                (iter.ename()+" "+iter.empno()+" "+iter.sal());
        }
    }
}