Oracle强化练习

1、将IP地址192.168.17.1 显示成 192.168.17.*

select concat(substr('192.168.10.1',1, instr('192.168.10.1','.',3,3)),'*') from dual