
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Please solve this oracle problem 1-3!

Transcribed Image Text:Oracle Assignment on Functions
You 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.
There 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 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.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps

Knowledge Booster
Similar questions
- 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…arrow_forwardWhat is the purpose of the Analytic Functions in Oracle with an examples of their usage.arrow_forwardWith 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 :]arrow_forward
- The course I'm taking is database management. I need help with part A please. I am using APEX Oracle compiler. Part A - Write a function to count the total number of employees in the employee table i have attached the employee table.arrow_forwardUse the concept of a one-way hash function to encrypt the following name into a 9 x 9 - dimensional database table. Jonathan Lee What would you do to remedy the problem of index congestion on your database? You must show all the steps of your work DONOT WRITE THE COMPUTER PROGRAMarrow_forwardObserve the HOMETOWN REALESTATE database: SELLER SellerID SellerName RealtorID S111 Paul R1 S222 Carly R1 S333 Ana R2 $444 Charlotte R2 S555 Aidan R3 Có66 Eric R1 C777 Christina R1 REALTOR RealtorID RealtorName R1 Claire R2 Kate R3 Cliff R4 William If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SELLER and REALTOR in the HOMETOWN REALESTATE database, what will be the outcome after a user tries to delete the last record (R4, William) from REALTOR? O SELLER will have 7 records, REALTOR wilIl have 4 records O SELLER will have 6 records, REALTOR will have 3 records O SELLER will have 7 records, REALTOR will have 3 records O SELLER will have 6 records, REALTOR wilIl have 4 records O SELLER will have 3 records, REALTOR willI have 3 recordsarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

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)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education