Funciones de Cadena ORACLE

--funciones de cadena
select upper(ape || ' ' || nom)as nombres from tbemple;
select concat(ape || ' ',nom)as nombres from tbemple;
SELECT SUBSTR('PEPE PEREZ', 6) FROM DUAL;
SELECT SUBSTR('PEPE PEREZ',6,2) FROM DUAL;
select initcap('buenas tardes alumno') from dual;
select upper(nom) from tbemple;
select lower(nom) from tbemple;
select initcap(ape) from tbemple;
select substr(nom,1,4) from tbemple
select concat('Jhonatan',' Abal') from Dual;
select chr(65) from dual;
select lpad('alumno',8,'wa') from dual
select lpad('alumno',4,'xyz') from dual;
select trim(' hola a todos ')from dual;
select rpad('alumno',11,'xyz') from dual;
select rtrim('la casa lila','la') from dual;-- 'la casa li'
select rtrim('la casa lila ','la') from dual;-- no borra ningún caracter
select rtrim('la casa lila    ') from dual; --'la casa lila'
select ltrim('        hola') from dual;
select rtrim('hola        ') from dual;
select translate('JORGE LUIS BORGES','OSG','056') from dual;
select trim(' hola  ')from dual;
select replace('xxx.oracle.com','x','w') from dual;
select replace('juanita@hsr.gob.pe','hsr.gob.pe','uap.edu.pe') from dual;
select length('hola')from dual;
select length('hola a todos')from dual;

--By Ing. Jhonatan Abal Mejia