Question: 

 

A stored function to calculate delivery charges given city and weight

 

 

 

 

 

this my answer, can you share if this answer wrong

 

CREATE OR REPLACE FUNCTION CALCULATE_CHARGES

(

CITY IN VARCHAR2

, CHARGES IN NUMBER

, TOTAL IN NUMBER

) RETURN NUMBER AS

BEGIN

RETURN total:=city*charges;

END CALCULATE_CHARGES;

FacebookTwitterLinkedin
Pin It
Joomla Tutorials for Beginners