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
- 8269 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 is restrict in sql?
How do I run a pl sql program?
What is difference between my sql and sql?
How can you tell the difference between an index and a view?
Explain the difference between sql and mysql.
What are keys in sql?
what is a primary key? : Sql dba
Why use stored procedures?
What are the parameter modes supported by pl/sql?
Is sql low level language?
what is the difference between blob and text? : Sql dba
What are different types of queries in sql?
What are different types of sql commands?
What is the difference between python and sql?
Explain some predefined exceptions.
