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'

Can a formula column be obtained through a select statement?

1 Answers   TCS,

---

How can you hide the report in Apps?

1 Answers  

---

Could u tell me, u work as a support & maintenace when sub ledger and gl is mismatch, then how do u match with the both side/

1 Answers   HCL,

---

Explain master-detail relationship with some examples.

0 Answers  

---

Deleting a page removes information about all the fields in that page ?

1 Answers  

---

hiding item in report how like that properly,thats manually but at runtime i want to do

1 Answers  

---

what are different types of canvas views?

3 Answers  

---

What is a Trigger ?

1 Answers  

---

What is the difference between Anchoring Object and Enclosing Objects ?

1 Answers   GE, Netsoft,

---

What is the significance of PAGE 0 in forms 3.0 ?

1 Answers  

---

What is a Check Box?

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,

---