text: INSERT INTO WWS_COUNTRIES (ID, NAME, ISO3, ISO2, PHONECODE, CAPITAL, CURRENCY, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (10, 'Antigua And Barbuda', 'ATG', 'AG', '+1-268', 'St. John''s', 'XCD', 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, 'Q781');
  
  
  
  INSERT ALL
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (3703, 'Redonda', 10, 'AG', '09', '11', TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'),1, 'Q457261')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (3704, 'Saint Peter Parish', 10, 'AG', '07', '07', TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'),1, 'Q1952603')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (3705, 'Saint Paul Parish', 10, 'AG', '06', '06', TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'),1, 'Q386093')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (3706, 'Saint John Parish', 10, 'AG', '04', '04', TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'),1, 'Q548816')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (3707, 'Saint Mary Parish', 10, 'AG', '05', '05', TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'),1, 'Q1999872')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (3708, 'Barbuda', 10, 'AG', '01', '10', TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'),1, 'Q238752')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (3709, 'Saint George Parish', 10, 'AG', '03', '03', TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'),1, 'Q1770796')
    INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (3710, 'Saint Philip Parish', 10, 'AG', '08', '08', TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:55','YYYY-MM-DD HH24:MI:SS'),1, 'Q1996895')
  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 (142, 'All Saints', 3704, '07', 10, 'AG', 17.06671000, -61.79303000, TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1771715')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (143, 'Bolands', 3707, '05', 10, 'AG', 17.06565000, -61.87466000, TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1771701')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (144, 'Codrington', 3708, '10', 10, 'AG', 17.63333000, -61.83333000, TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1024679')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (145, 'Falmouth', 3705, '06', 10, 'AG', 17.02741000, -61.78136000, TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), 1, 'Q3299460')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (146, 'Liberta', 3705, '06', 10, 'AG', 17.04141000, -61.79052000, TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1771710')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (147, 'Parham', 3704, '07', 10, 'AG', 17.09682000, -61.77046000, TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), 1, 'Q376195')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (148, 'Piggotts', 3709, '03', 10, 'AG', 17.11667000, -61.80000000, TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1771704')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (149, 'Potters Village', 3706, '04', 10, 'AG', 17.11337000, -61.81962000, TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1771587')
    INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (150, 'Saint John’s', 3706, '04', 10, 'AG', 17.12096000, -61.84329000, TO_TIMESTAMP('2019-10-05 14:58:07','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2020-03-02 15:42:10','YYYY-MM-DD HH24:MI:SS'), 1, 'Q36262')
  SELECT * FROM dual;