Answer Posted / deepak

add one more parameter in your form

syntax:
Add_parameter
(<param_list>,<parma_variable>,<parameter_type>,<parameter_v
alue>);

Example:
add_parameter(pi_id,'PARAMFORM',TEXT_PARAMETER,'NO');
---------------------------------

note:

Dont change underline parameter.

What is an oracle report? List its various types.

1018

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2187

---

did u p prepared complex report

2048

---

Explain the various types of oracle report?

1130

---

i am writing a query select EmpNo from Emp how can i call in after parameter form

2184

---

what is a package n what r the packages availbla in report

2156

---

what is oracle forms?

1158

---

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

3046

---

what are the new features introduced in oracle form services in 11g release 2?

1075

---

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1205

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1749

---

What is an oracle report?

1118

---

Why oracle forms required?

1093

---

Explain master-detail relationship with some examples.

1052

---

where do u put the report file

2133

---