• Author / Uploaded
• Ezequiel Hernán Villanueva

Citation preview

Introduction to Oracle: SQL and PL/SQL, Instructor Guide, Volumen 1 Práctica 1: Escribiendo Sentencias SQL Básicas Ejercicio 1: Ejercicio 2:

FALSE.

Ejercicio 3:

TRUE.

Ejercicio 4:

TRUE.

Ejercicio 5:

Sentencia correcta:

SQL> select empno, ename, sal*12 as "Annual Salary" FROM emp; Ejercicio 6: SQL> describe emp; SQL> select * from emp; Ejercicio 7: SQL> describe emp; SQL> select ename as "EMPLOYEE NAME", job, hiredate, empno as "EMPLOYEE NUMBER" from emp; SQL> save p1q7.sql Ejercicio 8: SQL> start p1q7.sql Ejercicio 9: SQL> select distinct job from emp; Ejercicio 10: SQL> get p1q7.sql SQL> select ename as "Employee", job as "Job", hiredate as "Hire Date", empno as "Emp #" from emp; Ejercicio 11: SQL> select ename || ', ' || job as "Employee and Title" from emp; Ejercicio 12: SQL> select empno || ',' || ename || ',' || job || ',' || mgr || ',' || hiredate || ',' || sal || ',' || comm || ',' || deptno as "THE_OUTPUT" from emp;