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
- 1283 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between $$DATE$$ & $$DBDATE$$
What is an Alert ?
What is the content view and stacked view?
What is the use of Printer Definition file (PRT) in Reports ?
How do u give the list of values in bind parameter
What are the type of triggers available in Oracle Reports ?
3 Answers Convergys, IBM, KPIT, Oracle, TCS,
Can we invoke one form from another in a multi-forms application?
Any attempt to navigate programatically to disabled form in a call_form stack is allowed?
To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?
Where is a procedure return in an external pl/sql library executed at the client or at the server?
Commited block sometimes refer to a BASE TABLE ? True or False.
.fmb will be in which folder
Oracle General 
