SELECT employee_id, INITCAP (last_name), department_id
FROM employees;
SELECT employee_id, last_name, department_id
FROM employees
WHERE INITCAP (last_name) = 'higgins';
lunes, 31 de octubre de 2016
INITCAP
La función de Oracle INITCAP establece el primer carácter de cada palabra en mayúscula y el resto en minúsculas.
SELECT employee_id, INITCAP (last_name), department_id
FROM employees;
SELECT employee_id, last_name, department_id
FROM employees
WHERE INITCAP (last_name) = 'higgins';
SELECT employee_id, INITCAP (last_name), department_id
FROM employees;
SELECT employee_id, last_name, department_id
FROM employees
WHERE INITCAP (last_name) = 'higgins';
0 comentarios:
Publicar un comentario