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 the difference between anonymous block and named blocks?
In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?
What is a native sql query?
What is primary key in db?
Is record in pl sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
How do I create an index in word?
why use cursors?
Which is faster joins or subqueries?
What is sql prepared statement?
How to remove duplicate rows from a table?.
What is a full join?
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)