SQL - UPPER en una consulta a Oracle

select upper('casa') from dual;

"  select"

	+ " TP.PROVEEDOR_ID,"

	+ " NVL(TP.PROVEEDOR_NOMBRE,' '), "

	+ " NVL(TP.PROVEEDOR_RAZON_SOCIAL,' '),"

	+ " NVL(TP.PROVEEDOR_RFC,' '),"

	+ " NVL(TP.PROVEEDOR_DOMICILIO,' '),"

	+ " NVL(TP.PROVEEDOR_COLONIA,' '),"

	+ " NVL(TP.PROVEEDOR_CP,' '),"

	+ " NVL(TP.PROVEEDOR_CIUDAD,' '),"

	+ " NVL(TP.PROVEEDOR_ESTADO,' '),"

	+ " NVL(TP.PROVEEDOR_PAIS,' '),"

	+ " NVL(TP.PROVEEDOR_CONTACTO,' '),"

	+ " NVL(TP.PROVEEDOR_PUESTO,' '),"

	+ " NVL(TP.PROVEEDOR_EMAIL,' '),"

	+ " NVL(TP.PROVEEDOR_TELEFONO,' '),"

	+ " NVL(TP.PROVEEDOR_MOVIL,' '),"

	+ " NVL(TP.PROVEEDOR_WEB,' '),"

	+ " NVL(TTG.GIRO_DESCRIPCION,' '),"

	+ " NVL(TTG.GIRO_ID, 0 )"

	+ " from tra_proveedores tp "

	+ " inner JOIN TRA_TIPO_GIRO ttg "

	+ " on tp.GIRO_ID=ttg.GIRO_ID "

	+ " WHERE TP.PROVEEDOR_ID='" + idd + "'";