exists的应用

select 1 from dual where exists(select 1 from dual);

如果结果集不为空则返回true，结果集为空返回false

 

select 1 from dual where not exists(select 1 from dual);