dimanche 25 janvier 2015

select for loop result in oracle


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