1 Reply Latest reply: May 27, 2014 11:11 AM by rp0428 RSS

    store function

    2bfe4993-9233-48d8-b2d4-ecead73feffa

      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;