Question: C Gel Homework Help With Cheyo x C Lab Exercise Consider The Follow - 13 B Bb Exe4.pdf + @e Ims.uj.edu.sa/bbcswebdav/pid-1268603-dt-content-rid-8385859_1/courses/202102 CCCS215_T13_18696_EL/Exe.4.pdf Apps M Gmail
C Gel Homework Help With Cheyo x C Lab Exercise Consider The Follow - 13 B Bb Exe4.pdf + @e Ims.uj.edu.sa/bbcswebdav/pid-1268603-dt-content-rid-8385859_1/courses/202102 CCCS215_T13_18696_EL/Exe.4.pdf Apps M Gmail O YouTube Maps Translate News = Exe.4.pdf 1/11 110% + O + Oracle SQL Plus SAI cort SUL> select from emp: EMPENAH JOR Y SHH 7309 SHITH CLER 7599 ALLEN SALESMAN 7521 MRD SALESMAN 7566 JOHES HAGER 765 PRTIH SALESMAN MANAGER 7608 BLAKE 772 BLANK HEEE 7700 SCOTT AMALTST 7-99 NINE PRESIDENT 78 TURHER SALESMAN 7876 ADAMS 7900 JAMES CLERK 7962 FORD ANALYST 7934 HILLER CLERK 16 Pous selected SQL> 1 HER HIREDATE -- 792 17-00-00 7690 20 FEB 1 7698 29-FER-81 7839 02-APR-81 799- 20-SEP-81 739 61-MAY-81 783 -1 7566 19 APR 27 17-NOU-21 7698 18-SEP-81 7768 23-HAY-87 769R 0-DEC-21 7566 -DEC-81 7782 23-JAH-52 2279 2952 25 3004 1500 1100 ELEM an 130 1 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. I Type here to search O a 2 A la (0 ENG 19:38 INTI 27/02/2021 31 Lab Exercise Consider the following emp table given below and perform the given below operations. HH Il Lilll!! HO 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
