vpd nested queries

Hi all,

Just wondering whether Oracle's current VPD technology lets policy functions return queries that are appended to the WHERE clause. Thus the net result would be a nested query.

for example, if the query was

select * from employee

could the policy function return

return 'salary >= all (SELECT salary from employee where DeptId = 10)'

thanks Received on Wed Oct 13 2004 - 13:41:57 CDT