Exemplo para se criar uma Trigger

create or replace trigger
before insert or update
on

for each row
declare

begin

exception

end ;
/

create or replace trigger TRG_BI_TTCPJ
before insert on TTCPJ
for each row
begin
select SEQ_TTCPJ into :NEW.CODIGO from dual;
end;
/