how can create the lexical parameter after the select class?
Answer Posted / ashutosh
just create a parameter
and write sql command in report like this...
select * from emp
where &condition
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How to create Drill down report?
Explain master-detail relationship with some examples.
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
In what sequence do triggers get fired by oracle forms?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
what is the difference between call_form, new_form and open_form?
what are the new features introduced in oracle form services in 11g release 2?
What is an oracle report?
List the different types of columns in oracle reports.
a text item is there what r the different types of triggers associated with it
how to send file attachment from oracle forms
Name the different triggers associated with oracle forms having a master-detail relationship.
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
why the Ctl file u put only in bin folder why not in other folder