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;
/

Can you have two stored functions with in the same name?

3 Answers  

---

why we can use synonym?

6 Answers  

---

When loading data from staging table to interface table , how to reload the invalid record once again ?

6 Answers   Accenture,

---

which parameters passed in report in oracle developer how to pass

3 Answers  

---

In thet custom.pll what are the events we can write.

2 Answers   IBM,

---

what is the difference between character mode,bitmap mode

2 Answers   IBM, Sierra Atlantica,

---

HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION

1 Answers   TCS,

---

what is the standard program for blanket po to process data from interface table to bace table

3 Answers   Zensar,

---

Do you know what is applysys in oracle application database schema, what is apps?

0 Answers  

---

q)what are the validations in sql*loader

0 Answers   Accenture,

---

in ap_terms table what data will be stored

2 Answers   Wipro,

---

what is unit of measure classes? give atleast two examples. name the underlying table.

1 Answers   Scan Steel,

---