SELECT 'Marco - Rossi' AS NOME_PASSATO, INSTR('Marco - Rossi','-') AS TROVA_CARATTERE, SUBSTR('Marco - Rossi',INSTR('Marco - Rossi','-')+1) AS RISULTATO FROM DUAL