create or replace function GetWorkBeginTime()
return date is
myDate date;
begin
myDate := trunc(sysdate-1)+8/24;
return myDate;
end;写了个函数,可是编译不通过:Compilation errors for FUNCTION REPORTER.GETWORKBEGINTIMEError: PLS-00103: 出现符号 ")"在需要下列之一时:
<an identifier>
<a double-quoted delimited-identifier> current
Line: 1
Text: create or replace function GetWorkBeginTime()怎么解决?请高手指点。
return date is
myDate date;
begin
myDate := trunc(sysdate-1)+8/24;
return myDate;
end;写了个函数,可是编译不通过:Compilation errors for FUNCTION REPORTER.GETWORKBEGINTIMEError: PLS-00103: 出现符号 ")"在需要下列之一时:
<an identifier>
<a double-quoted delimited-identifier> current
Line: 1
Text: create or replace function GetWorkBeginTime()怎么解决?请高手指点。
return date is
myDate date;
begin
myDate := trunc(sysdate-1)+8/24;
return myDate;
end GetWorkBeginTime; 这样试试看
return date is
myDate date;
begin
myDate := trunc(sysdate-1)+8/24;
return myDate;
end;
create or replace function GetWorkBeginTime
return date is
myDate date;
begin
myDate := trunc(sysdate-1)+8/24;
return myDate;
end;