i have errors for my pl/sql

[Aljaz]

You could try like this

select
   ename, (select NVL(MIN(ename),'NO MANAGER') from emp b where b.empno = a.mgr) MANAGER
from emp a