Create Procedure in PLSQL with parameters | Easiest implementation | Oracle

Here is the basic implementation of stored procedure with an easy example in oracle.
A stored procedure is used to perform a task and can / cannot return values.

Code:
create or replace procedure update_salary(p_empno number) is
begin
update emp set sal=sal+1 where empno=p_empno;
commit;
end update_salary;

execute using
exec update_salary(parameter values)

1. My first Android Game made with Unity C#:

2. Configure TensorFlow 2.0 Environment in Windows in 10 minutes

If anybody has any problem in implementing , don't forget to post a comment in comment section.
#sql #oracleplsql