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
Begin Dbms_output.put_line(add_three_numbers (3,4,5)); End; /
Begin Dbms_output.put_line(add_three_numbers (a => 3, b=>4,c=>5)); End; /
Begin Dbms_output.put_line (add_three_numbers (3, b=>4,c=>5)); End; /
select add_three_numbers (3, b=>4,c=>5) from dual