Interested to Buy Any Domain ? << Click Here >> for more details...
can use the following like overloading concept in a single
package:
procedure p1(a varchar),
procedure p1(a varchar2),
procedure p1(a char)
- 5 Answers
- 8406 Views
- I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What are the different operators available in sql?
Show the two pl/sql cursor exceptions.
What is percent sign in sql?
what are different types of collation sensitivity? : Sql dba
How can you fetch first 5 characters of the string?
What are different functions in sql?
How delete all data from all tables in sql?
what is top in tsql? : Transact sql
What are the advantages of sql? Explain
Mention what is the plv (pl/vision) package offers?
Does group by remove duplicates?
What is the difference between microsoft access and sql?
what is primary key? : Sql dba
What's the difference between a primary key and a clustered index?
What do you mean by stored procedures? How do we use it?
