select lpad ('1w24', 12, '0') from dual se desejar preencher à direita, use o RPAD
select lpad ('1w24', 12, '0') from dual