Write an SQL query to display a text string yourfirstname yo

Write an SQL query to display a text string \'your_first_name your_last_name\' that represents your full name using the DUAL table.

Modify the query you created in problem 1. This time, use the INITCAP function to convert characters in the text string \'your_first_name your_last_name\' to mixed case.

Modify the query you created in problem 1. This time, use the INSTR function to determine the position of the single blank space in the text string \'your_first_name your_last_name\'.

Solution

select \'john hill\' from DUAL

select INITCAP(\'john hill\') from DUAL

select INSTR(\'john hill\',\' \') from DUAL