Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Convert delimited column values

Mohammed RafiFeb 5 2024

Hi,

I have value stored in column called week day as 2:5 or 1:2:7 the values will be from 1 to 7

if the value in the column week day is 2:5 then it should display Mon,Thu

if it is 1:2:7 then should display as Sun,Mon,Sat

The week days are

1-Sun, 2-Mon, 3-Tue, 4-Wed, 5-Thu, 6-Fri, 7-Sat

How can this be done using SQL please

Thanks

This post has been answered by mathguy on Feb 5 2024
Jump to Answer
Comments
Post Details
Added on Feb 5 2024
8 comments
93 views