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
- 1783 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
how to eliminate duplictes in column except group and section?
What are the various methods of performing a calculation in a report ?
What do you understand by lov?
What is lexical reference?How can it be created?
How many pages you can in a single form ?
Does a Before form trigger fire when the parameter form is suppressed.
List the buil-in routine for controlling window during run-time?
What is WHEN-Database-record trigger?
What are the types of Pop-up window ?
a text item is there what r the different types of triggers associated with it
Can a sigle canvas be used by different blocks ?
What are the vbx controls?
Oracle General 
