Home/ Questions/Q 1922
Next
In Process

SIKSHAPATH Latest Questions

SUMIT2552
  • 1
  • 1
Asked: 2021-10-31T14:20:10+05:30 In:

calculate electricity bill- dbms

  • 1
  • 1

calculate electricity bill- dbms Create a procedure or function to calculate electricity bill as per the following criteria:   For first 100 units: Rs. 5 per unit   For 101-150 units: Rs. 7 per unit   For 151-300 units: Rs. 7.50 per unit   For 301 onward units: Rs. 8 per unit

worksheet
Share

    1 Answer

    2. I'M ADMIN

      CREATE OR REPLACE PROCEDURE E_bill(unit in number,net out number) is

      BEGIN

      –drop procedure E_bill

      –for first 100 unit :RS 5 per unit

      if (unit between 0 and 100) then . . . . . . . .

       

      TAP ON ATTACHMENT BUTTON FOR ANSWER:

      Attachment

    Leave an answer

    You must login to add an answer.

    Need An Account,