I'm trying to create a view with in inline function in db<>fiddle.
I've removed the CREATE VIEW part for now, and am just trying to run the query, just to get to the root issue.
select /*+ WITH_PLSQL */ calc from
(
with
function calculator (m number, r number) return number
is begin
return m * r;
end calculator;
select calculator(3, 2) as calc from dual
);
/
Source: Inline function in a select sub query or create view
When I run that code in db<>fiddle, I get an error:
ORA-00905: missing keyword
What am I doing wrong?