Page 67 of 95
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.
117. What is trigger associated with the timer?
When-timer-expired.
118 What is the use of transactional triggers?
Using transactional triggers we can control or modify the
default functionality of the oracle forms.
REPORTS
1. What are the different file extensions that are created by
oracle reports?
Rep file and Rdf file.
2. From which designation is it preferred to send the output to
the printed?
Previewer.
3. Is it possible to disable the parameter from while running the
report?
Yes
4. What is lexical reference?How can it be created?
Lexical reference is place_holder for text that can be embedded in a
sql
statements.A lexical reference can be created using & before the
column or
parameter name.
5. What is bind reference and how can it carate?
Bind reference are used to replace the single value in
sql,pl/sql
statements a bind reference can be careated using a (:) before a
column or
a parameter name.
6.What use of command line parameter cmd file?
|
|