1. Create the table you will need for this problem set by running this SQL command...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Create the table you will need for this problem set by running this SQL command in the APEX SQL command window: create table euro data as(select * from WKSP_ORAGARRITAT01.euro_data); This will create a table in your schema that you can use. Examine the data in the table to using the SQL command: Select from euro data; Run in the SQL command window. 2. Create a function in PL/SQL that will use the column euro amnt from the euro data table. The function will do this: • Take the euro symbol from the currency. • Change the comma in the data to a period, to make it more like US dollars. . Convert the euros to American dollar amounts. Use 1 euro = 1.05 dollars. Create a variable named v rate to store the 1.05 exchange value. So the return value is the amount of money that the euros are worth in American dollars. Do not have the function show the money amount in dollars, just return it as a number. This function can be created quickly using the system functions REPLACE, SUBSTR, etc. nested inside of each other. ID FIRST_NAME LAST_NAME EURO AMNT PHONE 488 Chrissy Trumper €451,84 5677608544 489 Prentice Jayume €463,84 490 Godwin Click €810,95 491 Antone Goldfinch 492 Veriee Hedman 493 Putnam Renzullo 494 Shawnee thompsjc01@mail.buffalostate.edu wksp_thompsjc01 en 3131645829 1021518269 €536,39 9524100161 €411,26 8549260695 €407,95 6465085866 Runcieman €846,67 5915200039 Copyright © 1999, 2022, Oracle and/or its affiliates. Oracle APEX 22.2.4 1. Create the table you will need for this problem set by running this SQL command in the APEX SQL command window: create table euro data as(select * from WKSP_ORAGARRITAT01.euro_data); This will create a table in your schema that you can use. Examine the data in the table to using the SQL command: Select from euro data; Run in the SQL command window. 2. Create a function in PL/SQL that will use the column euro amnt from the euro data table. The function will do this: • Take the euro symbol from the currency. • Change the comma in the data to a period, to make it more like US dollars. . Convert the euros to American dollar amounts. Use 1 euro = 1.05 dollars. Create a variable named v rate to store the 1.05 exchange value. So the return value is the amount of money that the euros are worth in American dollars. Do not have the function show the money amount in dollars, just return it as a number. This function can be created quickly using the system functions REPLACE, SUBSTR, etc. nested inside of each other. ID FIRST_NAME LAST_NAME EURO AMNT PHONE 488 Chrissy Trumper €451,84 5677608544 489 Prentice Jayume €463,84 490 Godwin Click €810,95 491 Antone Goldfinch 492 Veriee Hedman 493 Putnam Renzullo 494 Shawnee thompsjc01@mail.buffalostate.edu wksp_thompsjc01 en 3131645829 1021518269 €536,39 9524100161 €411,26 8549260695 €407,95 6465085866 Runcieman €846,67 5915200039 Copyright © 1999, 2022, Oracle and/or its affiliates. Oracle APEX 22.2.4
Expert Answer:
Related Book For
Cornerstones of Financial and Managerial Accounting
ISBN: 978-1111879044
2nd edition
Authors: Rich, Jeff Jones, Dan Heitger, Maryanne Mowen, Don Hansen
Posted Date:
Students also viewed these finance questions
-
A continuacin se presenta el estado de situacin financiera ms reciente de Country Kettles, Inc. Excluyendo la depreciacin acumulada, determine si cada partida es un origen o una aplicacin del...
-
TASK You are to create a forum website based on the descriptions below, that allows users to sign up and create topics and posts on those topics. SET-UP Create a folder on...
-
Youve just been hired onto ABC Company as the corporate controller. ABC Company is a manufacturing firm that specializes in making cedar roofing and siding shingles. The company currently has annual...
-
List all types of bonding present in the compound CaCO3. List all types of bonding present in the compound CaCO3. I. ionic bond II. polar covalent bond III. nonpolar covalent bond A. I only B. II...
-
A new high school special education teacher wonders if there really is a correlation between reading disabilities and attention disorders. She collects data from six of her students on their reading...
-
Glare Reduction The light that reaches a person's eyes is a combination of 625 W/m2 of unpolarized light and 282 W/m2 of horizontally polarized light. The person puts on sunglasses that are ideal...
-
Phil Rammers is confused about the source documents used in assigning materials and labor costs. Identify the documents and give the entry for each document.
-
On November 1, 2019, the account balances of Schilling Equipment Repair were as follows. During November, the following summary transactions were completed. Nov. 8 Paid $1,700 for salaries due...
-
TASK 1: Pinang Berhad is a company that carries out a diverse range of activities. It is proud of its reputation as a 'caring' organisation and has adopted various ethical policies towards its...
-
New Endor Airlines Database New Endor Airlines (NEA) is the premier aviation service in the small island nation of New Endor, located in the southwestern Pacific Ocean. For the 40 years since its...
-
We can find the margin of error, E, from the lower bound of a confidence interval, L, and the upper bound U-L of a confidence interval, U, using the formula E . If the lower bound is 0.123 and the...
-
The function f ( x ) = x 5 - 5 x 5 - 1 has inflection points at two values of x . Find the nonzero value value of x where an inflection point occurs. Round your answer to two decimal places, if...
-
UW Mobile wishes to erect a number of cell towers within the UW campus. For each cell tower, the coverage radius R of the tower (in meters) is directly proportional to the height h of the tower (in...
-
The local school district was planning to build a new high school. The estimated cost of the building was around $100M. To finance the building the school district needed to issue a bond for about...
-
Consider a dataset with data points each having 3 features, e.g., x 1 = { "Atlanta" , "house" , 500 k} , and x 2 = { "Houston" , "house" , 300 k} . Define a proper similarity function d ( x i , xj )...
-
Suppose that the school district had entered the swap in January 2007. Now it is January 2008 and interest rates have fallen to 0% and are expected to remain at 0% for the next 10 years. The school...
-
Fiscal Year 3 Fiscal Year 2 Net income $140,300 $72,300 Interest expense 2,900 10,800 Fiscal Year 3 Fiscal Year 2 Fiscal Year 1 Total assets (at end of fiscal year) $3,862,632 $3,674,210 Total...
-
Juarez worked for Westarz Homes at construction sites for five years. Bever was a superintendent at construction sites, supervising subcontractors and moving trash from sites to landfills. He...
-
Hawk Skateboards is considering building a new plant. Robert Optimist, the company's marketing manager, is an enthusiastic supporter of the new plant. Roberta Wunder land, the company's chief...
-
Bolus Company is considering the purchase of a new machine. The invoice price of the machine is \($112,000\), freight charges are estimated to be \($3,000\), and installation costs are expected to be...
-
Lafluer Corp. is thinking about opening a soccer camp in southern California. In order to start the camp, the company would need to purchase land, and build four soccer fields and a dormitory-type...
Study smarter with the SolutionInn App