I guess you are trying to view it in SQL*Plus. USER_TRIGGERS.TRIGGER_BODY is of type LONG and in SQL*Plus by default you see only first 80 characters from long datatype. If you want to see more, set the appropriately high number of SQL*Plus's set variable LONG:
SQL> SET LONG 1000000
SQL> SELECT trigger_body FROM user_triggers WHERE.....




Reply With Quote