Interested to Buy Any Domain ? << Click Here >> for more details...
What is Overloading of procedures ?
- 4 Answers
- 11422 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 |
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
Can we use more than one null value for unique key?
31 Answers A1 Technology, Wipro,
How will you select unique values from a list of records?
What is trigger types in sql?
what is the difference between pragma exception_init and raise_application_error
1 Answers Aetins, State Street,
How do I view a table in sql?
What is dba in sql? : SQL DBA
What does closing a cursor do?
What is the difference between nested table and varray?
What is coalesce sql?
Why do we need pl sql?
Compare sql & pl/sql
-
Oracle (3253) - 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)
