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 a unique key ? : Sql dba
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
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
Is left join inner or outer by default?
can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)
What is the diffrence between IN and EXISTS.which one is faster.
how many tables will create when we create table, what are they? : Sql dba
What is a schema in sql?
How do I sort a table in sql?
What is data modelling in sql?
What's the difference between inner join and left join?
What is a boolean in 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)