If exists in PL/sql

[Paulos]

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

[hrishy]

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" <pa*************@skynet.be> wrote in message news:<40**********************@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