OraFAQ Forum: SQL & PL/SQL » if EXISTS (select ...

Home » SQL & PL/SQL » SQL & PL/SQL » if EXISTS (select ...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

if EXISTS (select ... [message #40314]

Thu, 26 September 2002 12:19

Val
Messages: 12
Registered: March 2002

Junior Member

I have used the "if exists" logic for a while with T-SQL the same way it can be used in SQL 'select' statement. What is a common PL/SQL way to code smth. like:

if exists (select 'x' from X where ...) then
do A
end if;

I am assuming that table X is large and the select statement may return either no or lots and lots of hits.
Thank you.

Report message to a moderator

Re: if EXISTS (select ... [message #40317 is a reply to message #40314]

Thu, 26 September 2002 13:59

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:3069487275935

Report message to a moderator

Previous Topic:	Re: Retrieving records N to N+10 !! Perplexed
Next Topic:	Multiple Rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 16:14:38 CDT 2024