这个sql自定义函数
CREATE FUNCTION IsSpeciality(@SpeList nvarchar(1000),@Spe nvarchar(20))
RETURNS int AS
BEGIN
RETURN(CHARINDEX(','+@Spe+',',','+@SpeList+','))
END
在oracle中要怎么写?谢谢!
CREATE FUNCTION IsSpeciality(@SpeList nvarchar(1000),@Spe nvarchar(20))
RETURNS int AS
BEGIN
RETURN(CHARINDEX(','+@Spe+',',','+@SpeList+','))
END
在oracle中要怎么写?谢谢!
RETURN(instr(',' || SpeList || ',',',' || Spe || ','));
我是刚学oracle的,很多语法都不懂!
RETURN int AS
BEGIN
RETURN(instr(',' || SpeList || ',',',' || Spe || ','));
END;