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
The join defined by the default data link is an outer join yes or no?
What is the built-in used to get and set lov properties during run-time?
Does a Before form trigger fire when the parameter form is suppressed.
How image_items can be populate to field in forms 4.0?
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
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
How can we generate report output in excel format?
What are the different modals of windows?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
Where we can use the placeholder columns?
what is procedure like symbols of bind and lexical
Explain master-detail relationship with some examples.