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
- 16024 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 do you understand by oracle forms and why are they required?
did u received a single file or multiple files
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
What is the difference between bind and lexical parameter?
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?
What do you understand by oracle forms?
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
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.
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
In what situation u create the BPA.
how do u place it in required folder
What do we mean by record group in oracle forms?
a text item is there what r the different types of triggers associated with it
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
