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
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.
Explain master-detail relationship with some examples.
what exactly u write in when_new_form_instance
List the different types of columns in oracle reports.
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
Explain how one can iterate through items and records in a specified block?
What are the various configuration files that are used by oracle forms?
what is a package n what r the packages availbla in report
what are the oracle forms services components include?
Explain the various types of oracle report?
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
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
Name the different triggers supported by oracle reports and their firing order.
Can we invoke one form from another in a multi-forms application?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.