Answer / siddharth

Package overloading: Packages can contain multiple iterations of procedures with the same name using different parameters. This is called 'overloading'.
Package overloading is possible in Oracle.

Example:
Identify An Overloaded PACKAGE

SELECT overload, position, argument_name, in_out, data_type
FROM all_arguments
ORDER BY overload, position;


CREATE OR REPLACE PACKAGE overload_pkgIS
PROCEDURE insby(namein VARCHAR2);
PROCEDURE insby(numbin PLS_INTEGER);
END overload_pkg;
/

what do you mean by value sets

8 Answers   Convergys,

---

for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake

3 Answers  

---

In sequence i want to 11 and 15th values how we will write?

0 Answers  

---

While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions

3 Answers   IBM,

---

Is it possible to do purchase order without requisition?

8 Answers  

---

---

Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?

3 Answers   Oracle,

---

wht is the use of Xml reports over reports6i?

5 Answers  

---

What is REF Cursor?

19 Answers   Infosys, Intelligroup,

---

Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?

4 Answers   Zensar,

---

WHAT IS THE USE OF SKIP WHERE U WILL GIVE?

3 Answers  

---

If there is any issue then whom do you report.(this is imp question for every interview)

3 Answers   Accenture,

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

0 Answers   Tech Mahindra,

---