Lab Exercise Consider the following emp table given below and perform the given below operations. Oracle SQLPIus C ch g sQL select fron enp EP EHE JOB HER HIREDATE 7a69 SHI TH 792 17-DEC- 799 ALLEN 7521 MARD 7566 JOHES 769 22-FE- 739 2-APR- AGER SALESHAH GER GER ANALYST 765 ARTIN 7698 BLAKE 7782 CLARK 77 SCOTT 7839 KING 78 TURHER 7876 ADAHS PRESIDEHT SALESAH CLERK CLERK AAL VST CLERK 76 28-SEP-81 7839 1- Y- 7839 -JUN 7566 19-APR- 17-HOU 76 -SEP-1 7788 23- Y-7 769 -DEC-1 7566 -DEC-1 7782 23-JAN2 7900 JAE S 792 FORD 793 HILLER 1 rows selected. 1. Create the emp table and insert the date as showed in the picture. (EMPNO is PK) 2. Rename JOB column with Title. 3. Add a column and name it as Date of Birth 4. Drop the COMM column 5. Rename the table as Employees. 6. Check that the SAL column value is between 500 and 10000 7. Delete all records from the table. - For each step screenshot the SQL code you wrote + screenshot the table showing the changes done. Upload your work to Blackboard as a PDF file.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Solve this (SQL)

Lab Exercise
Consider the following emp table given below and perform the given
below operations.
* Oracle SQL Plus
SQL> select Fron enp:
EMPHD EHAHE
JOB
HGR HIREDATE
SAL
COHH
7369 SHITH
7499 ALLEH
7521 MARD
CLERK
SALESHAN
7902 17-DEC-80
7698 20-FEB-81
7698 22-FEB-81
1600
1250
300
500
SALESHAH
HAHAGER
7566 JONES
7H39 02-APR-81
2975
7654 HARTIN
SALESHAN
MANAGER
MAHAGER
AHALYST
7698 28-SEP-81
1258
7698 BLAKE
7782 CLARK
7788 SCOTT
7839 01-HAV-81
7839 09-JUH-81
2850
2450
3000
7566 19-APR-87
7839 KING
PRESIDENT
17-HOU-81
5000
78A TURNR
SALESHAN
7098 O8-SEP-1
1500
7876 ADAMS
7900 JAMES
7902 FORD
7934 HILLER
CLERK
CLERK
AHALYST
CLERK
7788 23-HAV-87
7698 03-DEC-81
7566 03-DEC-81
7782 23-JAH-82
1100
950
3000
1300
1% rows selected.
SQL> I
1. Create the emp table and insert the date as showed in the picture.
(EMPNO is PK)
2. Rename JOB column with Title.
3. Add a column and name it as Date of Birth
4. Drop the COMM column
5. Rename the table as Employees.
6. Check that the SAL column value is between 500 and 10000
7. Delete all records from the table.
- For each step screenshot the SQL code you wrote + screenshot the
table showing the changes done.
Upload your work to Blackboard as a PDF file.
Transcribed Image Text:Lab Exercise Consider the following emp table given below and perform the given below operations. * Oracle SQL Plus SQL> select Fron enp: EMPHD EHAHE JOB HGR HIREDATE SAL COHH 7369 SHITH 7499 ALLEH 7521 MARD CLERK SALESHAN 7902 17-DEC-80 7698 20-FEB-81 7698 22-FEB-81 1600 1250 300 500 SALESHAH HAHAGER 7566 JONES 7H39 02-APR-81 2975 7654 HARTIN SALESHAN MANAGER MAHAGER AHALYST 7698 28-SEP-81 1258 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 01-HAV-81 7839 09-JUH-81 2850 2450 3000 7566 19-APR-87 7839 KING PRESIDENT 17-HOU-81 5000 78A TURNR SALESHAN 7098 O8-SEP-1 1500 7876 ADAMS 7900 JAMES 7902 FORD 7934 HILLER CLERK CLERK AHALYST CLERK 7788 23-HAV-87 7698 03-DEC-81 7566 03-DEC-81 7782 23-JAH-82 1100 950 3000 1300 1% rows selected. SQL> I 1. Create the emp table and insert the date as showed in the picture. (EMPNO is PK) 2. Rename JOB column with Title. 3. Add a column and name it as Date of Birth 4. Drop the COMM column 5. Rename the table as Employees. 6. Check that the SAL column value is between 500 and 10000 7. Delete all records from the table. - For each step screenshot the SQL code you wrote + screenshot the table showing the changes done. Upload your work to Blackboard as a PDF file.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
SQL Functions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education