Home » SQL & PL/SQL » SQL & PL/SQL » Re: how use the if condition to check inputs in pl sql
Re: how use the if condition to check inputs in pl sql [message #36519] Sun, 02 December 2001 23:24
tinel
Messages: 42
Registered: November 2001
Member
to check if a value is in a table or not use the folowing:
declare
value varchar2(20);
begin
select custid into value form ... where custid = your_value_for_check;

if (value is null) then ....
or
exception
when no_data_found then ...

end;

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: How can send e-mail using a Trigger?
Next Topic: Help me problem with metadata and columns
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 26 07:34:42 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.