Try it here
Subscribe
Oracle with clause

Oracle 12C with clause with PL/SQL

oracle_12c_with_clause_with_pl/sql

With Clause

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;

Writer profile pic

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 admin@deexams.com . See your article appearing on the dEexams.com main page and help others to learn.



Post Comment

Comments( 0)

WEB TECHNOLOGY

Articles

×

Forgot Password

Please enter your email address below and we will send you information to change your password.