<?xml version="1.0"?> <queryset> <rdbms><type>oracle</type><version>8.1.6</version></rdbms> <fullquery name="user_curriculum_map_insert"> <querytext> insert into cu_user_curriculum_map (user_id, curriculum_id, package_id) select :user_id, :curriculum_id, :package_id from dual where not exists (select 1 from cu_user_curriculum_map where user_id = :user_id and curriculum_id = :curriculum_id) </querytext> </fullquery> <fullquery name="desired_curriculums"> <querytext> select curriculum_id from cu_curriculums where package_id = :package_id MINUS select curriculum_id from cu_user_curriculum_map where user_id = :user_id and package_id = :package_id </querytext> </fullquery> </queryset>