SELECT LISTAGG(a_number, '; ') 
FROM Table
where b_number='xxxx' and substr(day,1,4)='201703';

ParseException line 1:26 cannot recognize input near '<EOF>' '<EOF>' '<E OF>' in select expression