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
Any attempt to navigate programatically to disabled form in a call_form stack is allowed?
what is an object groups?
Is it possible to attach same library to more than one form?
What are the types of Pop-up window ?
Explain the different levels at which oracle form services interact.
What is system.coordination_operation?
what is tripstop report?
What are the built-ins that are used to Attach an LOV programmatically to an item?
what is the diffrence between before parameter form triger & formate trigger
how i build a report
What is a library in Forms 4.0?
I HAVE A REPORT LAYOUT LIKE THIS RUNDATE -FIELD DEPTNO-FIELD ------------------------------------------------------------ ------------------- EMPNO-----ENAME------SAL-----COMM----MGR----- ------------------------------------------------------------ ------------------ ------- ------------ -------- -------- -------- MY REQUIREMENT IS I WANT DEPTNO 10 VALUES IN ONE PAGE,DEPTNO 20 VALUES IN ONE PAGE,AND 30 IN ONE PAGE. I WANT LIKE THIS ....