Interested to Buy Any Domain ? << Click Here >> for more details...
plz explain when we are using
pre-query,post-query,pre-insert and post-insert?plz explain
with one example
- 2 Answers
- 15750 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudipta santra
PRE-QUERY: BEFORE PARSING OF QUERY THIS TRIGGER IS FIRED.
POST-QUERY: AFTER PARSING OF THE QUERY AND BEFORE POST TO
THE DB, IT IS FIRED.
NOTE: THE VALUE CAN BE CHANGED AFTER FIRING PRE-QUERY BUT
THE VALUE CAN NOT BE CHANGED AFTER FIRING POST-QUERY.
PRE-INSERT: BEFORE INSERT IN THE DATA-BLOCK, IT IS FIRED.
POST-INSERT: AFTER INSERT INTO THE DATA BLOCK AND BEFORE
POST INTO THE DB IT IS FIRED.
NOTE: THE VALUE CAN BE CHANGED IN PRE-INSERT BUT NOT
POSSIBLE IN POST-INSERT.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are bind variables?
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
difference between global n context sensitive segments?
What is the difference between flex mode and confined mode?
What are the various configuration files that are used by oracle forms?
What is a canvas in oracle forms?
How can we expand Parameter Form Canvas on Reports 6i?
Explain the various types of oracle report?
Name the different triggers supported by oracle reports and their firing order.
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
what is oracle forms?
all steps of bitmap report?
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
