Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> If exists in PL/sql

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@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 - 12:34:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US