Advertisement
Guest User

Untitled

a guest
Mar 21st, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION user_boolean (p_username IN VARCHAR2(20),p_password IN VARCHAR2(30))
  2. RETURN BOOLEAN
  3. IS
  4. v_count NUMBER;
  5. BEGIN
  6. SELECT Count(*) INTO v_count FROM existing_customer WHERE username = p_username AND password = p_password;
  7. RETURN (v_count > 0);
  8. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement