Answer / anil_abbireddy

Yes,
Ex:-
select empno,ename,sal,sal*10/100 hike from emp;
expl: here hike is the formula column obtained through
select statement

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

1 Answers  

---

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

0 Answers  

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

1 Answers  

---

What are the triggers associated with the image item?

1 Answers  

---

What is the remove on exit property?

1 Answers  

---

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 Answers  

---

Please tell me what is wrong in the below query: (Very Urgent) ================================================= function BeforePForm return boolean is begin if :from_invoice_date is null OR :to_invoice_date is null then aiv.PERIOD_NMAE:=:gl_period elsif :gl_period is null then aiv.INVOICE_DATE between :from_invoice_date and :to_invoice_date end if; return (TRUE); end;

2 Answers   TCS,

---

List the editors availables in forms 4.0?

1 Answers  

---

What are the types of trigger actions?

4 Answers   Zensar,

---

What is a library in Forms 4.0?

1 Answers  

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

0 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,

---