Interested to Buy Any Domain ? << Click Here >> for more details...
HI
in report builder am creating paramters.for that i have
taken emp table from scott user .
in deptnum am displaying distinct deptno.if i select dept
10 ,empnum drop down should display empno's of deptno 10.
.if i select dept 20 ,empnum drop down should display
empno's of deptno 20.for this wat i have to do.
- 2 Answers
- 4476 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raghav
first create a sql query in the data model like below
select empno from emp no where deptno=:p_deptno.run the
report
| Is This Answer Correct ? | 0 Yes | 0 No |
How to create lov dynamically in oracle forms which is data comes from database procedure of out parameter, data will will out parameter of procedure base
What is the significance of PAGE 0 in forms 3.0 ?
To execute row from being displayed that still use column in the row which property can be used?
When a form is invoked with call_form, Does oracle forms issues a save point?
What is Post-Block?
A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
What is a Non Query Record Group?
While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False.
What is difference between open_form and call_form?
Explain the various types of oracle report?
What is a Check Box?
how to eliminate duplictes in column except group and section?
Oracle General 
