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 |
how can we find the select statement is indexed or not?
How is data stored on a disk?
When sql appeared?
Why is sql important?
what are aggregate and scalar functions? : Sql dba
How do you update a sql procedure?
How do I clear the screen in sql plus?
what are null values? : Sql dba
What is referential integrity ?
If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please
how would you enter characters as hex numbers? : Sql dba
what is data integrity? : Sql dba
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)