Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started