[Solved]Functions Following Statement Creates Function Getbal Sample Table Oeorders Create Functio Q37106109

1. Functions:

The following statement creates the functionget_bal on the sample tableoe.orders :

CREATE FUNCTION get_bal(acc_no IN NUMBER)

   RETURN NUMBER

   IS acc_bal NUMBER(11,2);

   BEGIN

      SELECT order_total

      INTO acc_bal

      FROM orders

      WHERE customer_id =acc_no;

      RETURN(acc_bal);

    END;

/

Write a function that returns the total amount a customer paysfor an order when the orderID is known.

NOTE: Can you provide the screenshot of the answers?

Expert Answer

---

Answer to Functions: The following statement creates the function get_bal on the sample table oe.orders : CREATE FUNCTION get_bal… . . .