Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: "No ResultSet set was produced" error when using JDBC
Hans,
Thanks for responding so quickly.
Server: Oracle9i Enterprise Edition Release 9.2.0.3.0 jdbc:oracle:thin
This SQL below calculates,grouping by US states, the number of students sending applications (Volume abbrev as V ) for 4 colleges, the number of students sending apps (Overlap abbreviated as OVL ) to School 1 and School2, School 1 and 3, School 1 and 4. WITH
T1 AS ( SELECT STATE, D.STUDENT_ID FROM NEPS_CBS_DI_CODES D, NEPS_COLLBND_SENIOR WHERE D.DI_CD = '2361' AND NEPS_COLLBND_SENIOR.student_id = D.STUDENT_ID AND ACADEMIC_YEAR = 2003
)
, T2 AS ( SELECT STATE, D.STUDENT_ID FROM NEPS_CBS_DI_CODES D, NEPS_COLLBND_SENIOR WHERE D.DI_CD = '2365' AND NEPS_COLLBND_SENIOR.student_id = D.STUDENT_ID AND ACADEMIC_YEAR = 2003
)
, T3 AS ( SELECT STATE, D.STUDENT_ID FROM NEPS_CBS_DI_CODES D, NEPS_COLLBND_SENIOR WHERE D.DI_CD = '2050' AND NEPS_COLLBND_SENIOR.student_id = D.STUDENT_ID AND ACADEMIC_YEAR = 2003
)
, T4 AS ( SELECT STATE, D.STUDENT_ID FROM NEPS_CBS_DI_CODES D, NEPS_COLLBND_SENIOR WHERE D.DI_CD = '2959' AND NEPS_COLLBND_SENIOR.student_id = D.STUDENT_ID AND ACADEMIC_YEAR = 2003
)
SELECT STATE_ABBREV , V1, V2, OVL1, v3, OVL2, v4, OVL3 FROM ( SELECT STATE, COUNT(*) OVL1 FROM ( SELECT * FROM T1 INTERSECT SELECT * FROM T2 ) GROUP BY STATE ) I1 , ( SELECT STATE, COUNT(*) OVL2 FROM ( SELECT * FROM T1 INTERSECT SELECT * FROM T3 ) GROUP BY STATE ) I2 , ( SELECT STATE, COUNT(*) OVL3 FROM ( SELECT * FROM T1 INTERSECT SELECT * FROM T4 ) GROUP BY STATE ) I3 , ( SELECT STATE, COUNT(*) V1 FROM T1 GROUP BY STATE ) V1 , ( SELECT STATE, COUNT(*) V2 FROM T2 GROUP BY STATE ) V2 , ( SELECT STATE, COUNT(*) V3 FROM T3 GROUP BY STATE ) V3 , ( SELECT STATE, COUNT(*) V4 FROM T4 GROUP BY STATE ) V4 , STATE WHERE I1.STATE = I2.STATE (+) AND I1.STATE = I3.STATE (+) AND I1.STATE = V1.STATE (+) AND I1.STATE = V2.STATE (+)