MEMBER OF 谓词
此表达式测试单值路径表达式或输入参数所指定的对象引用是否是指定集合的成员。
如果多个值的路径表达式指定空的集合,那么
MEMBER OF 表达式的值为 FALSE。
{ single-valued-path-expression | input_parameter } [ NOT ] MEMBER [ OF ] collection-valued-path-expression
示例:MEMBER OF 谓词
找到不是给定部门号的成员的职员:
SELECT OBJECT(e) FROM EmpBean e , DeptBean d
WHERE e NOT MEMBER OF d.emps AND d.deptno = ?1
找到这样一类职员,他们的经理是给定部门号的成员:
SELECT OBJECT(e) FROM EmpBean e, DeptBean d
WHERE e.dept.mgr MEMBER OF d.emps and d.deptno=?1