Home » SQL & PL/SQL » SQL & PL/SQL » Re: Return boolean checking condition in multiple records
Re: Return boolean checking condition in multiple records [message #37816] Thu, 28 February 2002 17:29
epro
Messages: 11
Registered: January 2002
Junior Member
Exactly, you are right, in addition,
in 2 scenarios we return FALSE.
==================================
1)when dept <> A or B or C.

2)if dept = C, and if other procedure(is called from this functin), does NOT return C1.
===================================
if I write like this
==============================
begin
for c_rec in c
loop
if c_rec.dept in ('A','B') then
return true;
elsif c_rec.dept = c then call_proc(emp_num,v_out)
if v_out = c1 then
return true;
end if;
end if;
end loop;
return false;
end;
=====================================================
I wonder if it works.

Thanks Todd,
Previous Topic: "Last Month's data" !!! Urgent Please help !!!
Next Topic: datafile
Goto Forum:
  


Current Time: Thu Mar 28 12:13:31 CDT 2024