Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
What output would be produced SQL> select empno, ename, deptno, sal, job 2 from emp 3 where deptno in (select deptno from dept where dname in ('RESEARCH','SALES'))i Nlm 56

What output would be produced SQL> select empno, ename, deptno, sal, job 2 from emp 3 where deptno in (select deptno from dept where dname in ('RESEARCH','SALES'))i Nlm 56

Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 5HOA: Access path A database table is composed of records and fields hold data. Data is stored in records....
See similar textbooks
icon
Related questions
Question

Solve if can

EMPNO ENAME JOB MGR HIREDATE SAL COMM Problem 2: Determine the output. ---------- DEPTNO ---------- SQL> desc emp 7902 FORD ANALYST 7566 03-DEC-81 3000 20 Name Null? Туре ------ -------- ------- EMPNO NOT NULL NUMBER (4: 7934 MILLER CLERK 7782 23-JAN-82 1300 10 ENAME VARCHAR2 (10) JOB VARCHAR2 (9) NUMBER (4) DATE NUMBER 17,2) NUMBER (7,2) NUMBER (2) MGR SQL> select • from depti HIREDATE SAL DEPTNO DNAME LOC COMM ---------- -------------- ---- DEPTNO 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS SQL> select • from sapi 30 SALES CHICAGO 40 OFERATIONS BOSTON EMPNO ENAME -------- --- JOB MGR HIREDATE SAL COMM SQL> desc depti DEPTNO Name Null? Type -------- ----- NOT NULL NUMBER (2) VARCHAR2 (14; ---------- ------- 7369 SMITH CLERK 7902 17-DEC-B0 B00 DEPTNO 20 DNAME LOC 7499 ALLEN 30 SALESMAN 7698 20-FEB-81 VARCHAR2 (13) 1600 300 What output would be produced 7521 WARD SALESMAN 7698 22-FЕВ-В1 1250 500 30 SQL> select empno, ename, deptno, sal, job www 2 from emp 3 where deptno in 4 (select deptno EMPNO ENAME JOB MGR HIREDATE SAL COMM ---------- DEPTNO ---------- from dept where dname in ('RESEARCH', 'SALES')); 7566 JONES MANAGER 7839 02-APR-81 2975 20 6. 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 7698 BLAKE MANAGER 7839 01-MAY-81 2850 10 EMPNO ENAME JOB MGR HIREDATE SAL COMM ---------- ---------- DEPTNO ---------- 7782 CLARK MANAGER 7839 09-JUL-81 2450 10 7788 3COTT ANALYST 7566 19-APR-87 3000 20 7839 KING PRESIDENT 17-NOV-B1 5000 10 EMPNO ENAME ---------- -- JOB MGR HIREDATE SAL COMM DEPTNO ---------- 7844 TURNER SALESMAN 7698 08-3ЕР-В1 1500 30 7876 ADAMS CLERK 7788 23-MAY-87 1100 20 7900 JAMES CLERK 7698 03-DEC-81 950 30
Transcribed Image Text:EMPNO ENAME JOB MGR HIREDATE SAL COMM Problem 2: Determine the output. ---------- DEPTNO ---------- SQL> desc emp 7902 FORD ANALYST 7566 03-DEC-81 3000 20 Name Null? Туре ------ -------- ------- EMPNO NOT NULL NUMBER (4: 7934 MILLER CLERK 7782 23-JAN-82 1300 10 ENAME VARCHAR2 (10) JOB VARCHAR2 (9) NUMBER (4) DATE NUMBER 17,2) NUMBER (7,2) NUMBER (2) MGR SQL> select • from depti HIREDATE SAL DEPTNO DNAME LOC COMM ---------- -------------- ---- DEPTNO 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS SQL> select • from sapi 30 SALES CHICAGO 40 OFERATIONS BOSTON EMPNO ENAME -------- --- JOB MGR HIREDATE SAL COMM SQL> desc depti DEPTNO Name Null? Type -------- ----- NOT NULL NUMBER (2) VARCHAR2 (14; ---------- ------- 7369 SMITH CLERK 7902 17-DEC-B0 B00 DEPTNO 20 DNAME LOC 7499 ALLEN 30 SALESMAN 7698 20-FEB-81 VARCHAR2 (13) 1600 300 What output would be produced 7521 WARD SALESMAN 7698 22-FЕВ-В1 1250 500 30 SQL> select empno, ename, deptno, sal, job www 2 from emp 3 where deptno in 4 (select deptno EMPNO ENAME JOB MGR HIREDATE SAL COMM ---------- DEPTNO ---------- from dept where dname in ('RESEARCH', 'SALES')); 7566 JONES MANAGER 7839 02-APR-81 2975 20 6. 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 7698 BLAKE MANAGER 7839 01-MAY-81 2850 10 EMPNO ENAME JOB MGR HIREDATE SAL COMM ---------- ---------- DEPTNO ---------- 7782 CLARK MANAGER 7839 09-JUL-81 2450 10 7788 3COTT ANALYST 7566 19-APR-87 3000 20 7839 KING PRESIDENT 17-NOV-B1 5000 10 EMPNO ENAME ---------- -- JOB MGR HIREDATE SAL COMM DEPTNO ---------- 7844 TURNER SALESMAN 7698 08-3ЕР-В1 1500 30 7876 ADAMS CLERK 7788 23-MAY-87 1100 20 7900 JAMES CLERK 7698 03-DEC-81 950 30
Expert Solution
steps

Step by step

Solved in 5 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS