Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION user_boolean (p_username IN VARCHAR2(20),p_password IN VARCHAR2(30))
- RETURN BOOLEAN
- IS
- v_count NUMBER;
- BEGIN
- SELECT Count(*) INTO v_count FROM existing_customer WHERE username = p_username AND password = p_password;
- RETURN (v_count > 0);
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement