Re: PL/SQL Cursor : Is this the best way?

Couldn't you just:

select a.name
from table_a a, table_b b
where a.name = b.name(+)
and a.status = 'P'
and b.name is null

• Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****