Non-SELECT SQL statements can be saved to and executed from the Result Manager window. See Saving SQL Code or Output and Doing More with Results for information.

The PROC SQL SELECT statement uses a CONNECTION TO component in the FROM clause to retrieve data from the ORACLE table. The Pass-Through query (in italics) is enclosed in parentheses and uses ORACLE ...

As you can see, constructing a simple SELECT statement in Java is almost as simple as constructing a simple SELECT statement in SQL. The more features you want to use, the more complicated it gets.