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;

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


Current Time: Mon Apr 06 01:15:25 CDT 2020