<pre><code class="lang-plaintext">CREATE OR REPLACE FUNCTION 
net_sal(vno NUMBER)
RETURN NUMBER
IS
 vsal emp.sal%TYPE;
 vcomm emp.comm%TYPE;
 net NUMBER(10);
BEGIN
 SELECT sal, comm INTO vsal, vcomm 
FROM emp WHERE empno = vno;
 net := vsal + NVL(vcomm, 0);
 RETURN(net);
END;
for output:
select net_sal(7698) from dual;
</code></pre>


```plaintext
CREATE OR REPLACE FUNCTION 
net_sal(vno NUMBER)
RETURN NUMBER
IS
 vsal emp.sal%TYPE;
 vcomm emp.comm%TYPE;
 net NUMBER(10);
BEGIN
 SELECT sal, comm INTO vsal, vcomm 
FROM emp WHERE empno = vno;
 net := vsal + NVL(vcomm, 0);
 RETURN(net);
END;
for output:
select net_sal(7698) from dual;
```

Write a function to return net salary of a given employee