What is Overloading of procedures ?
Answers were Sorted based on User's Feedback
Answer / tulsi
The Same procedure name is repeated with parameters of
different datatypes and parameters in different positions,
varying number of parameters is called overloading of
procedures.
e.g. DBMS_OUTPUT put_line
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nithin
The procedures with same name and difference in
number,order or data type family. The pjrocedures should be
in PL/SQL block, a sub program or package. Stand alone
procedures cannot be overloaded.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is text? : Sql dba
What is cte?
What are the qualities of 2nf?
What is an exception in pl/sql?
How can a function retun more than one value in oracle with proper example?
What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.
How to avoid duplicate records in a query?
What are the different types of database management systems?
how to do backup entire database? : Transact sql
Can you call pl/sql package functions from within a fast formula?
in a package one procedure is wrong package shows valid or not
Where the integrity constrints are stored in Data Dictionary?
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)