are there any ways to reverse engineer Oracle trigger or sort of decompile it?

Question

Are there any way to decompile or reverse engineer Oracle trigger? Any tools available, any free ones?

Thanks!

Answer 1

This may be done querying user_triggers or dba_triggers as such:

SELECT trigger_body FROM user_triggers where trigger_name = 'THENAME';

or

SELECT DBMS_METADATA.GET_DDL('TRIGGER','....') FROM DUAL

If the trigger code calls other code that is Wrapped (obsufacted) you will need to unwrap it, see this article or do a google search for "oracle unwrap pl/sql"

You can also use a Oracle managment or development tool to get the trigger source code.