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