Hi.
Consider the following table
StudentID INT,
StudentName varchar2(200)
Address varchar2(500)
I need to write a stored procedure, which inputs a student ID list as a Comma Separated value list, and then output the StudentName and Addresses of those students.
I am kind of having an idea of the pesudo code;
first i need to decode the comma separated values (and put them into a collection ?)
and then open a cursor and query the array with the student table to get the relevant data.
Could you please let me know what would be the correct pl/sql block to do this ??
Thanks !