select VC_ID,VC_NUM,length(translate(VC_NUM, ' 0123456789', ' ')),t.rowid
from 表名 t WHERE
length(translate(TRIM(VC_NUM), ' 0123456789', ' '))>1
select VC_ID,VC_NUM,length(translate(VC_NUM, ' 0123456789', ' ')),t.rowid
from 表名 t WHERE
length(translate(TRIM(VC_NUM), ' 0123456789', ' '))>1
![oracle中的start with connect by用法[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)