Database Tuning (MOSC)

MOSC Banner

Need help tuning this Cursor

edited Aug 7, 2009 2:59AM in Database Tuning (MOSC) 9 commentsAnswered
         CURSOR cenrollments (nperson_id number, nzone varchar2, nterm number)

        IS

           

 

select e.enrollment_id, o.offering_name||'-'|| s.name charge_name, sum(charge_amount)                            

from                                 

sss_student_enrollments e,

sss_stud_tut_charges c,

                          sss_sections s,

                          sss_offerings o,

                          esi_district_mapping dm

            where e.enrollment_id=c.enrollment_id

            and e.offering_id = o.offering_id

            and e.section_id = s.section_id

            and e.comb_id = dm.comb_id

            and c.person_id =nperson_id

            and e.term_id  = nterm

            and dm.zone_name = nzone

            group by e.enrollment_id, o.offering_name||'-'|| s.name;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center