Download - Respuestas Oracle PL-SQL Practica 2
-
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