Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

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
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
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS