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 a record in a database ? : Sql dba

1045

---

what is a primary key? : Sql dba

1025

---

Can we use pl sql in mysql?

994

---

What are the two types of cursors in pl sql?

1058

---

How many triggers can be applied to a table?

1038

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

955

---

what is self join and what is the requirement of self join? : Sql dba

1120

---

Is it possible to update views?

946

---

How to change the order of columns in Oracle SQL Plus ?

1039

---

What is an emotional trigger?

983

---

Why are cursors used?

1104

---

What is mutating sql table?

1088

---

Can a composite key be null?

959

---

Why query optimization is needed?

905

---

What is pl sql record in oracle?

1010

---