Hello There,
I have a PL/SQL block which generates a concatenated string of sentences. The sentence is always prefixed with a special character '*'.
Below is the sample code/output showing the final concatenated string looks like. The Desire output which should show up as 3 rows. Is there a way to loop through the l_string and split the string as shown in the desrire output. How can this be done?
1A: Sample code:
DECLARE
l_string VARCHAR2(4000);
BEGIN
...
l_string := '*This is the 1st sentence*This is the second Sentence*Last code Line';
dbms_output.put_line(l_string);
END;
1B: Sample Output:
*This is the 1st sentence*This is the second Sentence*Last code Line
2B: Desire output:
*This is the 1st sentence
*This is the second Sentence
*Last code Line
Look forward to hearing from you.
Regards,
Don