Answer Posted / vipin kumar

This is how its works

create or replace package vips_test as
function addition(a1 in number, b in number, c1 in number default 0) return number;
function addition(a1 in number, b in number ,d1 in number default 0) return number;
end;
/
show errors;


create or replace package body vips_test as

function addition(a1 in number, b in number, c1 in number default 0)
return number is
begin
dbms_output.put_line('---------------1----------------------');

return a1+b+c1;
end;


function addition(a1 in number, b in number ,d1 in number default 0)
return number is
begin
dbms_output.put_line('---------------2----------------------');

return a1+b+d1;
end;


end;
/
show errors;


select vips_test.addition(a1 => 1 ,b =>2, c1 => 2) from dual;

but if you will try calling as above

select vips_test.addition(a1 => 1 ,b =>2) from dual;

SQL Error: ORA-06553: PLS-307: too many declarations of 'ADDITION' match this call
06553. 00000 - "PLS-%s: %s"

List different type of expressions with the example.

973

---

How to rename a column in the output of sql query?

1124

---

Why having clause is used in sql?

1019

---

How can a pl sql block be executed?

1004

---

How do I partition a table in sql?

1208

---

What is difference between joins and union?

1194

---

what is sub-query? : Transact sql

1161

---

What is sql used for?

1164

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

1064

---

What is the difference between the sql*loader and import utilities? : aql loader

1094

---

How to revise and re-run the last sql command?

1218

---

What is substitution variable in pl sql?

1107

---

What is dml and ddl?

1009

---

What is forward declaration in pl sql?

1141

---

Is sql a scripting language?

1086

---