In Oracle 12c , now pl/sql can be used in a select query using new with clause
below is the example:
WITH FUNCTION fun_incr(n IN NUMBER) RETURN NUMBER IS BEGIN RETURN n+1; END; SELECT fun_incr(1) FROM dual;
Admin on Jan 06, 2019 at 12:01 am
If you like dEexams.com and would like to contribute, you can write your article here or mail your article to email@example.com . See your article appearing on the dEexams.com main page and help others to learn.