mysql存儲(chǔ)過程for循環(huán) oracle存儲(chǔ)過程loop字符串遍歷?
oracle存儲(chǔ)過程loop字符串遍歷?聲明x varchar2(20)vu length inty intvu str varchar2(1)begin x:=“wqr3331412rr”selec
oracle存儲(chǔ)過程loop字符串遍歷?
聲明x varchar2(20)vu length inty intvu str varchar2(1)begin x:=“wqr3331412rr”select length(x)into vu length from dual y:=1,而y<=vu length loop select substr(x,y,1)into vu str from dual dbms_輸出輸出線(v?u str)y:=y 1端環(huán)端
直運(yùn)吧結(jié)如圖