How do I get a substring from this example value: 

 john.abc_1234

I want it to return john.abc.So basically we need to remove all the information after _.

More examples: 1234_abc

sql oracle-database plsql oracle9i substr
Edit
Report