Answer / tech knit

first in the main query add to parameter...
supp :deptnum is parameter
then
query...............where :deptnum or :deptnum is null

and in parameter lovs write query
after writing the query in lovs ..uncheck the check box --
'the restrict list to predetermined values'

did u p prepared complex report

0 Answers  

---

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

1 Answers  

---

What is an oracle report? List its various types.

0 Answers  

---

What is the difference between restricted and unrestricted package procedure ?

3 Answers  

---

how will the report recognize the parameter

1 Answers  

---

If two groups are not linked in the data model editor, What is the hierarchy between them?

1 Answers  

---

what is the sequence of firing triggers in forms?

1 Answers  

---

List system variables available in forms 4.0, and not available in forms ?

1 Answers  

---

Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through

1 Answers   Azri Solutions,

---

Can we use GO-BLOCK package in a pre-field trigger ?

2 Answers  

---

What built-in is used for showing the alert during run-time?

1 Answers  

---

What is the frame & repeating frame?

1 Answers  

---