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.
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.
Chapter8: Working With Advanced Functions
Section: Chapter Questions
Problem 2.7CP
Related questions
Question
Please solve this oracle problem 1-3!
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 now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
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
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr