alter table mig_nnpriklj_20230317 add nnpriklj_id number;

update mig_nnpriklj_20230317 set nnpriklj_id=nnpriklj_seq.nextval;

update mig_nnpriklj_20230317 set id_privez=(select id_privez from nnprivez where upper(trim(n_priveza))=upper(trim(sea_berth)));

INSERT INTO nnpriklj (oznaka, priklj, zacetno_stanje, koncno_stanje, zaseden, interni_opis, opis, id_privez, ext_id, ext_date, nnpriklj_id)
SELECT CASE WHEN upper(oznaka)='WATER' THEN 'WT' ELSE 'EL' END, nnpriklj_id, 0, counters, CASE WHEN id_plovila IS NULL THEN 'N' ELSE 'Y' END, plug, plug, id_privez, null, datum, nnpriklj_id FROM mig_nnpriklj_20230317;

select * from mig_all_customers where costumerscode=383;

alter table mig_nnpriklj_20230317 ADD id_plovila NUMBER;
UPDATE mig_nnpriklj_20230317 SET id_plovila=(SELECT id_plovila FROM mig_all_customers WHERE costumerscode=to_number(substr(boat,1,6)));

alter table mig_nnpriklj_20230317 ADD id_lastnika NUMBER;
UPDATE mig_nnpriklj_20230317 SET id_lastnika=(select id_lastnika FROM plovila WHERE id=id_plovila);

select * from priklj where nnpriklj_id=1281;

INSERT INTO priklj (id_priklj, id_lastnika, id_plovila, id, oznaka, prikljucek, datum_zacetka, datum_konca, zacetno_stanje, koncno_stanje, 
                    zaseden, obracunan, stevec_hw_stanje, nnpriklj_id, zacetno_stanje_obracun)
SELECT priklj_seq.nextval, id_lastnika, id_plovila, priklj_seq.currval, CASE WHEN upper(oznaka)='WATER' THEN 'WT' ELSE 'EL' END, nnpriklj_id, datum, null, counters - consumption, counters,
       'Y', 'N', 0, nnpriklj_id, counters - consumption
FROM mig_nnpriklj_20230317
WHERE id_plovila IS NOT NULL;