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.

A Guide to SQL
A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter6: Updating Data
Section: Chapter Questions
Problem 12SCG
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
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
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:
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
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS