how to make a parameter optional in the query?

2 Answers   Wipro,

---

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,

---

In interface how u find errors and how to solve. How to fix it?

3 Answers  

---

How to link modules in apps

3 Answers   Zensar,

---

Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  

---

please send me forms, xml pulisher questions,answers

0 Answers   Zensar,

---

in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?

2 Answers   Oracle, Schneider,

---

How many phases of implementation and what are those.

2 Answers   Accenture,

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

0 Answers  

---

What are the User PARAMETERS in the Reports?

6 Answers   Accenture, CTS,

---

How can u populate data into po_headers_all segment2 column?

1 Answers   BirlaSoft,

---

P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?

9 Answers   CSC, IBM, KPIT, Oracle,

---