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"

When to use inner join and left join?

937

---

What is primary key and foreign key?

946

---

Can you skip header records while loading? : aql loader

1017

---

differentiate between float and double. : Sql dba

1035

---

Can you do multiple joins in sql?

1018

---

What are % type and % rowtype?

1020

---

How to take user input in pl sql?

1145

---

What is data profiling in sql?

1056

---

What is scalar function in sql?

1016

---

What is the importance of sqlcode and sqlerrm?

1329

---

Which are sql * plus commands?

1105

---

How is a process of pl/sql compiled?

1133

---

What is primary key and unique key?

1096

---

What is the difference between a procedure and a function?

1081

---

What is the advantage of index in sql?

944

---