select t.score, t.khbm, t1.wayattrib from EXAM_SCORE t, EXAM_WAY t1 where t.wayid = t1.id and t.wayId in (select regexp_substr(t.wayids, '[^,]+', 1, level) from (select t.wayids from EXAM_ITEM t where t.code = 'qwzhkh') t connect by regexp_substr (t.wayids, '[^,]+', 1, level) is not null);
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter