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
What is an oracle report?
what are the new features introduced in oracle form services in 11g release 2?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
Can we invoke one form from another in a multi-forms application?
how to send file attachment from oracle forms
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
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
can you convert or reverse engineer a fmx back to a fmb file?
what is difference between group above and group left report
difference between global n context sensitive segments?
Is it possible to execute a dynamic sql from forms?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
Explain how can you use the same lov for 2 columns?
What is the difference between bind and lexical parameter?