I have a query that can get the Nth word, second word (separated by spaces) 'Two'. How can I get the first character of the Nth word in my example I want the 'T' from the word 'Two' also to be returned
Select REGEXP_SUBSTR('one Two three four','\w+',1,2) wordN from dual
Expected output:
Two T