现在手上有两段SQL代码,如下:
(select 
CASE WHEN (DAY_MEET.MEETING_DAYS = 'F')THEN ('Friday')
WHEN (DAY_MEET.MEETING_DAYS = 'FS')THEN ('Friday,Saturday')
WHEN (DAY_MEET.MEETING_DAYS = 'M')THEN ('Monday')
WHEN (DAY_MEET.MEETING_DAYS = 'MF')THEN ('Monday,Friday')
WHEN (DAY_MEET.MEETING_DAYS = 'MT')THEN ('Monday,Tuesday')
WHEN (DAY_MEET.MEETING_DAYS = 'MTH')THEN ('Monday,Thursday')
WHEN (DAY_MEET.MEETING_DAYS = 'MTTH')THEN ('Monday,Tuesday,Thursday')
WHEN (DAY_MEET.MEETING_DAYS = 'MTW')THEN ('Monday,Tuesday,Wednesday')
WHEN (DAY_MEET.MEETING_DAYS = 'MTWTH')THEN ('Monday,Tuesday,Wednesday,Thursday')
WHEN (DAY_MEET.MEETING_DAYS = 'MTWTHF')THEN ('Monday,Tuesday,Wednesday,Thursday,Friday')
WHEN (DAY_MEET.MEETING_DAYS = 'MW')THEN ('Monday,Wednesday')
WHEN (DAY_MEET.MEETING_DAYS = 'MWF')THEN ('Monday,Wednesday,Friday')
WHEN (DAY_MEET.MEETING_DAYS = 'MWTH')THEN ('Monday,Wednesday,Thursday')
WHEN (DAY_MEET.MEETING_DAYS = 'S')THEN ('Saturday')
WHEN (DAY_MEET.MEETING_DAYS = 'T')THEN ('Tuesday')
WHEN (DAY_MEET.MEETING_DAYS = 'TH')THEN ('Thursday')
WHEN (DAY_MEET.MEETING_DAYS = 'THF')THEN ('Thursday,Friday')
WHEN (DAY_MEET.MEETING_DAYS = 'TTH')THEN ('Tuesday,Thursday')
WHEN (DAY_MEET.MEETING_DAYS = 'TTHF')THEN ('Tuesday,Thursday,Friday')
WHEN (DAY_MEET.MEETING_DAYS = 'TW')THEN ('Tuesday,Wednesday')
WHEN (DAY_MEET.MEETING_DAYS = 'TWTH')THEN ('Tuesday,Wednesday,Thursday')
WHEN (DAY_MEET.MEETING_DAYS = 'W')THEN ('Wednesday')
WHEN (DAY_MEET.MEETING_DAYS = 'WF')THEN ('Wednesday,Friday')
WHEN (DAY_MEET.MEETING_DAYS = 'WTH')THEN ('Wednesday,Thursday')
WHEN (DAY_MEET.MEETING_DAYS = 'WTHF')THEN ('Wednesday,Thursday,Friday')
ELSE ('Unknown')
END MEETING_DAY, DAY_MEET.*
FROM UTDBA.IS_167_DAY12_MEETING_INFO DAY_MEET)
下面这段是从网上找到的
SELECT REGEXP_SUBSTR('17,20,23', '[^,]+', 1, LEVEL, 'i') AS STR  
  FROM DUAL  
CONNECT BY LEVEL <=  
           LENGTH('17,20,23') - LENGTH(REGEXP_REPLACE('17,20,23', ',', ''))+1;  
STR
现在想要在不建立任何新的表或视图的前提下,将上面两段代码结合,以达到将原表的MTWTHF转换成单行的Monday,Tuesday...,切分成每天占一行,请问要怎么嵌套呢?