APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to split a string using : and store in an array / list in plsql

Syed Shakir-OracleFeb 28 2018 — edited Mar 1 2018

I'm working on requirement where I need to see the values coming into a string in the form of "MON:TUE:WED:THU:FRI:SAT:SUN".

My requirement is to have the entries for these days and ignore the dates which doesn't falls under the above list. My list may come with "MON:TUE:WED:THU:FRI" and any possible 5 working days and I should store the corresponding rows into db.

This post has been answered by Pierre Yotti on Mar 1 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2018

Added on Feb 28 2018

#apex-discussions

8 comments

8,571 views