Oracle -在第n个字符出现之前获取所有字符

I am trying to get a query where I get all characters from a string before the 'n'the occurence of a character.I am trying to get a query where I get all char