[DICA] Removing Special Characters - Java SP

[victorhugomuniz]

Selecionar tudo

--1
create or replace and compile java source named Utilities as
public class Utilities
{ 
  	public static String removingSpecialCharacters (String text) {
		
		return text.replaceAll("[ãâàáä]", "a")   
			    	.replaceAll("[êèéë]", "e")   
			    	.replaceAll("[îìíï]", "i")   
			    	.replaceAll("[õôòóö]", "o")   
			    	.replaceAll("[ûúùü]", "u")   
			    	.replaceAll("[ÃÂÀÁÄ]", "A")   
			    	.replaceAll("[ÊÈÉË]", "E")   
			    	.replaceAll("[ÎÌÍÏ]", "I")   
			    	.replaceAll("[ÕÔÒÓÖ]", "O")   
			    	.replaceAll("[ÛÙÚÜ]", "U")   
			    	.replace('ç', 'c')   
			    	.replace('Ç', 'C')   
			    	.replace('não', 'n')   
			    	.replace('não', 'N');											
	}
}

--2
create or replace function removeSpecialChar(p1 IN VARCHAR2) return varchar2 AS
LANGUAGE JAVA NAME 'Utilities.removingSpecialCharacters(java.lang.String) return
java.lang.String';

--3
select removeSpecialChar('áãâÀisudãeãeíoioóoíoáeáeáeãééééãaééãeçççépepfnvççvç') from dual;