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"

Is primary key clustered index?

945

---

what is cross join? : Sql dba

988

---

How to display Row Number with Records in Oracle SQL Plus?

1035

---

What is the difference between microsoft access and sql?

1012

---

How do sql triggers work?

1030

---

What is rownum and rowid?

1025

---

What is difference between stored function and application function?

1187

---

Does sql require a server?

1002

---

What is difference between left and right outer join?

981

---

Can we insert data in view?

953

---

What are expressions?

1001

---

What is delimiter sql?

977

---

What's the difference between a primary key and a clustered index?

982

---

What is primary key secondary key alternate key candidate key?

1029

---

what is bcp? When does it used? : Sql dba

982

---