Query in java 2

[ksbrace]

Hello,
I'm having a bit of difficulty placing this query within my java. it works perfectly in sqlplus. Any help/advice would be greatly appreciated. Thanks in advance!

sqlplus:

SELECT student_course_subject(sfrstcr_term_code,sfrstcr_crn)||'-'|| student_course_number(sfrstcr_term_code,sfrstcr_crn)||'-'|| student_course_section(sfrstcr_term_code,sfrstcr_crn) "Class", student_course_title(sfrstcr_term_code,sfrstcr_crn) "Title", student_ssrmeet_days(sfrstcr_term_code,sfrstcr_crn) "Schedule" FROM sfrstcr s WHERE s.sfrstcr_term_code=1999 AND s.sfrstcr_pidm=22;

java:

private static final String selectCourseList = "SELECT student_course_subject(sfrstcr_term_code,sfrstcr_crn)||'-'|| " +
       "student_course_number(sfrstcr_term_code,sfrstcr_crn)||'-'|| " +
      "student_course_section(sfrstcr_term_code,sfrstcr_crn) \"Class\", " +
       "student_course_title(sfrstcr_term_code,sfrstcr_crn) \"Title\", " +
       "student_ssrmeet_days(sfrstcr_term_code,sfrstcr_crn) \"Schedule\" " +
	   "FROM sfrstcr s " +
	   "WHERE s.sfrstcr_term_code=1999 AND s.sfrstcr_pidm=22;";

 

[venur]

Hi

Try this

String sqlQuery = "" +
                "SELECT student_course_subject(sfrstcr_term_code,sfrstcr_crn)||'-'|| " +
                "student_course_number(sfrstcr_term_code,sfrstcr_crn)||'-'|| " +
                "student_course_section(sfrstcr_term_code,sfrstcr_crn) \"Class\", " +
                "student_course_title(sfrstcr_term_code,sfrstcr_crn) \"Title\", " +
                "student_ssrmeet_days(sfrstcr_term_code,sfrstcr_crn) \"Schedule\" " +
                "FROM sfrstcr s WHERE s.sfrstcr_term_code=1999 AND s.sfrstcr_pidm=22";

Cheers
Venu

 

[stefanwagner]

And even better readable, breakable, editable:
instead of:

     "student_course_section(sfrstcr_term_code,sfrstcr_crn) \"Class\", " +

     " student_course_section (sfrstcr_term_code, sfrstcr_crn) \"Class\", " +

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[Diancecht]

I'd also recommend, to improve performance and keep things clearer, the use of append method of StringBuffer class.

Cheers,

Dian

 

[ksbrace]

Great, thanks for all of your help, it worked.
Kelly