oracle 函数oracle编写函数

oracle编写函数

长度大于等于7的返回其剩余字符串,剩余? create?or?replace?function?my_fun(item?varchar2)?return?varchar2?is begin ??if?length(item)?>=?7?then ????return(substr(item,?7?+?1)); ??else ????return(substr(item,?3,?1)); ??end?if; end;