PL/SQL Performance tuning

  • 0

    Create a Function to generate water bill amount with respect to given Meter_number, units_consump, Meter_category. We should except only 3 categories ( Residential, Commercial, Industrial). Residential fixed rent 500, Commercial fixed 1000 and industrial fixed rent 2000 rent up to 50 units.
    a) From 51 to 100 per unit rate is Rs 10
    b) From 101 to 300 per unit rate is Rs 20
    c) Units Above 300 rate per unit is Rs 40

Log in to reply

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.