dear all,
i am using apex 5 with oracle database 12c on firefox with widows.
if have successfuly followed the following;
http://www.talkapex.com/2015/09/report-with-checkboxes-update.html
the result is below
now i want to insert the selected Student_id into a table when the user clicks on the Enroll button.
how i could select the Student_id which are comma seperated in the Student list?
The above site itself says
To process the list of comma delimited list you can use the apex_util.string_to_table function and loop over the table values. If you want to use the comma delimited list in a query the following example should work (again it does have varchar2 size limitations).
|
select regexp_substr(:p1_empno_list,``'[^,]+'``, 1, level``) empno
from dual
connect by regexp_substr(:p1_empno_list, '[^,]+'``, 1, level``) is not null
|
how could i select the comma seperated values in the Student list item in a loop and insert it into a table?
Regards.