some plsql for matching donor info

donormatching.sql

select * from OPENQUERY(AIS_STAGE, '
	select * from
		(select UTL_MATCH.JARO_WINKLER_SIMILARITY(last_name || '','' || first_name, ''kirkland,scott'') NameDiff,last_name, first_name from entity
			order by NameDiff desc)
	where rownum < 10
')

select * from OPENQUERY(AIS_STAGE, '
	select email.email_address, telephone.telephone_number from entity
	join email on email.id_number = entity.id_number
	join telephone on telephone.id_number = entity.id_number
	where (email_address = ''youremail@ucdavis.edu'' or telephone_number = ''8675309'')
		and rownum < 10
')