Home » RDBMS Server » Server Administration » Re: Help with an Oracle SQL Statement
Re: Help with an Oracle SQL Statement [message #374884] Mon, 09 July 2001 23:39
palanikarupaiyan@hotmail.
Messages: 18
Registered: June 2001
Junior Member
in PL/SQL store function wirte the following

SELECT COUNT(*)
INTO V_RecCount
FROM TableX
where StripNo= XXX and Decision ='REJECT'
IF V_RecCount = 0 THEN
RETURN = 'ACCEPT'
ELSE
RETURN = 'REJECT'
ENDIF

Report message to a moderator

Previous Topic: Use DISTINCT on subset of all fields
Next Topic: selecting a long column using % option -- how to ??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 20:27:32 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.