By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,795 Members | 1,666 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,795 IT Pros & Developers. It's quick & easy.

If exists in PL/sql

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.