Пример программы с использованием SQLJ

import java.sql.*;

import sqlj.runtime.ref.DefaultContext;

import oracle.sqlj.runtime.Oracle;

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

public class StaffBySQLJ

{

public static void main (String args[]) throws SQLException

       {

             Oracle.connect

                    ("jdbc:oracle:thin:@localhost:1521:teacher",

                    "scott", "tiger");

            MyIter iter;

           while (iter.next()) {

                    System.out.println

                           (iter.ename()+" "+iter.empno()+" "+iter.sal());

               }

         }

}