Home » SQL & PL/SQL » SQL & PL/SQL » Return boolean checking condition in multiple records
Return boolean checking condition in multiple records [message #37810] Thu, 28 February 2002 13:40
epro
Messages: 11
Registered: January 2002
Junior Member
table: emp_rec (it did not allow me to put in table format.)
==============
EMP_NUM | 123 123 123
DEPT | ' A ' ' B ' ' C '
==============
if dept in (a,b) /* if this is true, stop process and return true,*/
return true
elsif dept = c,
then call_function('emp_num',v_out)
if v_out = c1, then return true; /*if this is true, stop process and return true,*/
==========
for all other cases return false;

=======
Tod, I guess this is clear, I tried my best. disregard
lower or upper case
========

Thanks
Previous Topic: How to select previous month's data
Next Topic: Re: Two tricky forms/SQL questions
Goto Forum:
  


Current Time: Thu Mar 28 05:43:57 CDT 2024