Files
2024-05-13 12:54:14 +02:00

9 lines
914 B
MySQL

INSERT INTO DBCGO_ANAGRAFICA_OPERATORI ( ID_OPERATORE, TIPO_OPERATORE, GESTORE_AOM, INIZIALE_ID_AMM, ID_AMMINISTRATIVO, DESCRIZIONE )
VALUES ( 'OPTM', 'VIRT', 'OPIV', 'O', 'O112', 'OPTIMA ITALIA');
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR, ORDER_BY) VALUES (SEQ_LOV.nextval, 'AOM', 'OPTM','OPTIMA ITALIA', null);
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR, ORDER_BY) VALUES (SEQ_LOV.nextval, 'AOM_DONOR', 'OPTM','OPTIMA ITALIA', null);
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR, ORDER_BY) VALUES (SEQ_LOV.nextval, 'AOM_RECIPIENT', 'OPTM', 'OPTIMA ITALIA', null);
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR, ORDER_BY) VALUES (SEQ_LOV.NEXTVAL, 'AOM_DONOR_SLA', 'OPTM', 'OPTIMA ITALIA', null);
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR, ORDER_BY) VALUES (SEQ_LOV.NEXTVAL, 'AOM_RECIPIENT_SLA', 'OPTM', 'OPTIMA ITALIA', null);