Oracle assignment on functions u should write a script to get the emp table file and the ones related to it that can be found by searching on the web. I actually gave you the emp script to run in a previous week. ere are four tables that Oracle used: emp, dept, bonus and salgrade. They are available in many places on the web. One site is: Set of Oracle tables 1. Do a query using single row functions that flip the name so that it reads first middle (if any) last instead of last first middle. For example: • Doe John M should be flipped to be John M Doe • Jones Mary should be flipped to Mary Jones • Adams-Costa Susan Ann should be flipped to be Susan Ann Adams-Costa • Langley/M Richard should be flipped to be M Richard Langley 2. Display a number, the number squared, the number cubed and the square root of the number. 3. Display a decimal number and then display it rounded and truncated. Use a number where rounded and truncated will display different values.

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…

What is the purpose of the Analytic Functions in Oracle with an examples of their usage.

With the advent of RAID storage devices, is it still necessary to backup an Oracle database? Please be as detailed as possible and type out in text, as handwriting is often difficult to read. Thank you for your time in advance :]