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
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
List out the oracle forms configuration files?
how do u place it in required folder
how report can be generated if we have the database designed in oracle 10g?
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?
What are the various configuration files that are used by oracle forms?
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
Name the different triggers supported by oracle reports and their firing order.
What is a canvas in oracle forms?
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
In what situation u create the BPA.
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
what is difference between group above and group left report
i am writing a query select EmpNo from Emp how can i call in after parameter form