how can create the lexical parameter after the select class?
Answer / 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 |
What is AppCore and AppCore2 ?
What is the difference between restricted and unrestricted package procedure ?
Can a field be used in a report wihtout it appearing in any data group?
What is a library?
Explain about stacked canvas views?
explain tkprof?
How is link tool operation different between reports 2 & 2.5?
if u have one group can u create another from that
What is the difference between a Function Key Trigger and Key Function Trigger ?
List out the oracle forms configuration files?
How i get the client m/c IP address.
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