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
No Answer is Posted For this Question
Be the First to Post Answer
What is a window?
What is lexical reference?How can it be created?
What is a radio Group?
What is a Trigger ?
What is the built-in used to get and set lov properties during run-time?
Use the add_group_column function to add a column to record group that was created at a design time?
What are the two phases of block coordination?
What is the frame & repeating frame?
What is the difference between a Function Key Trigger and Key Function Trigger ?
What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
How can a button be used in a report to give a drill down facility?
HOW TO MAKE A MATRIX REPORT MANUALLY WITH SINGLE GROUPT QUERY OR MULTIPLE GROUP QUERY ?