Home » RDBMS Server » Server Administration » IF .... THEN
IF .... THEN [message #371124] Fri, 01 September 2000 07:45 Go to next message
Laert
Messages: 20
Registered: January 2000
Junior Member
HI All,

Is there any idea, how can I write correct in some stored procedure or trigger following:

if exists (select name from table) then
some operations....
end if;

and next one:

if (select count(*) from table) >0 then
some operations....
end if;

My Oracle version is: 8.0.5.0.0
OS Windows NT

Thanx in advance
Laert

Report message to a moderator

Re: IF .... THEN [message #372569 is a reply to message #371124] Fri, 23 February 2001 09:09 Go to previous message
yml
Messages: 1
Registered: February 2001
Junior Member
i'm looking at doing the same. did u find out the answer?

Report message to a moderator

Previous Topic: ....for update
Next Topic: How to return only one row when no easy link?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 08:08:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.