SELECT substr(sys_connect_by_path(USER_ID, ';'), 2)
FROM (select USER_ID,rownum rn
from apd_users)
START WITH rn = 1
CONNECT BY prior rn = rn - 1;
FROM (select USER_ID,rownum rn
from apd_users)
START WITH rn = 1
CONNECT BY prior rn = rn - 1;