plz explain when we are using
pre-query,post-query,pre-insert and post-insert?plz explain
with one example
- 2 Answers
- 14679 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
did u p prepared complex report
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
What is a user exit program in oracle reports?
what is difference between group above and group left report
What is an oracle report?
What is responsibility and how u attach How to create user and how u attach with responsibility.
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
a text item is there what r the different types of triggers associated with it
hiding item in report how like that properly,thats manually but at runtime i want to do
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.
difference between global n context sensitive segments?
What is the difference between flex mode and confined mode?
why the Ctl file u put only in bin folder why not in other folder
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
all steps of bitmap report?
