Answer Posted / mirmaqsood123

A query record group is a record group that has an
associated SELECT statement. The columns in a query record
group derive their default names, data types, and lengths
from the database columns referenced in the SELECT
statement. The records in a query record group are the
rows retrieved by the query associated with that record
group.
Query record groups can be created and modified at design
time or at runtime.

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

2227