Answer Posted / neeraj siddhey

Overloading: Multiple subprograms of the same name

• Enables you to use the same name for different
subprograms inside a PL/SQL block, a subprogram, or a
package

• Requires the formal parameters of the subprograms to
differ in number, order, or data type family

• Enables you to build more flexibility because a user or
application is not restricted by the specific data type or
number of formal parameters

Note: Only local or packaged subprograms can be overloaded.
You cannot overload stand-alone subprograms.

What is cross join sql?

492

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

532

---

What is mdb stand for?

550

---

What is a natural join?

508

---

What are different types of sql?

553

---

---

What are actual parameters and formal parameters?

560

---

What is the difference between a primary key and a clustered index?

516

---

what is uncommittable transactions? : Transact sql

558

---

What is a heap in sql?

520

---

How do I partition in sql?

531

---

What is fmtonly in sql?

523

---

What is primary key and foreign key with example?

488

---

What is lookup table in sql?

599

---

How do I add a primary key to a table?

535

---

What are the three forms of normalization?

520

---