advanced code snippet search

Posted By

geekzspot on 10/30/12


Tagged


Versions (?)

"If Exists" PL/SQL Function

 / Published in: PL/SQL
 

Boolean "if exists" Function

Expand | Embed | Plain Text 
  1. CREATE OR REPLACE
  2. FUNCTION email_exists(email_in IN employees.email%TYPE) RETURN BOOLEAN IS
  3.     counter INTEGER;
  4. BEGIN
  5.     SELECT COUNT(*)
  6.       INTO counter
  7.       FROM employees 
  8.      WHERE email = email_in
  9.      AND ROWNUM <= 1; -- If exists at least one (1)
  10.  
  11.     RETURN ( counter > 0 ); -- Will return boolean True or False
  12.  
  13. END email_exists;

Report this snippet  

You need to login to post a comment.