Answer Posted / vetrivel

The REPORTS types total 8 in only ORACLE 6i & 9i
1.Tabular,
2.Form-Like,
3.Mailing Label,
4.Form Letter,
5.Group Left,
6.Group Above,
7.Matrix,
8.Matrix with Group

What is an oracle report?

1086

---

What is a user exit program in oracle reports?

1041

---

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

2990

---

what are bind variables?

1095

---

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

1168

---

what is oracle forms?

1111

---

What do you understand by oracle forms?

1053

---

all steps of bitmap report?

2362

---

why the Ctl file u put only in bin folder why not in other folder

2053

---

what is the difference between call_form, new_form and open_form?

1317

---

How can we generate report output in excel format?

1003

---

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

1702

---

Can we invoke one form from another in a multi-forms application?

1141

---

how report can be generated if we have the database designed in oracle 10g?

1891

---

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2909

---