Answer Posted / guest
fun returns values
proc may or may not return values
fun always contain a return statement
proc not.
fun can be used in select queries
proc can not be.
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
What are the various configuration files that are used by oracle forms?
did u p prepared complex report
Is it possible to have multiple layouts in a report?
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
How can we expand Parameter Form Canvas on Reports 6i?
Explain the various types of oracle report?
What is a user exit program in oracle reports?
Explain how one can iterate through items and records in a specified block?
Name the different triggers supported by oracle reports and their firing order.
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
Explain how can you use the same lov for 2 columns?
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.
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
what are the oracle forms services components include?