Hi,
I am using this query to split a string of a text area field inside my SQL query:
select * from table(apex_string.split(:P23_TEXTAREA, ','))
It works but I would like to split the string with a new line delimiter instead of a comma. I tried already "\n", "\r\n", "<br>" but without success. If I remove the delimiter and use the default, the string get split only once with a new line. How can I split my string with multiple new line separated entries?
Thanks