8/8/2019 Respuestas Oracle PL-SQL Practica 2

1/2

Introduction to Oracle: SQL and PL/SQL, Instructor Guide, Volumen 1

Prctica 2: Restringiendo y Ordenando los Datos--------------------------------------------------------------------

Ejercicio 1:

SQL> SELECT ENAME, SAL FROM EMP WHERE SAL > 2850;

SQL> save p2q1.sql

SQL> start p2q1.sql

Ejercicio 2:

SQL> SELECT ENAME, DEPTNO FROM EMP WHERE EMPNO = 7566;

Ejercicio 3:

SQL> SELECT ENAME, SAL FROM EMP WHERE SAL NOT BETWEEN 1500 AND 2850;SQL> save p2q3.sql

SQL> start p2q3.sql

Ejercicio 4:

SQL> SELECT ENAME, JOB, HIREDATE FROM EMP WHERE HIREDATE BETWEEN '20-FEB-1981' AND '01-MAY-1981' ORDER BY HIREDATE;

Ejercicio 5:

SQL> SELECT ENAME, DEPTNO FROM EMP WHERE DEPTNO IN (10, 30) ORDER BY ENAME;

Ejercicio 6:

SQL> SELECT ENAME AS "Employee", SAL AS "Monthly Salary" FROM EMP WHERESAL > 1500 AND ( DEPTNO = 10 OR DEPTNO = 30 );

SQL> save p2q6.sql

SQL> start p2q6.sql

Ejercicio 7:SQL> SELECT ENAME, HIREDATE FROM EMP WHERE HIREDATE BETWEEN '01-JAN-1982

' AND '31-12-1982';

Ejercicio 8:

SQL> SELECT ENAME, JOB FROM EMP WHERE MGR IS NULL;

Ejercicio 9:

SQL> SELECT ENAME, SAL, COMM FROM EMP WHERE COMM IS NOT NULL ORDER BY SAL DESC, COMM DESC;

Ejercicio 10:

8/8/2019 Respuestas Oracle PL-SQL Practica 2

2/2

SQL> SELECT ENAME FROM EMP WHERE ENAME LIKE '__A%';

Ejercicio 11:

SQL> SELECT ENAME FROM EMP WHERE ENAME LIKE '%LL%' AND ( DEPTNO = 30 ORMGR = 7782 );

Ejercicio 12:

SQL> SELECT ENAME, JOB, SAL FROM EMP WHERE ( JOB LIKE 'CLERK' OR JOB LIKE 'ANALYST' ) AND SAL NOT IN ( 1000, 3000, 5000 );

Ejercicio 13:

SQL> SELECT ENAME AS "Employee", SAL AS "Monthly Salary", COMM AS "Commission %" FROM EMP WHERE COMM > SAL*1.10;

SQL> save p2q13.sql

SQL> start p2q13.sql