What is a difference between pre-select and pre-query?
Answer Posted / 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.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Name the different triggers associated with oracle forms having a master-detail relationship.
how to send file attachment from oracle forms
What do you understand by lov?
i am writing a query select EmpNo from Emp how can i call in after parameter form
What is an SQL FORMS ?
What do we mean by record group in oracle forms?
What is the difference between bind and lexical parameter?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
How can we expand Parameter Form Canvas on Reports 6i?
List the different types of columns in oracle reports.
what is difference between group above and group left report
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
what is a package n what r the packages availbla in report
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