`old_course_id` INT(25), IN `new_course_id` BEGIN
DECLARE db_cursor CURSOR FOR SELECT lic.org_id, lic.course_id, lic.license_duration_typeid, lic.insert_date, lic.insert_by, lic.quantity FROM cdp_organization_licensesas lic</em
车辆=“汽车”;
‘'SELECT lic.licence_plate_num,lic.owner_name,lic.owner_address,lic.owner_tel_no,lic.owner_email,vio.violation_date,vio.violation_time,vio.vehicle_type,vio.violation_type从licence_plate_details右边加入violated_vehicles v