I've this table: TAB_USERS with column USER (name last + first name)
Di Martino Giovanni
De Nicola Antonio
I'd like to write a query with only upper (first name).
I tried this query:
select UPPER(substr (USER, instr(USER, ' ')+1))
But I've some problem with the names: Di Martino Giovanni and De Nicola Antonio
How can I write my query also considering the names with two spaces?
I'd like to get this output: