I need to derive last 2 numbers after the '-' from the code column.
example if the code is 76767-99 then I need a query to return only 99. I am using substr and instr functions but not getting what I want. Please help me correct the below query.
code - 76767-99
select NVL (TRIM (SUBSTR (code, (INSTR (code, '_' ) ) + 1 ) ), '0' ) from temp_table;