SELECT substr(tbl_hotel_guest.address,1,4),
sum(substr(tbl_hotel_guest.address,1,4)) from tbl_hotel_guest
group by substr(tbl_hotel_guest.address,1,4);
当运行以上脚本时,提示如下错误:
ora-01722:无效数字
怎么解决?
...全文
5684打赏收藏
关于SUBSTR的问题:ora-01722:无效数字
SELECT substr(tbl_hotel_guest.address,1,4), sum(substr(tbl_hotel_guest.address,1,4)) from tbl_hotel_guest group by substr(tbl_hotel_guest.address,1,4); 当运行以上脚本时,提示如下错误: ora-01722:无效数字 怎么解决?