Recent content by trilobit

Thanks a lot, I dont recognized the switch from SQL to PL/SQL due to function definition...

Hi developers, next query works from Oracle 12.2 in sqlplus , SQL developer and sqlcl but not in PL/SQL developer Version 15.0.4.2064 (64 bit). SQL> WITH FUNCTION f_test RETURN NUMBER IS BEGIN RETURN 1; END; cte_test ( id ) AS ( SELECT 1 FROM DUAL ) SELECT f_test()...