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
- 15875 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 the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
where do u put the report file
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
Explain how one can iterate through items and records in a specified block?
can you convert or reverse engineer a fmx back to a fmb file?
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
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
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.
what are bind variables?
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
What is a matrix report and how many minimum groups are required to prepare the same?
What is responsibility and how u attach How to create user and how u attach with responsibility.
What do you understand by lov and how can it be used?
how to send file attachment from oracle forms
Name the different triggers supported by oracle reports and their firing order.
