SELECT employee_id, LOWER(last_name), department_id
FROM employees;
SELECT employee_id, last_name, department_id
FROM employees
WHERE LOWER(last_name) = 'higgins';
lunes, 31 de octubre de 2016
LOWER
La función de Oracle / PLSQL LOWER convierte todas las letras en la cadena especificada a minúsculas. Si hay caracteres en la cadena que no son letras, no se ven afectados por esta función.
SELECT employee_id, LOWER(last_name), department_id
FROM employees;
SELECT employee_id, last_name, department_id
FROM employees
WHERE LOWER(last_name) = 'higgins';
SELECT employee_id, LOWER(last_name), department_id
FROM employees;
SELECT employee_id, last_name, department_id
FROM employees
WHERE LOWER(last_name) = 'higgins';
0 comentarios:
Publicar un comentario