Interested to Buy Any Domain ? << Click Here >> for more details...
What is Overloading of procedures ?
- 4 Answers
- 11075 Views
- Amdocs, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / madhuri
You can use the same name for different procedures if their
formal parameters differ in number, order, or data type family.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / swapna
Overloading procs are 2 or more procs with the same name
but different arguments.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / yalamanda
by using the same name we can write any no.of
procedures/functions in a package.but either no.of
parameters in the procedure/function must be varry or
parameter datatype must be varry
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / jyothsna
2 or more procedures or functions are called overloaded when
a) They have the same names
b) Different no of formal parameters defined
c) Formal parameters differ in their datatypes/Subtypes and
not in the same family
d) They belong to same subprogram/package/PL SQL Block
They are not overloaded when
a) Any of the above points are not satisfied
b) RETURN datatype alone differs and not the formal
parameters
The main purpose of overloading procedures is that, when a
PL SQL block is found to do a same operation with different
inputs, we names them same and feed different parameters
| Is This Answer Correct ? | 0 Yes | 2 No |
how to calculate expressions with sql statements? : Sql dba
How can you load multi line records? : aql loader
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What are the benefits of pl/sql packages?
What is the difference between sql, mysql and sql server?
How many sql are there?
have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
What are the benefits of triggers?
What is self-join and what is the requirement of self-join?
Can we call procedure in select statement?
What is flag in sql?
What is the difference between database trigger and stored procedure?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
