With function ORA-00933: SQL command not properly ended - 11/23/17 11:53 AM
When I run this in SQL window:
with function foo return number is
begin
return 1;
end;
select foo from dual;
I get "ORA-00933: SQL command not properly ended"
If I remove semicolon after dual, it works.
Tested in sqlplus, it works fine with the semicolon.
with function foo return number is
begin
return 1;
end;
select foo from dual;
I get "ORA-00933: SQL command not properly ended"
If I remove semicolon after dual, it works.
Tested in sqlplus, it works fine with the semicolon.