CHECK_EMAIL_UNIQUENESS

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: function
     2: check_email_uniqueness (
     3: 	email_in in varchar2
     4: )
     5: return number
     6: is
     7: 	cursor sources(email_cin in varchar2) is
     8: 		select	1
     9: 		from	web_user_personal_info	wupi
    10: 		where	wupi.email = email_cin;
    11: begin
    12: 	for source in sources(email_in)
    13: 	loop
    14: 		return 0;
    15: 	end loop;
    16: 	return 1;
    17: end;