Re: If exists in PL/sql
From: hrishy <hrishys_at_yahoo.co.uk>
Date: 9 Jun 2004 20:40:21 -0700
Message-ID: <4ef2a838.0406091940.5f2bd307_at_posting.google.com>
end
Date: 9 Jun 2004 20:40:21 -0700
Message-ID: <4ef2a838.0406091940.5f2bd307_at_posting.google.com>
Hi
DECLARE
l_count NUMBER; BEGIN select count(*) into l_count from all_tables where table_name = 'ur_table'; if l_count > 0 then do somthing; end if; END;
another way would be very simply
begin
select 'X' from ur_table; do something exception write exception handling code
end
regards
Hrishy
"Paulos" <paulos-spamfree_at_skynet.be> wrote in message news:<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 Thu Jun 10 2004 - 05:40:21 CEST