A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
2 7287Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the smae block level ?
2 3894Post New Oracle Forms Reports Questions
How to create Drill down report?
if u want to delete all these detail block etc what will happen in form
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
if some data is not transfered where it will get stored
In what situation u create the BPA.
hiding item in report how like that properly,thats manually but at runtime i want to do
all steps of bitmap report?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
Explain master-detail relationship with some examples.
where do u put the report file
a text item is there what r the different types of triggers associated with it
What do you understand by lov and how can it be used?
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
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
Explain how one can iterate through items and records in a specified block?