Answer Posted / chaudhry

$$DBDATE$$ retrieves the current database date
$$date$$ retrieves the current operating system date.

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

2219