text: INSERT INTO WWS_COUNTRIES (ID, NAME, ISO3, ISO2, PHONECODE, CAPITAL, CURRENCY, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (168, 'Palau', 'PLW', 'PW', '680', 'Melekeok', 'USD', TO_TIMESTAMP('2018-07-20 16:41:03','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-08-02 21:38:23','YYYY-MM-DD HH24:MI:SS'), 1, 'Q695');
  
  
  
  INSERT ALL
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4526, 'Peleliu', 168, 'PW', '15', '350', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q497981')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4527, 'Ngardmau', 168, 'PW', '10', '222', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q1144496')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4528, 'Airai', 168, 'PW', '02', '004', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q407967')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4529, 'Hatohobei', 168, 'PW', '04', '050', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q3516752')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4530, 'Melekeok', 168, 'PW', '07', '212', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q12898552')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4531, 'Ngatpang', 168, 'PW', '11', '224', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q430385')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4532, 'Koror', 168, 'PW', '06', '150', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q189426')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4533, 'Ngarchelong', 168, 'PW', '09', '218', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q1070185')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4534, 'Ngiwal', 168, 'PW', '14', '228', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q1154101')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4535, 'Sonsorol', 168, 'PW', '16', '370', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q866699')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4536, 'Ngchesar', 168, 'PW', '12', '226', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q1070180')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4537, 'Ngaraard', 168, 'PW', '08', '214', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q1154127')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4538, 'Angaur', 168, 'PW', '03', '010', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q530813')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4539, 'Kayangel', 168, 'PW', '05', '100', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q871222')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4540, 'Aimeliik', 168, 'PW', '01', '002', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q405589')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4541, 'Ngeremlengui', 168, 'PW', '13', '227', TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:59','YYYY-MM-DD HH24:MI:SS'),1, 'Q975076')
  SELECT * FROM dual;
  
  
  INSERT ALL
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89700, 'Angaur State', 4538, '010', 168, 'PW', 6.90601000, 134.12997000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q275862')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89701, 'Imeong Hamlet', 4541, '227', 168, 'PW', 7.53134000, 134.52713000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q2640394')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89702, 'Kayangel', 4539, '100', 168, 'PW', 8.08228000, 134.71725000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q2640394')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89703, 'Kloulklubed', 4526, '350', 168, 'PW', 7.04192000, 134.25561000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q2560228')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89704, 'Koror', 4532, '150', 168, 'PW', 7.33978000, 134.47326000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q527748')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89705, 'Koror Town', 4532, '150', 168, 'PW', 7.34257000, 134.47888000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q527748')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89706, 'Melekeok Village', 4530, '212', 168, 'PW', 7.49567000, 134.63671000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q154002')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89707, 'Mengellang', 4533, '218', 168, 'PW', 7.69570000, 134.63054000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q3001462')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89708, 'Ngardmau', 4527, '222', 168, 'PW', 7.60986000, 134.57440000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q3001462')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89709, 'Ngchemiangel', 4540, '002', 168, 'PW', 7.44613000, 134.47678000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q3001462')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89710, 'Ngchesar Hamlet', 4536, '226', 168, 'PW', 7.46932000, 134.60991000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q3001462')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89711, 'Ngerkeai', 4534, '228', 168, 'PW', 7.55456000, 134.63612000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q3001462')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89712, 'Ngetkib', 4528, '004', 168, 'PW', 7.36451000, 134.51484000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q3001462')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89713, 'Sonsorol Village', 4535, '370', 168, 'PW', 5.32608000, 132.21943000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q2868400')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89714, 'Tobi Village', 4529, '050', 168, 'PW', 3.00488000, 131.12168000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q2868400')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (89715, 'Ulimang', 4537, '214', 168, 'PW', 7.62416000, 134.64208000, TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:44:37','YYYY-MM-DD HH24:MI:SS'), 1, 'Q3481073')
  SELECT * FROM dual;