Answer Posted / mahesh
the sequence of report triggers are
Before parameter form
After parameter form
Before report trigger
Between pages
After report trigger
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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.
What do you understand by oracle forms?
Is it possible to have multiple layouts in a report?
Is it possible to execute a dynamic sql from forms?
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
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 exactly u write in when_new_form_instance
What is the difference between flex mode and confined mode?
What do you understand by oracle forms and why are they required?
what is tripstop report?
What is the difference between bind and lexical parameter?
How can we generate report output in excel format?
did u p prepared complex report
if u want to delete all these detail block etc what will happen in form