postgresql7.4
SELECT * FROM cc_stream WHERE package_id = :package_id LIMIT 1
SELECT name, year_id FROM cc_year WHERE package_id = :package_id
SELECT name, semester_id FROM cc_semester WHERE package_id = :package_id
SELECT year_ids FROM cc_stream WHERE stream_id = :stream_id
SELECT name FROM cc_year WHERE year_id = :year_id
SELECT semester_ids FROM cc_stream WHERE stream_id = :stream_id
SELECT name from cc_semester WHERE semester_id = :semester_id
SELECT uos_code || ' ' || uos_name as name, uos_id
FROM cc_uos
WHERE package_id = :package_id
AND uos_id != :except_uos_id
SELECT uos.uos_code || ' ' ||uos.uos_name AS name, uos.uos_id
FROM cc_uos uos
WHERE uos.package_id = :package_id