Multiple choice technology databases

create or replace function add_three_numbers (a number := 0, b number := 0, c number := 0) return number is Begin return a+b+c; End; / Which is not a valid procedure call in Oracle 10g

  1. Begin Dbms_output.put_line(add_three_numbers (3,4,5)); End; /

  2. Begin Dbms_output.put_line(add_three_numbers (a => 3, b=>4,c=>5)); End; /

  3. Begin Dbms_output.put_line (add_three_numbers (3, b=>4,c=>5)); End; /

  4. select add_three_numbers (3, b=>4,c=>5) from dual
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Calling a PL/SQL function from a SQL SELECT statement cannot use named parameter notation; only positional arguments are allowed. The statement select add_three_numbers (3, b=>4,c=>5) from dual is therefore invalid, making the stored answer correct.

Keep practicing — related questions