Answer Posted / guest

There are two phases of block coordination: the
clear phase and the population phase. During, the
clear phase, Oracle Forms navigates internally to the
detail block and flushes the obsolete detail records.
During the population phase, Oracle Forms issues a
SELECT statement to repopulate the detail block with
detail records associated witjh the new master record.
These operations are accomplished through the execution of
triggers.

Explain how can you use the same lov for 2 columns?

1094

---

a text item is there what r the different types of triggers associated with it

1960

---

what is tripstop report?

1777

---

did u received a single file or multiple files

1988

---

Explain master-detail relationship with some examples.

964

---

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

2155

---

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

2959

---

What do you understand by oracle forms and why are they required?

972

---

how do u compile a form i.e .fmb file in Unix or in dos

4528

---

Is it possible to have multiple layouts in a report?

989

---

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1949

---

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

2273

---

What do you understand by oracle forms?

991

---

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

1649

---

how do u place it in required folder

1882

---