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 ); /
When I run that code in db<>fiddle, I get an error:
ORA-00905: missing keyword
What am I doing wrong?