Advanced Search

Record Exists function template

/ Published in: PL/SQL
Save to your folder(s)
I often need to know if a record exists in a table. This method is probably the most efficient. Too many people don't use the exceptions that Oracle provides, which is a shame.

I think I got it from Tom Kyte's site? Or Steven Feuerstein?

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. CREATE OR REPLACE FUNCTION person_exists(person_id IN VARCHAR2) RETURN BOOLEAN IS
  2.     l_count PLS_INTEGER;
  3. BEGIN
  4.     SELECT DISTINCT 1 
  5.       INTO l_count 
  6.       FROM people 
  7.      WHERE = person_id;
  8.  
  9.     RETURN TRUE;
  10. EXCEPTION
  11.     WHEN NO_DATA_FOUND THEN
  12.         RETURN FALSE;
  13.     WHEN TOO_MANY_ROWS THEN
  14.         RETURN TRUE;
  15. END person_exists;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.