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;
If you like dEexams.com and would like to contribute, you can write your article here or mail your article to firstname.lastname@example.org . See your article appearing on the dEexams.com main page and help others to learn.