Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

2. (3 points for code and screenshots of testing your code) Write a function f concatenate_strings that will do the same as concatenate_strings procedure from

image text in transcribed

2. (3 points for code and screenshots of testing your code) Write a function f concatenate_strings that will do the same as concatenate_strings procedure from #1, but can be called from a select statement. Examples of output SELECT f_concatenat trings(Crvpto. Currenc Will return Cryptocurrency Date: user: spe ltsv SELECT _concatenate strings('Crypto,"Currency' FRON DUAL: Script Output x 4 a Task completed n 0.007 seconds FUNCTION F CONCATENATESTRINGS compiled F. CONCATENATE-STRINGS (' CRYPTO CURRENCY' ) CryptoCurrecy Date: 06-JAN-18 user: speltsve SELECT f_concatenate_strings (ProductName, to_char (ListPrice, 999. 99')) from ProductTable WHERE ProductID-302; First, the table ProductTable, then product with ID 302 will be located. Product name of that t will be concatenated with the price and current date. Will return Wind-Up Water Swimmers user: spe ltsv PELECT E_concatenate strings (ProductNane, to char(ListPrice, '999.99')) fron Pro Script Output x Query...x SQL All Rows Fetched: 1in 0.012 seconds F-CONCATENATE-STRINGSPRODUCTNAME,TO_CHAR(LISTPRICE,'$999.997) 1 Wind-Up Water Swimmers 2.00 Date : 06-JAN-18 u3er: 3peltave Provide code and screenshot showing successful execution and resuits. You have to provide at least two test cases 2. (3 points for code and screenshots of testing your code) Write a function f concatenate_strings that will do the same as concatenate_strings procedure from #1, but can be called from a select statement. Examples of output SELECT f_concatenat trings(Crvpto. Currenc Will return Cryptocurrency Date: user: spe ltsv SELECT _concatenate strings('Crypto,"Currency' FRON DUAL: Script Output x 4 a Task completed n 0.007 seconds FUNCTION F CONCATENATESTRINGS compiled F. CONCATENATE-STRINGS (' CRYPTO CURRENCY' ) CryptoCurrecy Date: 06-JAN-18 user: speltsve SELECT f_concatenate_strings (ProductName, to_char (ListPrice, 999. 99')) from ProductTable WHERE ProductID-302; First, the table ProductTable, then product with ID 302 will be located. Product name of that t will be concatenated with the price and current date. Will return Wind-Up Water Swimmers user: spe ltsv PELECT E_concatenate strings (ProductNane, to char(ListPrice, '999.99')) fron Pro Script Output x Query...x SQL All Rows Fetched: 1in 0.012 seconds F-CONCATENATE-STRINGSPRODUCTNAME,TO_CHAR(LISTPRICE,'$999.997) 1 Wind-Up Water Swimmers 2.00 Date : 06-JAN-18 u3er: 3peltave Provide code and screenshot showing successful execution and resuits. You have to provide at least two test cases

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 11G SQL

Authors: Joan Casteel

2nd Edition

1133947360, 978-1133947363

More Books

Students explore these related Databases questions

Question

What are HR ethics?

Answered: 3 weeks ago