13 lines
403 B
MySQL
13 lines
403 B
MySQL
DELETE FROM DBCGO_PROFILO_FUNZIONE_WEB
|
|
WHERE ID_FUNZIONE=25;
|
|
DELETE FROM DBCGO_FUNZIONE_WEB
|
|
WHERE ID=25 AND ID_PADRE=22;
|
|
Insert into DBCGO_LOV
|
|
(LOV_ID, LOV_NAME, NAME, DESCR, ORDER_BY)
|
|
Values
|
|
(SEQ_LOV.NEXTVAL, 'AOM_DONOR_SLA', 'TIMG', 'Tim', NULL);
|
|
Insert into DBCGO_LOV
|
|
(LOV_ID, LOV_NAME, NAME, DESCR, ORDER_BY)
|
|
Values
|
|
(SEQ_LOV.NEXTVAL, 'AOM_RECIPIENT_SLA', 'TIMG', 'Tim', NULL);
|
|
COMMIT; |