Reading Result Set with a Cursor
Posted on 2010-09-23
Hi, I have following SQL statement.
SELECT E.ID, E.NAME,
CURSOR(SELECT F.MEMBER, F.AGE FROM CLIENT F WHERE F.ID = E.ID)
FROM EMPLOYER E
If I run something like this in Java:
ResultSet rs = statement.executeQuery(sql);
I can read E.ID and E.NAME using rs.getString(1), but how do I read the values in the cursor?
Thanks in advance