Yurttas/PL/DBL/oracle/F/02/SPJ/get avg.sql
Jump to navigation
Jump to search
1CREATE OR REPLACE
2FUNCTION get_avg RETURN NUMBER AS
3
4 avg_qty NUMBER;
5
6BEGIN
7
8 SELECT AVG(quantity) AS qty
9 INTO avg_qty
10 FROM Shipments
11 WHERE jn = 'J01';
12
13 RETURN(avg_qty);
14
15END;
16/