Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Please solve this oracle problem 1-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 - 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.
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS