Question: 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)

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!