Examine This Function:

  • 15 Jan, 2012

    61. CREATE OR REPLACE FUNCTION set_budget62. (v_studio_id IN NUMBER, v_new_budget IN NUMBER) IS63. BEGIN64. UPDATE studio65. SET yearly_budget = v_new_budgetWHERE id = v_studio_id;IF SQL%FOUND THENRETURN TRUEl;ELSERETURN FALSE;END IF;COMMIT;END;Which code must be added to successfully compile this function?1. Add RETURN right before the IS keyword.2. Add RETURN number right before the IS keyword.3. Add RETURN boolean right after the IS keyword.4. Add RETURN boolean right before the IS keyword.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.