Answer Posted / Kusum Tiwari

Global segments in Oracle Forms Reports are accessible from any form, block, or trigger within the application. They retain their values even after navigating away from the current form.nnContext-sensitive segments, on the other hand, are only accessible within a specific form or block and lose their values when the user navigates away.nnGlobal segments can be declared using the GLOBAL keyword, while context-sensitive segments should be defined without any keywords.

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