Dear All, Apparently we can define a plsql function or procedure using the with clause in 12c db, base on the example below i would like to know if i can add the clause. So that when updating i update only the required rows.
UPDATE
/*+ WITH_PLSQL */
test_tbl
SET id =
(WITH FUNCTION add_fnc(p_id NUMBER) RETURN NUMBER IS BEGIN RETURN p_id + 1;
END;
SELECT add_fnc(id) FROM dual
);
/
suppose for example i want to add where id =1;
Please note example find in the following link WITH function clause Oracle Database 12C relase 1 (12.1) | DBAORA
Thxx