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.

Can we call a function containing dml statements in a select query?

966

---

How do I view a procedure in sql?

957

---

What does select * from mean in sql?

3206

---

What is tuple in sql?

1058

---

How to start oracle sql developer?

1023

---

How to read/write files from pl/sql?

1030

---

What is null in pl/sql?

1058

---

What is the process of debugging?

1060

---

Is drop table faster than truncate?

984

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

963

---

Is sql scripting language?

1040

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1048

---

how do you know if your mysql server is alive? : Sql dba

1071

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

1003

---

What do you understand by case manipulation functions?

1024

---