how can create the lexical parameter after the select class?
- 1 Answers
- 5418 Views
- Oracle, I also Faced
- E-Mail Answers
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
Please Help Members By Posting Answers For Below Questions
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
