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
- 15901 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 is the difference between call_form, new_form and open_form?
What is a user exit program in oracle reports?
How can we generate report output in excel format?
what is oracle forms?
Name the different triggers supported by oracle reports and their firing order.
did u p prepared complex report
all steps of bitmap report?
Explain master-detail relationship with some examples.
How can we expand Parameter Form Canvas on Reports 6i?
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
i am writing a query select EmpNo from Emp how can i call in after parameter form
In what sequence do triggers get fired by oracle forms?
What is an oracle report?
what are the new features introduced in oracle form services in 11g release 2?
Is it possible to execute a dynamic sql from forms?
