If exists in PL/sql
From: Paulos <paulos-spamfree_at_skynet.be>
Date: Wed, 9 Jun 2004 19:34:33 +0200
Message-ID: <40c74c0c$0$9545$a0ced6e1_at_news.skynet.be>
Hi Guys
Date: Wed, 9 Jun 2004 19:34:33 +0200
Message-ID: <40c74c0c$0$9545$a0ced6e1_at_news.skynet.be>
Hi Guys
I am a bit of a nocice at some aspects of PL/SQL and I have to write some code in a function that checks if a row in a given table exists...something on the lines of :
IF( exists(select 'x' from table) then
do stuff
else
do other stuff
end if;
Is there a quick and efficient way of doing this?
Thnx
Paulos Received on Wed Jun 09 2004 - 19:34:33 CEST