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
- 1694 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
When will ON-VALIDATE-FIELD trigger executed ?
What is the difference between flex mode and confined mode?
What are the different Parameter types?
What are all the system Parameters available in ORACLE Reports
What are the different modals of windows?
What are the various configuration files that are used by oracle forms?
What is the use of Printer Definition file (PRT) in Reports ?
How many pages you can in a single form ?
what are different types of canvas views?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
What do you understand by lov?
What is a difference between pre-select and pre-query?
Oracle General 
