Answer / chaudhry

Fires during the execute query and count query
processing after oracle forms constructs the select
statement to be issued, but before the statement is
actually issued.

The pre-query trigger fires just before oracle forms
issues the select statement to the database after the
operator as define the example records by entering the query
criteria in enter query mode.

Pre-query trigger fires before pre-select trigger.

i created a parameter list in reports. how to restrict that parameter list with parameters

1 Answers   iFlex,

---

What is an SQL FORMS ?

0 Answers   Verizon,

---

What are the difference between lov & list item?

1 Answers   ESS,

---

What is the difference between formula column and place holder?

3 Answers  

---

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

0 Answers  

---

What is the Maximum allowed length of Record group Column?

2 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  

---

What is the content view and stacked view?

2 Answers  

---

How do you reference a Parameter?

1 Answers  

---

What are the Built-ins used for sending Parameters to forms?

2 Answers  

---

What built-in is used for showing the alert during run-time?

1 Answers  

---

How can I sum column wise in Oracle excel report?

1 Answers  

---