解决方案
select decode(substr(num,1,1),'.','0'||num,num) from table_name
参考：https://blog.csdn.net/menghuannvxia/article/details/73089903
