# BI_GL_SCHEMA_CHANGES

## Informazioni

- **Tabella**: GL_SCHEMA_CHANGES
- **Evento**: INSERT
- **Tipo**: BEFORE EACH ROW
- **Stato**: ENABLED

## Codice Sorgente

```sql
TRIGGER "APOLLINARECATERINGPROD"."BI_GL_SCHEMA_CHANGES" 
before insert on gl_schema_changes
for each row
BEGIN
	select gl_schema_changes_seq.nextval into :new.id from dual;
	:NEW.VERSION_NAME := :NEW.VYEAR||'.'||:NEW.VMONTH||'.'||:NEW.VMAJOR||'.'||:NEW.VMINOR||:NEW.VTYPE;
end;

```