Question: Write ONE SQL statement which uses the SUBSTR function (as many times as you need to) to extract the following three words: I, am, here
Write ONE SQL statement which uses the SUBSTR function (as many times as you need to) to extract the following three words: I, am, here from the string
Where am I? and put the three words together using a combination of the CONCAT function and the ||.
E.g. The starting string used in the SQL statement is: Where am I?
The output of the SQL statement after we run it will be:
TRANS
----------
I am here
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
