Read The Following Code:

  • 7 Jan, 2012

    10. CREATE OR REPLACE PROCEDURE find_cpt11. (v_movie_id {Argument Mode} NUMBER, v_cost_per_ticket {argument mode} NUMBER)12. IS13. BEGIN14. IF v_cost_per_ticket > 8.5 THEN15. SELECT cost_per_ticket16. INTO v_cost_per_ticket17. FROM gross_receipt18. WHERE movie_id = v_movie_id;19. END IF;20. END;Which mode should be used for V_COST_PER_TICKET?1. IN2. OUT3. RETURN4. IN OUT

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 All rights reserved.