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
- 1684 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wanna elimenate all -ve values and wann sum of + values in report i m using devsuite 10g its urgent kindly if anyone knows that answer message me the following yahoo id thanx ALI smalipaki@yahoo.com
What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
Is it possible to split the printpreviewer into more than one region?
What is the significance of PAGE 0 in forms 3.0 ?
Can you attach an lov to a field at design time?
What are the triggers associated with the image item?
What are modal windows?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
How do u give the list of values in bind parameter
What is synchronize?
What is an anchoring object & what is its use?
difference between global n context sensitive segments?
Oracle General 
