Why the first statement is not working.
I want to use EXCEPT
connect to UDBPERF;
select dept_id from new.dept m except (select 1 from new.dept p where
p.parent_d = m.member_id and m.hirachy level_id = '50');
select dept_id from new.dept m where not exists (select 1 from new.dept
p where p.parent_d = m.member_id and m.hirachy level_id = '50');
cheers.....