Answer Posted / Amit Rajdeo Singh

An Implicit Anchor in Oracle Forms Report Builder is a reference to an object that serves as the starting point for a navigation or calculation operation. It can be automatically determined based on the report structure, such as the first object on a page. On the other hand, an Explicit Anchor is a specific object explicitly defined by the developer for navigation or calculation purposes.

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