Re: Preferred way to check a record exists

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Wed, 17 Sep 2003 23:18:11 +1000
Message-ID: <3f685f0b$0$14560$afc38c87@news.optusnet.com.au>

"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:3f685e68$0$23150$afc38c87_at_news.optusnet.com.au...

let's try again...

>
> Pure SQL?
> select
> nvl((select 'Y' from People where ....),'N')
> from dual;
>
>
> PL/SQL?
> NO_DATA_FOUND sounds good to me.
> Although this should also work:
> select
> nvl((select 'Y' from People where ....),'N')
> into l_var
> from dual;
> if (l_var = 'Y') then
> .
> .
> .

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam


>

Received on Wed Sep 17 2003 - 08:18:11 CDT