Question

oracle数据库自定义函数创建函数带有编译错误

CREATE ORREPLACE FUNCTION GetLastLogin
( name IN Users.UserName% Type )
RETURNLoginInfo.LoginTime % Type
AS
outTimeLoginInfo.LoginTime % Type;
BEGIN
SELECTMAX( 1.LoginTime ) INTO outTime FROM Users u, LoginInfo 1
WHERE u.UserName= ”|| name ||” AND u.UserId = 1.UserId
ORDER BY1.LoginTime DESC;
RETURNoutTime;
END;

Answer 1

关键字不对,应该为:
CREATE_OR_REPLACE

Answer 2

报错信息是什么啊？
WHERE u.UserName= ”|| name ||” AND u.UserId = 1.UserId --》“或”可以用“||”这个符号吗，不是写“or”吗？

Answer 3

报错信息呢。贴出来哈

追问

报错信息就是：创建函数带有编译错误
没有别的

追答

帮你修改了下：
CREATE OR REPLACE FUNCTION GetLastLogin(name IN Users.Username%Type )
RETURN LoginInfo.Logintime%Type
AS
outTime LoginInfo.LoginTime%Type;
BEGIN
SELECT MAX(l.LoginTime)
INTO outTime
FROM Users u,LoginInfo l
WHERE u.UserName= name
AND u.UserId = l.UserId ORDER BY l.LoginTime DESC;
RETURN outTime;
END;