Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 0 Answers
- 1623 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the use of Validation triggers in Reports?
Can you attach an lov to a field at run-time? if yes, give the build-in name.
Where do u define the select statement of the parameter? is it followed by the & variable ?
can i send the control file path as a parameter
Two popup pages can appear on the screen at a time ?
What is the difference between setting up of parameters in reports 2.0 reports ?
What are the two ways by which data can be generated for a parameter's Using static values?
What are the different file extensions that are created by oracle reports?
what ia an object groups?
Can a formula column be obtained through a select statement?
in compatibility in report registration?
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.
Oracle General 
