Convert above single lengthy word into several rows as following.
Above 7 lines in single text box will take as 7 new lines as per below code.
Following is the PL-SQL cursor to split single word into several words based on new line character
1.) CHR(10) -- Line feed
2.) CHR(13) -- Carriage return.
1
2
3
4
CURSOR get_work_desc(str_ VARCHAR2) IS
SELECT
regexp_substr(str_,'[^*' || chr(13) || chr(10)...
Colombo Time
