I have a view like this;i have 2 doubts;
1.how to call this view in hibernate;
2.how to add condition to this view like( AND E.EMPNO='123') in hibernate.
create or replace view emp_dept as
"XXXX"."EMP" E, "XXXX"."DEPT" D
WHERE E.DEPTNO = D.DEPTNO