Need help starting from question 3! Oracle assignment on functionsYou 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 tables1. 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 Doeo Jones Mary should be flipped to Mary Jones• Adams-Costa/Susan Ann should be flipped to be Susan Ann Adams-Costao Langley/M Richard should be flipped to be M Richard Langley2. 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.

Answered: 3. Display a decimal number and then…

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

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

Related questions

Q: 10. When we find out that there are some miss spellings in the query?

A: Given: Where did we discover certain misspellings in the SQL query?

Q: How do you pronounce enhanced key? What does enhanced key mean?

A: An improved keyboard is a kind of keyboard that comes standard with virtually all modern PCs. It…

Q: Explain the difference between the this keyword and the super keyword. When should each be used?

A: The this keyword is used to access or call current class members(variables or methods or…

Q: CREATE PROCEDURE 'DISPLAY_OWNER' (INOUT I_OWNER_NUM varchar(10), OUT I_FIRST_NAME varchar(10),OUT…

A: Task-4 To Create a Procedure use Syntax- CREATE PROCEDURE procedure_name(parameter1 IN/OUT/INOUT…

Q: No plagarism please! Write your own answer. Correct and detailed answer will be Upvoted else…

A: Let’s take few data samples to work on this query . Here is customer table with some data . Our…

Q: Could you help me figure out the query for this task? The Car Maintenance team wants to pre-order…

A: Given : CARS(CAR_ID, CAR_PLATE, CAR_MODEL, CAR_YEAR)

Q: What’s the difference between an equality and a non-equality join?

A: The Equality-JOIN clause is a special keyword in a Structured Query Language (SQL), which is used to…

Q: How many distinct visit reasons start with the word "Pain"? Name the result column as NumPainReason.…

A: SELECT COUNT(DISTINCT VisitReason) AS NumPainReason FROM VisitWHERE VisitReason LIKE 'Pain%';

Q: how would I do this Return a list of all properties where service requests are made with different…

A: We must return the Service-request table, which contains requests for the same property with…

Q: Problem 7 Write a query to produce the total number of hours and charges for each of the projects…

A: Here you have simply used the ROUND(value,2) function. This will simply round the value to 2 places…

Q: The Driver Relationship team realized that there is no need for DRIVER_DRIVING_LICENSE_CHECKED field…

A: - The question is to delete the column DRIVER_DRIVING_LICENSE_CHECKED as there is no need of it. -…

Q: That is not the answer to the above question. Please create CKY tables for the question that was…

A: 0 1 2 3 0 S - - - 1 NP VP - - 2 - V - NP 3 - - Det Noun 4 - - a View S -> NP VP…

Q: Task 5: The marketing team wants to celebrate the success of StayWell with a party. The team wants a…

A: We need to write sql query for the given scenario.

Q: Test your foreign key constraint by adding a row to the owners table and then add a row to the dogs…

A: Example of work find the query below to insert CREATE TABLE Owners(Owner_name varchar(100) not null,…

Q: Think about the foreign-key constraint on the instructor's department name property. Please provide…

A: Infraction of the restriction on the use of foreign keys: When the primary key that is being used as…

Q: Write a SELECT statement that joins the Instructors and Courses tables and returns these columns:…

A: To accomplish this task, you can use a SQL SELECT statement that performs a LEFT JOIN between the…

Q: You need to return all travel data from the TRAVELS table for the CAR_ID which has a plate number…

A: Here, you need to join both the tables with same car_id whose car_plate is BB-883-***

Q: Natural join operation is denoted by symbol____. Select one: a. U. b. ρ. c. σ. d. ⨝.

A: Join is a blend of a Cartesian item with a choice interaction. It causes you to consolidate the…

Q: I Wrote down QUESTION 7 as shown above. Not Question 1.

A: According to the information given:- As mentioned you need the solution of question 7 for that we…

Q: SELECT CName, cPhoneNo FROM CUSTOMER WHERE CNo IN (SELECT CNo FROM BOOKING WHERE rNo IN (SELECT rNo…

A: Due to company policies I am compelled to solve only one part and that is the first part. Please…

Q: Using Salesforce Only: In this task you have to query on account in which you have to find the…

A: What is SOQL: Salesforce provides the Salesforce Object Query Language, or SOQL in short, that you…

Q: Which attribute may return NULL? %FOUND %ISOPEN %NOTFOUND %ROWCOUNT

A: %FOUND A cursor attribute that can be appended to the name of a cursor or cursor variable. Before…

Q: There are ten columns in the table "customer," yet there is no row. A total of 10 new rows are added…

A: TipA table is a list of connected data kept in a database in table format. A table in relational and…

Q: Can you provide me with the answers to the rest of the questions except Question 8, as shown in the…

A: In this question we have to provide some of the questions which are associated with Haskell…

Q: u please tell me how to make this query tru

A: here in this question you have given SQL command and ask to debug it, in the following section you…

Q: from the health board case study implementing physical design, i need the query for the question…

A: we have to write a sql statement.

Q: Can we use 'where' clause with 'GROUP BY' . If yes then how.

A: Question. Can we use 'where' clause with 'GROUP BY' . If yes then how.

Q: Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on…

A: SQL query to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF…

Q: Think about the foreign-key constraint on the instructor's department name property. Please provide…

A: The answer for the above mentioned question is given in the following steps for your reference.

Q: I need help on writing statements for these, I'm having trouble with the subqueries.

A: Here's the SELECT statement using a subquery with the IN keyword:SELECT DISTINCT LastName, FirstName…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: Queries are given below :

Q: How do you handle missing keys, chose 2:

A: In the python dictionaries, we can map keys to its value. It can be accessed with time complexity of…

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: Sure, I can help you with that. The StayWell marketing team wants to send small gifts to all…

Q: Given the following ERD, which of the following joins produce the same results. You can assume the…

A: Here, there are three relations named A, B, and C which are shown using the ERD. In this ERD,…

Q: Question 1 Use the "man" command to learn about the "who" command. In your own words, write a brief…

A: The question has been answered in step2

Q: Think about the foreign-key constraint on the instructor's department name property. Please provide…

A: The foreign key constraint specifies a column can contain only values exactly matching existing…

Q: The InstantRide received some traffic violation tickets from the government. The Legal team of…

A: LEFT JOIN is a type of join which returns all the contents(rows) from the left table and the…

Q: question 2 and 3 are not answered.!

A: Here, the task in your main question is to write a Python program implementing the investment…

Q: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing…

A: sql command for the question is given in step 2

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.

Expert Solution

Question 3 answer

decimal number-

Select To_Number(456.78) from dual;

round-

Select ROUND(15.188,1) "Round" From Dual;

Truncate-

Select TRUNC(15.79,1) "Truncate" From Dual;

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

Task 3: StayWell is offering a monthly discount for residents who pay their rent on a quarterly basis. The discount is 1.75 percent of the monthly fee. For each property, list the office number, address, owner number, owner’s last name, monthly rent, and discount as DISCOUNT. The discount should be rounded to the nearest dollar.
The 'customer' table contains ten columns but no row. The table is then updated with 10 new rows and 3 rows removed. What is the table 'customer's degree and cardinality?
The 'customer' table contains ten columns but no rows. The table is then updated with 10 new rows and 3 rows discarded. What is the table'customer's degree and cardinality?
How do we avoid getting duplicate entries in a query?
Kevin plans to use a Boolean operator to look for data on both of these topics. In order to get the desired search results, Kevin should use which Boolean operator.
Employees(employee_id, first_name, last_name, salary, hire_date, job_title, manager_id) Which of the following queries will display the last name of all employees who's managed by 'KING'? Select one: a.SELECT e.last_name FROM employees e, employees m WHERE upper(last_name) = 'KING' b.SELECT e.last_name FROM employees e, employees m WHERE e.manager_id = m.employee.id and upper(m.last_name) = 'KING' c.none of the above d.SELECT m.last_name FROM employees e, employees m WHERE e.manager_id = m.employee.id
Task 1: ' The Car Maintenance team wanted to ensure that the default price of the maintenance actions should not be empty and 0 instead if not specified. Alter the MAINTENANCE_TYPES table created in Chapter 8, Activity 1 to set the default MAINTENANCE_PRICE to 0. ANSWER IN MYSQL PLEASE
It's easy, Please try it Create a procedure that accepts a country_id as a parameter and displays the name of the country and its region name . Name your procedure get_country_info . Save your procedure definition for later use . • Call the procedure and take screen shoot of the output . You should use hr.countries and hr.regions tables
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
Task 6: The StayWell marketing team wants to send mail to all residents. You need to return the first name and surname of all the residents combined as NAME, with their addresses named ADDRESS. However, the address should be retrieved from the PROPERTY table for residents. Task Retrieve the mailing address (first name, surname, and address) for each resident. Task 7: The development team wants to add new residents and new service requests to StayWell without checking the latest IDs and manually incrementing it. Therefore, you need to alter the RESIDENTS table and change the RESIDENT_ID field to an auto-incremented field of type SMALLINT. Alter the RESIDENTS table and change the ID field to an auto-incremented field. Task 8: The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table. Task Add Yigit…
What did you take away from the process of creating your religion characteristics table?
StayWell’s maintenance team wants to recheck the apartments that had plumbing service requests beforehand. You will need to return all the property IDs and the addresses of the properties that had plumbing service request (CATEGORY_NUMBER 1). Task Return a list of all the property IDs and the addresses of the properties that had plumbing service requests.