Answers

Question and Answer:

  Home  SQL

⟩ Read the following code

10. CREATE OR REPLACE PROCEDURE find_cpt

11. (v_movie_id {Argument Mode} NUMBER, v_cost_per_ticket {argument mode} NUMBER)

12. IS

13. BEGIN

14. IF v_cost_per_ticket > 8.5 THEN

15. SELECT cost_per_ticket

16. INTO v_cost_per_ticket

17. FROM gross_receipt

18. WHERE movie_id = v_movie_id;

19. END IF;

20. END;

Which mode should be used for V_COST_PER_TICKET?

1. IN

2. OUT

3. RETURN

4. IN OUT

 140 views

More Questions for you: