Answer Posted / guest

There are three most common types of complex master-detail
relationships:
master with dependent details
master with independent details
detail with two masters

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