3. Display a decimal number and then display it rounded and truncated. Use a number where rounded and truncated will display different values.
3. Display a decimal number and then display it rounded and truncated. Use a number where rounded and truncated will display different values.
Chapter8: Working With Advanced Functions
Section: Chapter Questions
Problem 2.7CP
Related questions
Question
Need help starting from question 3!
![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
o Jones Mary should be flipped to Mary Jones
• Adams-Costa/Susan Ann should be flipped to be Susan Ann Adams-Costa
o 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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffbe1fbf5-3259-48c6-ac67-8bed9503746a%2Faa2b9a9b-90a7-45d8-932b-1ed4499d843d%2F73vypt_processed.png&w=3840&q=75)
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
o Jones Mary should be flipped to Mary Jones
• Adams-Costa/Susan Ann should be flipped to be Susan Ann Adams-Costa
o 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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr