select distinct (case\n" +
" when a.safeguard_person like '%/%' then\n" +
" regexp_substr(a.safeguard_person, '[^/]+', 1, 2)\n" +
" else\n" +
" a.safeguard_person\n" +
" end) as user_agentid\n" +
" from T_OWS_ZB_PRODUCTLINE a\n" +
" where a.safeguard_id = ?