Answer Posted / manoj.oracle

if you want to display images,font style,etc you should use
bit map mode.
chatacter mode allows only characters

What is the difference between bind and lexical parameter?

1114

---

did u p prepared complex report

2048

---

What is an oracle report?

1119

---

Why oracle forms required?

1093

---

if some data is not transfered where it will get stored

1990

---

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

---

How can we generate report output in excel format?

1036

---

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1944

---

what are bind variables?

1142

---

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

2096

---

What is a canvas in oracle forms?

1113

---

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

2035

---

Is it possible to have multiple layouts in a report?

1086

---

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2290

---

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

2188

---