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

In hierarchical structure of a database? we have write query from where we should start?

2307

---

Is soa a part of oracle fusion middleware?

1157

---

What do you understand by soa?

1196

---

What are the different components you should consider while defining a responsibility in oracle apps?

1130

---

Can you define an erp system?

1229

---

How is choreography different from orchestration?

1180

---

Suppose 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 lessthen it must shows some error how we will make?

1112

---

How can you achieve loose coupling in soa framework?

1280

---

What are file in oracle.

2289

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2262

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2438

---

tell my any difficult situtation you solved in your experience in your company?

2363

---

Explain oracle apps architecture.

1304

---

do you know is it possible to run the interface without using oracle apps?

1169

---

How can a process be deployed in soa?

1338

---