Selection predicate on an outer joined table

[jmodic]

Again,
select empno, ename, deptname
from emp, dept
where emp.deptno = dept.deptno (+) and
NVL(dept.LOCATION, 'TVM') = 'TVM'

But NVL is oracle specific.. so that too is not recommended..

The outer join syntax you are using is also Oracle specific, so wher's the point in not using NVL()?

Anyway, how about this one?

select empno, ename, deptname
from emp, dept
where emp.deptno = dept.deptno (+) and 
          dept.LOCATION(+) = 'TVM'