Answer Posted / bunty

Yes. you can create package where overloading will be
identified by using type of arguments.

Following code will work fine,
--WORK's FINE

create or replace package PK_TEST AS

procedure p1(a IN varchar);
procedure p1(a IN varchar2);
procedure p1(a IN char);

end PK_TEST;

But,following code will not work as p1( v1 IN varchar) and
p1(v3 IN varchar) has the same type of arguments.

--NOT WORK
create or replace package PK_TEST AS

procedure p1(v1 IN varchar);
procedure p1(v2 IN varchar2);
procedure p1(v3 IN varchar);

end PK_TEST;

Cheers,
Bunty

How many types of cursors are available in pl/sql?

1167

---

What is data manipulation language?

1234

---

Are stored procedures faster than queries?

991

---

How do you use a while loop in pl sql?

1056

---

What is the difference between database trigger and stored procedure?

1141

---

What is cte?

1025

---

What is relationship? How many types of relationship are there?

1264

---

Which certification is best for sql?

1042

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

1016

---

What is difference between hql and sql?

1166

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

2169

---

Why do we use cursors?

1046

---

What is %type in pl sql?

1012

---

how is myisam table stored? : Sql dba

1099

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4099

---