Lab Exercise Consider the following emp table given below and perform the given below operations. Oracle 5Q Plus sOL) select from enp; EPHO ENAE JOn HGR MIREDATE SAL CO CLERK SALESHAN SALESHAH 7982...

Lab Exercise<br>Consider the following emp table given below and perform the given<br>below operations.<br>Oracle 5Q Plus<br>sOL) select from enp;<br>EPHO ENAE<br>JOn<br>HGR MIREDATE<br>SAL<br>CO<br>CLERK<br>SALESHAN<br>SALESHAH<br>7982 17-0EC-80<br>7698 20-FEB-81<br>7698 22-FEB-81<br>7839 2-APR-1<br>7698 28-SEP-81<br>7839 01-HAY-81<br>7839 09-JUH-81<br>7566 19-APR-87<br>17-HOV-81<br>7698 -SEP-81<br>7788 23-HAY-87<br>7698 03-DEC-81<br>7566 03-DEC-81<br>782 23-JAH-82<br>7369 SHITH<br>7499 ALLEN<br>7521 MARD<br>1600<br>1250<br>2975<br>1258<br>2850<br>2450<br>3000<br>300<br>500<br>7566 JONES<br>7654 HARTIN<br>HANAGER<br>7698 BLAKE<br>7782 CLARK<br>7788 SCOTT<br>7839 KING<br>78A TURNER<br>7876 ADAMS<br>7900 JAHES<br>7902 FORD<br>7934 HILLER<br>SALESHAN<br>PANAGER<br>HANAGER<br>ANALYST<br>PRESIDENT<br>SALESHAN<br>CLERK<br>CLERK<br>ANALYST<br>CLERK<br>1580<br>1180<br>950<br>3000<br>1300<br>rows selected.<br>SOL> I<br>4. Drop the COMM column<br>5. Rename the table as Employees.<br>6. Check that the SAL column value is between 500 and 10000<br>7. Delete all records from the table.<br>- For each step screenshot the SQL code you wrote + screenshot the<br>table showing the changes done.<br>- Upload your work to Blackboard as a PDF file.<br>

Extracted text: Lab Exercise Consider the following emp table given below and perform the given below operations. Oracle 5Q Plus sOL) select from enp; EPHO ENAE JOn HGR MIREDATE SAL CO CLERK SALESHAN SALESHAH 7982 17-0EC-80 7698 20-FEB-81 7698 22-FEB-81 7839 2-APR-1 7698 28-SEP-81 7839 01-HAY-81 7839 09-JUH-81 7566 19-APR-87 17-HOV-81 7698 -SEP-81 7788 23-HAY-87 7698 03-DEC-81 7566 03-DEC-81 782 23-JAH-82 7369 SHITH 7499 ALLEN 7521 MARD 1600 1250 2975 1258 2850 2450 3000 300 500 7566 JONES 7654 HARTIN HANAGER 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 78A TURNER 7876 ADAMS 7900 JAHES 7902 FORD 7934 HILLER SALESHAN PANAGER HANAGER ANALYST PRESIDENT SALESHAN CLERK CLERK ANALYST CLERK 1580 1180 950 3000 1300 rows selected. SOL> I 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.

Jun 03, 2022

SOLUTION.PDF

Lab Exercise Consider the following emp table given below and perform the given below operations. Oracle 5Q Plus sOL) select from enp; EPHO ENAE JOn HGR MIREDATE SAL CO CLERK SALESHAN SALESHAH 7982...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment