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"

Why use truncate instead of delete?

1017

---

What is a schema sql?

1156

---

What is a dirty read sql?

1139

---

Does user triggers have entry for trigger with compilation errors?

1034

---

how to extract a unit value from a date and time? : Sql dba

990

---

Does normalization improve performance?

1039

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1020

---

What is cartesian join in sql?

1131

---

How do I edit a stored procedure?

992

---

what are the t string functions available in tsql? : Transact sql

1009

---

What is rank function in sql?

1028

---

What is type and rowtype in pl sql?

1016

---

What is sql injection owasp?

1066

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1067

---

How many types of literals are available in pl sql?

1119

---