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

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!