Oracle SUBSTRING USING SPECIFIC CHARACTER

Just combine two function as follows.

Example:

SELECT SUBSTR('ABCD_EFG', 0, INSTR(TABLE_NAME, '_')-1) AS output
FROM dual

Result:
ABCD