Sql2005

/*Inicial Mayuscula*/
select INITCAP(LAST_NAME)||'- '||INITCAP(FIRST_NAME) As Nombre
FROM EMPLOYEES
WHERE department_id = 80;

/*Todo en mayuscula*/
select UPPER(LAST_NAME)||'-'||UPPER(FIRST_NAME) As Nombre
FROM EMPLOYEES
WHERE department_id = 80;

/*Todo en minuscula*/
select LOWER(LAST_NAME)||'- '||LOWER(FIRST_NAME) As Nombre
FROM EMPLOYEES
WHERE department_id = 80;/*Conmparacion transformando todo a mayusculas*/
select UPPER(LAST_NAME)||'- '||UPPER(FIRST_NAME) As Nombre
FROM EMPLOYEES
WHERE LOWER(FIRST_NAME) = LOWER('DAVID');

/*Concatenacion*/
selectUPPER(LAST_NAME)||'- '||INITCAP(FIRST_NAME) As Nombre,LOWER(EMAIL)||'@oracle.com' as correo, email
FROM EMPLOYEES
WHERE UPPER(FIRST_NAME) = UPPER('DAVID');

/*Concatenacion2*/
SELECT concat(LAST_NAME,FIRST_NAME)
from EMPLOYEES
where UPPER(FIRST_NAME) = UPPER('DAVID');

/*SubStrings*/
SELECT concat(LAST_NAME, FIRST_NAME),
substr(hire_date, 7, 2) || '@oracle.com' As Mail
from EMPLOYEES
whereUPPER(FIRST_NAME) = UPPER('DAVID');

/*Buscar poscicion de una String*/
SELECT concat(LAST_NAME, FIRST_NAME),
substr(hire_date, 7, 2) as Fecha, HIRE_DATE|| '@oracle.com' As Mail,
INSTR(LAST_NAME, 'n')as numero
from EMPLOYEES
where UPPER(FIRST_NAME) = UPPER('DAVID');

/*LPAD & RPAD*/
SELECT concat(LAST_NAME, FIRST_NAME),
substr(hire_date, 7, 2) as Fecha, HIRE_DATE|| '@oracle.com' As Mail,INSTR(LAST_NAME, 'n') as numero,
LPAD(SALARY, 5, '$') As SUELDO,
RPAD(SALARY, 5, '$') As Sueldo2
from EMPLOYEES
where UPPER(FIRST_NAME) = UPPER('DAVID');
/*Reemplazar una String*/
SELECTconcat(LAST_NAME, FIRST_NAME),
substr(hire_date, 7, 2) as Fecha, HIRE_DATE|| '@oracle.com' As Mail,
INSTR(LAST_NAME, 'n') as numero,
LPAD(SALARY, 5, '$') As SUELDO,
RPAD(SALARY, 5, '$') As Sueldo2,replace(FIRST_NAME, 'A', 'P') As Reemplazo
from EMPLOYEES
where UPPER(FIRST_NAME) = UPPER('DAVID');

/*TRIM(Extrae una letra)*/
SELECT concat(LAST_NAME, FIRST_NAME),
substr(hire_date, 7, 2) as...