TALLER 3
PUNTO 1:
CONSULTA: select TO_CHAR(SYSDATE,'DD/MON/YYYY') from DUAL;
RESULTADO:
PUNTO 2 y 3:
CONSULTA: SELECT EMPLOYEE_ID,LAST_NAME,SALARY,(SALARY*0.155)+SALARY AS "New Salary"
FROM EMPLOYEES;
RESULTADO:
PUNTO 4:
CONSULTA: SELECT EMPLOYEE_ID,LAST_NAME,SALARY,(SALARY*0.155)+SALARY AS "New Salary",
(SALARY*0.155) AS "Increase" FROM EMPLOYEES;
RESULTADO:
PUNTO 5:
CONSULTA: SELECT last_name, LENGTH(last_name) FROM employees WHERE LAST_NAME LIKE
'A_%' OR LAST_NAME LIKE 'J_%' OR LAST_NAME LIKE 'M_%';
RESULTADO:
PUNTO 5:
CONSULTA: SELECT last_name, LENGTH(last_name) FROM employees WHERE LAST_NAME LIKE
'A_%' OR LAST_NAME LIKE 'J_%' OR LAST_NAME LIKE 'M_%';
RESULTADO:
CONSULTA: SELECT last_name, LENGTH(last_name) FROM employees WHERE /*LAST_NAME LIKE
'A_%' OR LAST_NAME LIKE 'J_%' OR LAST_NAME LIKE 'M_%' AND*/last_name LIKE ('&last_name_
%');
RESULTADO:
CONSULTA: SELECT last_name, LENGTH(last_name) FROM employees WHERE /*LAST_NAME LIKE
'A_%' OR LAST_NAME LIKE 'J_%' OR LAST_NAME LIKE 'M_%' AND*/last_name LIKE
UPPER('&last_name_%');
RESULTADO:
PUNTO 6:
CONSULTA: SELECT last_name,ROUND(MONTHS_BETWEEN(SYSDATE,HIRE_DATE)) AS meses
FROM employees ORDER BY meses ;
RESULTADO:
PUNTO 7:
CONSULTA: SELECT last_name,LPAD(salary,15,'$') AS salary FROM EMPLOYEES;
RESULTADO:
PUNTO 8:
CONSULTA: SELECT substr(last_name,1,8) || ' ' || RPAD('*',TRUNC(salary/1000),'*') AS
employees_and_teheir_salaries FROM EMPLOYEES ORDER BY salary desc ;
RESULTADO:
PUNTO 9:
CONSULTA: SELECT last_name , TRUNC(MONTHS_BETWEEN(sysdate,hire_date)*4) AS tenure
FROM employees WHERE DEPARTMENT_ID = '90' ORDER BY TENURE DESC;
RESULTADO:
