How i can achieve below result :
Procedure GET_Test(i_MatricNo in varchar2, i_Subj_Code IN t_c_subj_code, o_cursor out t_cursor) is
Begin Open o_cursor for FORALL i IN i_Subj_Code.FIRST..i_Subj_Code.LAST Select tt.c_subj_code from dseminar.c_student_time_table tt where tt.c_matric_nmbr=i_MatricNo and AND tt.c_subj_code NOT IN(i_Subj_Code(i)); END
Thanks
Aucun commentaire:
Enregistrer un commentaire