Oracle - SQL - Trigger - Create or Replace Trigger
CREATEORREPLACETRIGGER trigger-name
BEFOREINSERTON table-name
FOR EACH ROWWHEN(NEW.field-name ISNULLORNEW.field-name ='<new>')BEGINSELECT'PR-'|| sequence-name.NEXTVAL INTO :NEW.field-name FROM DUAL;
END;