oracle實現(xiàn)split函數(shù) 給Oracle添加split和splitstr函數(shù)的方法?
給Oracle添加split和splitstr函數(shù)的方法?如何返回Oracle的split函數(shù)截獲的一行數(shù)據(jù)]ustruSplitIsTableOfVarchar2(4000)CREATEORREPL
給Oracle添加split和splitstr函數(shù)的方法?
如何返回Oracle的split函數(shù)截獲的一行數(shù)據(jù)]ustruSplitIsTableOfVarchar2(4000)
CREATEORREPLACEFUNCTIONsplit(puStrInvarchar2,puDelimiterInvarChar2)
RETURNtyuStruSplit
IS
jINT:=0
iINT:=1
lenit:=0
len1INT:=0
strVARCHAR2(4000)
str splittyuStr split:=tyuStrsplit()
BEGIN
len:=長度(pustr)
len1:=長度(pudelimiter)
WHILEj