oracle-decode

select scompanyname,sshortname,decode(stype,'00','*','01','非运输','02','合资','03','运输','04','其他') from sm_company