What is a difference between pre-select and pre-query?
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.
Is This Answer Correct ? | 6 Yes | 4 No |
HOW TO MAKE A MATRIX REPORT MANUALLY WITH SINGLE GROUPT QUERY OR MULTIPLE GROUP QUERY ?
What SYNCHRONIZE procedure does ?
What is a combo box?
What are the vbx controls?
What is the difference between flex mode and confined mode?
all steps of bitmap report?
What is a canvas in oracle forms?
What are the trigger associated with image items?
What is an user exit used for?
What are the built-ins used for finding object ID functions?
When does an on-lock trigger fire ?
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