How do u give the list of values in bind parameter
Answer Posted / vetrikumaran
GO TO THE PROPERTY PALLETE OF USER DEFINED PARAMETER AND
SELECT THE PROPERTY AS LIST OF VALUES..
THEN IT SHOWS STATIC AND SELECT..SELECT THE SELECT OPTION
AND WRITE THE QUERY..NOW IN THE OUTPUT,WE CAN FIND THE LIST
OF PARAMETER VALUES..
USER WILL SELECT THE VALUES ONLY FROM LOV.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
a text item is there what r the different types of triggers associated with it
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
what are bind variables?
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
where do u put the report file
did u p prepared complex report
what is difference between group above and group left report
What is an SQL FORMS ?
difference between global n context sensitive segments?
List out the oracle forms configuration files?
Is it possible to have multiple layouts in a report?
What do you understand by oracle forms?
In what sequence do triggers get fired by oracle forms?
hiding item in report how like that properly,thats manually but at runtime i want to do
What do we mean by record group in oracle forms?