/*
* Автор: Галкин А.И.
* Дата: 2014-03-31
* Задача: http://jira.softage.ru/jira/browse/SDFO-279
* Назначение: Добавление кодов стран в структуру справочников
* Изменяются объекты:
		alter table ANALYTICCODES
        update table ANALYTICTYPES
		update table ANALYTICCODES
*/

/*
  ****** Инструкции для SQLPlus (обязательно) ******
  Для печати сообщений:
  DBMS_OUTPUT.put_line('<Message>');
*/
whenever sqlerror exit 1;
set serveroutput on;
set echo off;

declare
	filename      varchar2(256) := 'sfm.database-update.2014-03-31.AddCountriesCodes.sql';
	purpose       varchar2(4000) := 'Добавление кодов стран в структуру справочников';
	script_exists number := 0;
begin

	--delete from DB_Update_History where script_name = filename;	commit;
	select count(*)
		into script_exists
		from DB_Update_History
	 where script_name = filename;

	if (script_exists > 0) then
		RAISE_APPLICATION_ERROR(-20001, '"' || filename || '" уже присутствует в базе');
	else
		insert into DB_Update_History
			(script_name, purpose)
		values
			(filename, purpose);
	end if;

	/*
	****** Begin update script ******
	*/
		-- Транзакционный апдейт
		-- execute immediate '';
	/*
	****** End update script ******
	*/
	commit;

exception
	when others then
		rollback;
		raise;
end;
/

delete from ANALYTICCODES where ANALYTICTYPE = 41019;
delete from ANALYTICTYPES where ANALYTICTYPE = 41019;
insert into ANALYTICTYPES (ANALYTICTYPE, ANALYTICNAME, VISIBLEFORUSERS, ALTERDATE) 
	values (41019, 'Страны мира', 1, sysdate);
commit;

/

insert into ANALYTICCODES (ANALYTICTYPE, ANALYTICCODE, ANALYTICNAME, SHORTNAME, OUTER_CODE) 
with ddd as
(
select 41019 ANALYTICTYPE, 4 ANALYTICCODE, 'АФГАНИСТАН' ANALYTICNAME, 'АФГАНИСТАН' SHORTNAME, 'AF' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 8 ANALYTICCODE, 'АЛБАНИЯ' ANALYTICNAME, 'АЛБАНИЯ' SHORTNAME, 'AL' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 10 ANALYTICCODE, 'АНТАРКТИДА' ANALYTICNAME, 'АНТАРКТИДА' SHORTNAME, 'AQ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 12 ANALYTICCODE, 'АЛЖИР' ANALYTICNAME, 'АЛЖИР' SHORTNAME, 'DZ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 16 ANALYTICCODE, 'АМЕРИКАНСКОЕ САМОА' ANALYTICNAME, 'АМЕРИКАНСКОЕ САМОА' SHORTNAME, 'AS' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 20 ANALYTICCODE, 'АНДОРРА' ANALYTICNAME, 'АНДОРРА' SHORTNAME, 'AD' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 24 ANALYTICCODE, 'АНГОЛА' ANALYTICNAME, 'АНГОЛА' SHORTNAME, 'AO' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 28 ANALYTICCODE, 'АНТИГУА И БАРБУДА' ANALYTICNAME, 'АНТИГУА И БАРБУДА' SHORTNAME, 'AG' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 31 ANALYTICCODE, 'АЗЕРБАЙДЖАН' ANALYTICNAME, 'АЗЕРБАЙДЖАН' SHORTNAME, 'AZ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 32 ANALYTICCODE, 'АРГЕНТИНА' ANALYTICNAME, 'АРГЕНТИНА' SHORTNAME, 'AR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 36 ANALYTICCODE, 'АВСТРАЛИЯ' ANALYTICNAME, 'АВСТРАЛИЯ' SHORTNAME, 'AU' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 40 ANALYTICCODE, 'АВСТРИЯ' ANALYTICNAME, 'АВСТРИЯ' SHORTNAME, 'AT' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 44 ANALYTICCODE, 'БАГАМЫ' ANALYTICNAME, 'БАГАМЫ' SHORTNAME, 'BS' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 48 ANALYTICCODE, 'БАХРЕЙН' ANALYTICNAME, 'БАХРЕЙН' SHORTNAME, 'BH' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 50 ANALYTICCODE, 'БАНГЛАДЕШ' ANALYTICNAME, 'БАНГЛАДЕШ' SHORTNAME, 'BD' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 51 ANALYTICCODE, 'АРМЕНИЯ' ANALYTICNAME, 'АРМЕНИЯ' SHORTNAME, 'AM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 52 ANALYTICCODE, 'БАРБАДОС' ANALYTICNAME, 'БАРБАДОС' SHORTNAME, 'BB' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 56 ANALYTICCODE, 'БЕЛЬГИЯ' ANALYTICNAME, 'БЕЛЬГИЯ' SHORTNAME, 'BE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 60 ANALYTICCODE, 'БЕРМУДЫ' ANALYTICNAME, 'БЕРМУДЫ' SHORTNAME, 'BM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 64 ANALYTICCODE, 'БУТАН' ANALYTICNAME, 'БУТАН' SHORTNAME, 'BT' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 68 ANALYTICCODE, 'БОЛИВИЯ' ANALYTICNAME, 'БОЛИВИЯ' SHORTNAME, 'BO' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 70 ANALYTICCODE, 'БОСНИЯ И ГЕРЦЕГОВИНА' ANALYTICNAME, 'БОСНИЯ И ГЕРЦЕГОВИНА' SHORTNAME, 'BA' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 72 ANALYTICCODE, 'БОТСВАНА' ANALYTICNAME, 'БОТСВАНА' SHORTNAME, 'BW' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 74 ANALYTICCODE, 'БУВЕ' ANALYTICNAME, 'БУВЕ' SHORTNAME, 'BV' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 76 ANALYTICCODE, 'БРАЗИЛИЯ' ANALYTICNAME, 'БРАЗИЛИЯ' SHORTNAME, 'BR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 84 ANALYTICCODE, 'БЕЛИЗ' ANALYTICNAME, 'БЕЛИЗ' SHORTNAME, 'BZ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 86 ANALYTICCODE, 'БРИТАНСКАЯ ТЕРРИТОРИЯ В ИНДИЙСКОМ ОКЕАНЕ' ANALYTICNAME, 'БРИТАНСКАЯ ТЕРРИТОРИЯ В ИНДИЙСКОМ ОКЕАНЕ' SHORTNAME, 'IO' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 90 ANALYTICCODE, 'СОЛОМОНОВЫ ОСТРОВА' ANALYTICNAME, 'СОЛОМОНОВЫ ОСТРОВА' SHORTNAME, 'SB' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 92 ANALYTICCODE, 'ВИРГИНСКИЕ ОСТРОВА, БРИТАНСКИЕ' ANALYTICNAME, 'ВИРГИНСКИЕ ОСТРОВА, БРИТАНСКИЕ' SHORTNAME, 'VG' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 96 ANALYTICCODE, 'БРУНЕЙ-ДАРУССАЛАМ' ANALYTICNAME, 'БРУНЕЙ-ДАРУССАЛАМ' SHORTNAME, 'BN' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 100 ANALYTICCODE, 'БОЛГАРИЯ' ANALYTICNAME, 'БОЛГАРИЯ' SHORTNAME, 'BG' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 104 ANALYTICCODE, 'МЬЯНМА' ANALYTICNAME, 'МЬЯНМА' SHORTNAME, 'MM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 108 ANALYTICCODE, 'БУРУНДИ' ANALYTICNAME, 'БУРУНДИ' SHORTNAME, 'BI' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 112 ANALYTICCODE, 'БЕЛАРУСЬ' ANALYTICNAME, 'БЕЛАРУСЬ' SHORTNAME, 'BY' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 116 ANALYTICCODE, 'КАМБОДЖА' ANALYTICNAME, 'КАМБОДЖА' SHORTNAME, 'KH' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 120 ANALYTICCODE, 'КАМЕРУН' ANALYTICNAME, 'КАМЕРУН' SHORTNAME, 'CM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 124 ANALYTICCODE, 'КАНАДА' ANALYTICNAME, 'КАНАДА' SHORTNAME, 'CA' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 132 ANALYTICCODE, 'КАБО-ВЕРДЕ' ANALYTICNAME, 'КАБО-ВЕРДЕ' SHORTNAME, 'CV' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 136 ANALYTICCODE, 'ОСТРОВА КАЙМАН' ANALYTICNAME, 'ОСТРОВА КАЙМАН' SHORTNAME, 'KY' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 140 ANALYTICCODE, 'ЦЕНТРАЛЬНО-АФРИКАНСКАЯ РЕСПУБЛИКА' ANALYTICNAME, 'ЦЕНТРАЛЬНО-АФРИКАНСКАЯ РЕСПУБЛИКА' SHORTNAME, 'CF' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 144 ANALYTICCODE, 'ШРИ-ЛАНКА' ANALYTICNAME, 'ШРИ-ЛАНКА' SHORTNAME, 'LK' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 148 ANALYTICCODE, 'ЧАД' ANALYTICNAME, 'ЧАД' SHORTNAME, 'TD' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 152 ANALYTICCODE, 'ЧИЛИ' ANALYTICNAME, 'ЧИЛИ' SHORTNAME, 'CL' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 156 ANALYTICCODE, 'КИТАЙ' ANALYTICNAME, 'КИТАЙ' SHORTNAME, 'CN' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 158 ANALYTICCODE, 'ТАЙВАНЬ (КИТАЙ)' ANALYTICNAME, 'ТАЙВАНЬ (КИТАЙ)' SHORTNAME, 'TW' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 162 ANALYTICCODE, 'ОСТРОВ РОЖДЕСТВА' ANALYTICNAME, 'ОСТРОВ РОЖДЕСТВА' SHORTNAME, 'CX' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 166 ANALYTICCODE, 'КОКОСОВЫЕ (КИЛИНГ) ОСТРОВА' ANALYTICNAME, 'КОКОСОВЫЕ (КИЛИНГ) ОСТРОВА' SHORTNAME, 'CC' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 170 ANALYTICCODE, 'КОЛУМБИЯ' ANALYTICNAME, 'КОЛУМБИЯ' SHORTNAME, 'CO' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 174 ANALYTICCODE, 'КОМОРЫ' ANALYTICNAME, 'КОМОРЫ' SHORTNAME, 'KM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 175 ANALYTICCODE, 'МАЙОТТА' ANALYTICNAME, 'МАЙОТТА' SHORTNAME, 'YT' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 178 ANALYTICCODE, 'КОНГО' ANALYTICNAME, 'КОНГО' SHORTNAME, 'CG' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 180 ANALYTICCODE, 'КОНГО, ДЕМОКРАТИЧЕСКАЯ РЕСПУБЛИКА' ANALYTICNAME, 'КОНГО, ДЕМОКРАТИЧЕСКАЯ РЕСПУБЛИКА' SHORTNAME, 'CD' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 184 ANALYTICCODE, 'ОСТРОВА КУКА' ANALYTICNAME, 'ОСТРОВА КУКА' SHORTNAME, 'CK' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 188 ANALYTICCODE, 'КОСТА-РИКА' ANALYTICNAME, 'КОСТА-РИКА' SHORTNAME, 'CR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 191 ANALYTICCODE, 'ХОРВАТИЯ' ANALYTICNAME, 'ХОРВАТИЯ' SHORTNAME, 'HR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 192 ANALYTICCODE, 'КУБА' ANALYTICNAME, 'КУБА' SHORTNAME, 'CU' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 196 ANALYTICCODE, 'КИПР' ANALYTICNAME, 'КИПР' SHORTNAME, 'CY' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 203 ANALYTICCODE, 'ЧЕШСКАЯ РЕСПУБЛИКА' ANALYTICNAME, 'ЧЕШСКАЯ РЕСПУБЛИКА' SHORTNAME, 'CZ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 204 ANALYTICCODE, 'БЕНИН' ANALYTICNAME, 'БЕНИН' SHORTNAME, 'BJ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 208 ANALYTICCODE, 'ДАНИЯ' ANALYTICNAME, 'ДАНИЯ' SHORTNAME, 'DK' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 212 ANALYTICCODE, 'ДОМИНИКА' ANALYTICNAME, 'ДОМИНИКА' SHORTNAME, 'DM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 214 ANALYTICCODE, 'ДОМИНИКАНСКАЯ РЕСПУБЛИКА' ANALYTICNAME, 'ДОМИНИКАНСКАЯ РЕСПУБЛИКА' SHORTNAME, 'DO' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 218 ANALYTICCODE, 'ЭКВАДОР' ANALYTICNAME, 'ЭКВАДОР' SHORTNAME, 'EC' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 222 ANALYTICCODE, 'ЭЛЬ-САЛЬВАДОР' ANALYTICNAME, 'ЭЛЬ-САЛЬВАДОР' SHORTNAME, 'SV' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 226 ANALYTICCODE, 'ЭКВАТОРИАЛЬНАЯ ГВИНЕЯ' ANALYTICNAME, 'ЭКВАТОРИАЛЬНАЯ ГВИНЕЯ' SHORTNAME, 'GQ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 231 ANALYTICCODE, 'ЭФИОПИЯ' ANALYTICNAME, 'ЭФИОПИЯ' SHORTNAME, 'ET' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 232 ANALYTICCODE, 'ЭРИТРЕЯ' ANALYTICNAME, 'ЭРИТРЕЯ' SHORTNAME, 'ER' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 233 ANALYTICCODE, 'ЭСТОНИЯ' ANALYTICNAME, 'ЭСТОНИЯ' SHORTNAME, 'EE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 234 ANALYTICCODE, 'ФАРЕРСКИЕ ОСТРОВА' ANALYTICNAME, 'ФАРЕРСКИЕ ОСТРОВА' SHORTNAME, 'FO' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 238 ANALYTICCODE, 'ФОЛКЛЕНДСКИЕ ОСТРОВА (МАЛЬВИНСКИЕ)' ANALYTICNAME, 'ФОЛКЛЕНДСКИЕ ОСТРОВА (МАЛЬВИНСКИЕ)' SHORTNAME, 'FK' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 239 ANALYTICCODE, 'ЮЖН. ДЖОРДЖИЯ И ЮЖН. САНДВИЧ. ОСТРОВА' ANALYTICNAME, 'ЮЖН. ДЖОРДЖИЯ И ЮЖН. САНДВИЧ. ОСТРОВА' SHORTNAME, 'GS' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 242 ANALYTICCODE, 'ФИДЖИ' ANALYTICNAME, 'ФИДЖИ' SHORTNAME, 'FJ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 246 ANALYTICCODE, 'ФИНЛЯНДИЯ' ANALYTICNAME, 'ФИНЛЯНДИЯ' SHORTNAME, 'FI' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 248 ANALYTICCODE, 'ЭЛАНДСКИЕ ОСТРОВА' ANALYTICNAME, 'ЭЛАНДСКИЕ ОСТРОВА' SHORTNAME, 'AX' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 250 ANALYTICCODE, 'ФРАНЦИЯ' ANALYTICNAME, 'ФРАНЦИЯ' SHORTNAME, 'FR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 254 ANALYTICCODE, 'ФРАНЦУЗСКАЯ ГВИАНА' ANALYTICNAME, 'ФРАНЦУЗСКАЯ ГВИАНА' SHORTNAME, 'GF' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 258 ANALYTICCODE, 'ФРАНЦУЗСКАЯ ПОЛИНЕЗИЯ' ANALYTICNAME, 'ФРАНЦУЗСКАЯ ПОЛИНЕЗИЯ' SHORTNAME, 'PF' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 260 ANALYTICCODE, 'ФРАНЦУЗСКИЕ ЮЖНЫЕ ТЕРРИТОРИИ' ANALYTICNAME, 'ФРАНЦУЗСКИЕ ЮЖНЫЕ ТЕРРИТОРИИ' SHORTNAME, 'TF' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 262 ANALYTICCODE, 'ДЖИБУТИ' ANALYTICNAME, 'ДЖИБУТИ' SHORTNAME, 'DJ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 266 ANALYTICCODE, 'ГАБОН' ANALYTICNAME, 'ГАБОН' SHORTNAME, 'GA' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 268 ANALYTICCODE, 'ГРУЗИЯ' ANALYTICNAME, 'ГРУЗИЯ' SHORTNAME, 'GE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 270 ANALYTICCODE, 'ГАМБИЯ' ANALYTICNAME, 'ГАМБИЯ' SHORTNAME, 'GM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 275 ANALYTICCODE, 'ПАЛЕСТИНСКАЯ ТЕРРИТ., ОККУПИРОВАННАЯ' ANALYTICNAME, 'ПАЛЕСТИНСКАЯ ТЕРРИТ., ОККУПИРОВАННАЯ' SHORTNAME, 'PS' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 276 ANALYTICCODE, 'ГЕРМАНИЯ' ANALYTICNAME, 'ГЕРМАНИЯ' SHORTNAME, 'DE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 288 ANALYTICCODE, 'ГАНА' ANALYTICNAME, 'ГАНА' SHORTNAME, 'GH' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 292 ANALYTICCODE, 'ГИБРАЛТАР' ANALYTICNAME, 'ГИБРАЛТАР' SHORTNAME, 'GI' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 296 ANALYTICCODE, 'КИРИБАТИ' ANALYTICNAME, 'КИРИБАТИ' SHORTNAME, 'KI' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 300 ANALYTICCODE, 'ГРЕЦИЯ' ANALYTICNAME, 'ГРЕЦИЯ' SHORTNAME, 'GR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 304 ANALYTICCODE, 'ГРЕНЛАНДИЯ' ANALYTICNAME, 'ГРЕНЛАНДИЯ' SHORTNAME, 'GL' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 308 ANALYTICCODE, 'ГРЕНАДА' ANALYTICNAME, 'ГРЕНАДА' SHORTNAME, 'GD' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 312 ANALYTICCODE, 'ГВАДЕЛУПА' ANALYTICNAME, 'ГВАДЕЛУПА' SHORTNAME, 'GP' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 316 ANALYTICCODE, 'ГУАМ' ANALYTICNAME, 'ГУАМ' SHORTNAME, 'GU' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 320 ANALYTICCODE, 'ГВАТЕМАЛА' ANALYTICNAME, 'ГВАТЕМАЛА' SHORTNAME, 'GT' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 324 ANALYTICCODE, 'ГВИНЕЯ' ANALYTICNAME, 'ГВИНЕЯ' SHORTNAME, 'GN' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 328 ANALYTICCODE, 'ГАЙАНА' ANALYTICNAME, 'ГАЙАНА' SHORTNAME, 'GY' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 332 ANALYTICCODE, 'ГАИТИ' ANALYTICNAME, 'ГАИТИ' SHORTNAME, 'HT' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 334 ANALYTICCODE, 'ОСТРОВ ХЕРД И ОСТРОВА МАКДОНАЛЬД' ANALYTICNAME, 'ОСТРОВ ХЕРД И ОСТРОВА МАКДОНАЛЬД' SHORTNAME, 'HM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 336 ANALYTICCODE, 'ПАПСКИЙ ПРЕСТОЛ (ГОС.-ГОРОД ВАТИКАН)' ANALYTICNAME, 'ПАПСКИЙ ПРЕСТОЛ (ГОС.-ГОРОД ВАТИКАН)' SHORTNAME, 'VA' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 340 ANALYTICCODE, 'ГОНДУРАС' ANALYTICNAME, 'ГОНДУРАС' SHORTNAME, 'HN' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 344 ANALYTICCODE, 'ГОНКОНГ' ANALYTICNAME, 'ГОНКОНГ' SHORTNAME, 'HK' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 348 ANALYTICCODE, 'ВЕНГРИЯ' ANALYTICNAME, 'ВЕНГРИЯ' SHORTNAME, 'HU' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 352 ANALYTICCODE, 'ИСЛАНДИЯ' ANALYTICNAME, 'ИСЛАНДИЯ' SHORTNAME, 'IS' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 356 ANALYTICCODE, 'ИНДИЯ' ANALYTICNAME, 'ИНДИЯ' SHORTNAME, 'IN' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 359 ANALYTICCODE, 'СЕНТ-КИТС И НЕВИС' ANALYTICNAME, 'СЕНТ-КИТС И НЕВИС' SHORTNAME, 'KN' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 360 ANALYTICCODE, 'ИНДОНЕЗИЯ' ANALYTICNAME, 'ИНДОНЕЗИЯ' SHORTNAME, 'ID' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 364 ANALYTICCODE, 'ИРАН, ИСЛАМСКАЯ РЕСПУБЛИКА' ANALYTICNAME, 'ИРАН, ИСЛАМСКАЯ РЕСПУБЛИКА' SHORTNAME, 'IR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 368 ANALYTICCODE, 'ИРАК' ANALYTICNAME, 'ИРАК' SHORTNAME, 'IQ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 372 ANALYTICCODE, 'ИРЛАНДИЯ' ANALYTICNAME, 'ИРЛАНДИЯ' SHORTNAME, 'IE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 376 ANALYTICCODE, 'ИЗРАИЛЬ' ANALYTICNAME, 'ИЗРАИЛЬ' SHORTNAME, 'IL' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 380 ANALYTICCODE, 'ИТАЛИЯ' ANALYTICNAME, 'ИТАЛИЯ' SHORTNAME, 'IT' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 384 ANALYTICCODE, 'КОТ Д''ИВУАР' ANALYTICNAME, 'КОТ Д''ИВУАР' SHORTNAME, 'CI' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 388 ANALYTICCODE, 'ЯМАЙКА' ANALYTICNAME, 'ЯМАЙКА' SHORTNAME, 'JM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 392 ANALYTICCODE, 'ЯПОНИЯ' ANALYTICNAME, 'ЯПОНИЯ' SHORTNAME, 'JP' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 398 ANALYTICCODE, 'КАЗАХСТАН' ANALYTICNAME, 'КАЗАХСТАН' SHORTNAME, 'KZ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 400 ANALYTICCODE, 'ИОРДАНИЯ' ANALYTICNAME, 'ИОРДАНИЯ' SHORTNAME, 'JO' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 404 ANALYTICCODE, 'КЕНИЯ' ANALYTICNAME, 'КЕНИЯ' SHORTNAME, 'KE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 408 ANALYTICCODE, 'КОРЕЯ, НАРОДНО-ДЕМОКРАТИЧ. РЕСПУБЛ.' ANALYTICNAME, 'КОРЕЯ, НАРОДНО-ДЕМОКРАТИЧ. РЕСПУБЛ.' SHORTNAME, 'KP' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 410 ANALYTICCODE, 'КОРЕЯ, РЕСПУБЛИКА' ANALYTICNAME, 'КОРЕЯ, РЕСПУБЛИКА' SHORTNAME, 'KR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 414 ANALYTICCODE, 'КУВЕЙТ' ANALYTICNAME, 'КУВЕЙТ' SHORTNAME, 'KW' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 417 ANALYTICCODE, 'КИРГИЗИЯ' ANALYTICNAME, 'КИРГИЗИЯ' SHORTNAME, 'KG' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 418 ANALYTICCODE, 'ЛАОС' ANALYTICNAME, 'ЛАОС' SHORTNAME, 'LA' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 422 ANALYTICCODE, 'ЛИВАН' ANALYTICNAME, 'ЛИВАН' SHORTNAME, 'LB' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 426 ANALYTICCODE, 'ЛЕСОТО' ANALYTICNAME, 'ЛЕСОТО' SHORTNAME, 'LS' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 428 ANALYTICCODE, 'ЛАТВИЯ' ANALYTICNAME, 'ЛАТВИЯ' SHORTNAME, 'LV' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 430 ANALYTICCODE, 'ЛИБЕРИЯ' ANALYTICNAME, 'ЛИБЕРИЯ' SHORTNAME, 'LR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 434 ANALYTICCODE, 'ЛИВИЯ' ANALYTICNAME, 'ЛИВИЯ' SHORTNAME, 'LY' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 438 ANALYTICCODE, 'ЛИХТЕНШТЕЙН' ANALYTICNAME, 'ЛИХТЕНШТЕЙН' SHORTNAME, 'LI' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 440 ANALYTICCODE, 'ЛИТВА' ANALYTICNAME, 'ЛИТВА' SHORTNAME, 'LT' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 442 ANALYTICCODE, 'ЛЮКСЕМБУРГ' ANALYTICNAME, 'ЛЮКСЕМБУРГ' SHORTNAME, 'LU' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 446 ANALYTICCODE, 'МАКАО' ANALYTICNAME, 'МАКАО' SHORTNAME, 'MO' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 450 ANALYTICCODE, 'МАДАГАСКАР' ANALYTICNAME, 'МАДАГАСКАР' SHORTNAME, 'MG' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 454 ANALYTICCODE, 'МАЛАВИ' ANALYTICNAME, 'МАЛАВИ' SHORTNAME, 'MW' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 458 ANALYTICCODE, 'МАЛАЙЗИЯ' ANALYTICNAME, 'МАЛАЙЗИЯ' SHORTNAME, 'MY' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 462 ANALYTICCODE, 'МАЛЬДИВЫ' ANALYTICNAME, 'МАЛЬДИВЫ' SHORTNAME, 'MV' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 466 ANALYTICCODE, 'МАЛИ' ANALYTICNAME, 'МАЛИ' SHORTNAME, 'ML' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 470 ANALYTICCODE, 'МАЛЬТА' ANALYTICNAME, 'МАЛЬТА' SHORTNAME, 'MT' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 474 ANALYTICCODE, 'МАРТИНИКА' ANALYTICNAME, 'МАРТИНИКА' SHORTNAME, 'MQ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 478 ANALYTICCODE, 'МАВРИТАНИЯ' ANALYTICNAME, 'МАВРИТАНИЯ' SHORTNAME, 'MR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 480 ANALYTICCODE, 'МАВРИКИЙ' ANALYTICNAME, 'МАВРИКИЙ' SHORTNAME, 'MU' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 484 ANALYTICCODE, 'МЕКСИКА' ANALYTICNAME, 'МЕКСИКА' SHORTNAME, 'MX' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 492 ANALYTICCODE, 'МОНАКО' ANALYTICNAME, 'МОНАКО' SHORTNAME, 'MC' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 496 ANALYTICCODE, 'МОНГОЛИЯ' ANALYTICNAME, 'МОНГОЛИЯ' SHORTNAME, 'MN' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 498 ANALYTICCODE, 'МОЛДОВА, РЕСПУБЛИКА' ANALYTICNAME, 'МОЛДОВА, РЕСПУБЛИКА' SHORTNAME, 'MD' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 499 ANALYTICCODE, 'ЧЕРНОГОРИЯ' ANALYTICNAME, 'ЧЕРНОГОРИЯ' SHORTNAME, 'ME' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 500 ANALYTICCODE, 'МОНТСЕРРАТ' ANALYTICNAME, 'МОНТСЕРРАТ' SHORTNAME, 'MS' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 504 ANALYTICCODE, 'МАРОККО' ANALYTICNAME, 'МАРОККО' SHORTNAME, 'MA' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 508 ANALYTICCODE, 'МОЗАМБИК' ANALYTICNAME, 'МОЗАМБИК' SHORTNAME, 'MZ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 512 ANALYTICCODE, 'ОМАН' ANALYTICNAME, 'ОМАН' SHORTNAME, 'OM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 516 ANALYTICCODE, 'НАМИБИЯ' ANALYTICNAME, 'НАМИБИЯ' SHORTNAME, 'NA' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 520 ANALYTICCODE, 'НАУРУ' ANALYTICNAME, 'НАУРУ' SHORTNAME, 'NR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 524 ANALYTICCODE, 'НЕПАЛ' ANALYTICNAME, 'НЕПАЛ' SHORTNAME, 'NP' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 528 ANALYTICCODE, 'НИДЕРЛАНДЫ' ANALYTICNAME, 'НИДЕРЛАНДЫ' SHORTNAME, 'NL' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 533 ANALYTICCODE, 'АРУБА' ANALYTICNAME, 'АРУБА' SHORTNAME, 'AW' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 540 ANALYTICCODE, 'НОВАЯ КАЛЕДОНИЯ' ANALYTICNAME, 'НОВАЯ КАЛЕДОНИЯ' SHORTNAME, 'NC' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 548 ANALYTICCODE, 'ВАНУАТУ' ANALYTICNAME, 'ВАНУАТУ' SHORTNAME, 'VU' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 554 ANALYTICCODE, 'НОВАЯ ЗЕЛАНДИЯ' ANALYTICNAME, 'НОВАЯ ЗЕЛАНДИЯ' SHORTNAME, 'NZ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 558 ANALYTICCODE, 'НИКАРАГУА' ANALYTICNAME, 'НИКАРАГУА' SHORTNAME, 'NI' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 562 ANALYTICCODE, 'НИГЕР' ANALYTICNAME, 'НИГЕР' SHORTNAME, 'NE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 566 ANALYTICCODE, 'НИГЕРИЯ' ANALYTICNAME, 'НИГЕРИЯ' SHORTNAME, 'NG' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 570 ANALYTICCODE, 'НИУЭ' ANALYTICNAME, 'НИУЭ' SHORTNAME, 'NU' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 574 ANALYTICCODE, 'ОСТРОВ НОРФОЛК' ANALYTICNAME, 'ОСТРОВ НОРФОЛК' SHORTNAME, 'NF' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 578 ANALYTICCODE, 'НОРВЕГИЯ' ANALYTICNAME, 'НОРВЕГИЯ' SHORTNAME, 'NO' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 580 ANALYTICCODE, 'СЕВЕРНЫЕ МАРИАНСКИЕ ОСТРОВА' ANALYTICNAME, 'СЕВЕРНЫЕ МАРИАНСКИЕ ОСТРОВА' SHORTNAME, 'MP' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 581 ANALYTICCODE, 'МАЛЫЕ ТИХООКЕАН. ОТДАЛЕН. ОСТ-ВА С.Ш.' ANALYTICNAME, 'МАЛЫЕ ТИХООКЕАН. ОТДАЛЕН. ОСТ-ВА С.Ш.' SHORTNAME, 'UM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 583 ANALYTICCODE, 'МИКРОНЕЗИЯ, ФЕДЕРАТИВНЫЕ ШТАТЫ' ANALYTICNAME, 'МИКРОНЕЗИЯ, ФЕДЕРАТИВНЫЕ ШТАТЫ' SHORTNAME, 'FM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 584 ANALYTICCODE, 'МАРШАЛЛОВЫ ОСТРОВА' ANALYTICNAME, 'МАРШАЛЛОВЫ ОСТРОВА' SHORTNAME, 'MH' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 585 ANALYTICCODE, 'ПАЛАУ' ANALYTICNAME, 'ПАЛАУ' SHORTNAME, 'PW' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 586 ANALYTICCODE, 'ПАКИСТАН' ANALYTICNAME, 'ПАКИСТАН' SHORTNAME, 'PK' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 590 ANALYTICCODE, 'СЕН-БАРТЕЛЕМИ' ANALYTICNAME, 'СЕН-БАРТЕЛЕМИ' SHORTNAME, 'BL' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 591 ANALYTICCODE, 'ПАНАМА' ANALYTICNAME, 'ПАНАМА' SHORTNAME, 'PA' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 598 ANALYTICCODE, 'ПАПУА-НОВАЯ ГВИНЕЯ' ANALYTICNAME, 'ПАПУА-НОВАЯ ГВИНЕЯ' SHORTNAME, 'PG' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 599 ANALYTICCODE, 'КЮРАСАО' ANALYTICNAME, 'КЮРАСАО' SHORTNAME, 'CW' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 600 ANALYTICCODE, 'ПАРАГВАЙ' ANALYTICNAME, 'ПАРАГВАЙ' SHORTNAME, 'PY' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 604 ANALYTICCODE, 'ПЕРУ' ANALYTICNAME, 'ПЕРУ' SHORTNAME, 'PE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 608 ANALYTICCODE, 'ФИЛИППИНЫ' ANALYTICNAME, 'ФИЛИППИНЫ' SHORTNAME, 'PH' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 612 ANALYTICCODE, 'ПИТКЕРН' ANALYTICNAME, 'ПИТКЕРН' SHORTNAME, 'PN' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 616 ANALYTICCODE, 'ПОЛЬША' ANALYTICNAME, 'ПОЛЬША' SHORTNAME, 'PL' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 620 ANALYTICCODE, 'ПОРТУГАЛИЯ' ANALYTICNAME, 'ПОРТУГАЛИЯ' SHORTNAME, 'PT' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 624 ANALYTICCODE, 'ГВИНЕЯ-БИСАУ' ANALYTICNAME, 'ГВИНЕЯ-БИСАУ' SHORTNAME, 'GW' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 626 ANALYTICCODE, 'ТИМОР-ЛЕСТЕ' ANALYTICNAME, 'ТИМОР-ЛЕСТЕ' SHORTNAME, 'TL' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 630 ANALYTICCODE, 'ПУЭРТО-РИКО' ANALYTICNAME, 'ПУЭРТО-РИКО' SHORTNAME, 'PR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 634 ANALYTICCODE, 'КАТАР' ANALYTICNAME, 'КАТАР' SHORTNAME, 'QA' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 638 ANALYTICCODE, 'РЕЮНЬОН' ANALYTICNAME, 'РЕЮНЬОН' SHORTNAME, 'RE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 642 ANALYTICCODE, 'РУМЫНИЯ' ANALYTICNAME, 'РУМЫНИЯ' SHORTNAME, 'RO' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 643 ANALYTICCODE, 'РОССИЯ' ANALYTICNAME, 'РОССИЯ' SHORTNAME, 'RU' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 646 ANALYTICCODE, 'РУАНДА' ANALYTICNAME, 'РУАНДА' SHORTNAME, 'RW' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 660 ANALYTICCODE, 'АНГИЛЬЯ' ANALYTICNAME, 'АНГИЛЬЯ' SHORTNAME, 'AI' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 662 ANALYTICCODE, 'СЕНТ-ЛЮСИЯ' ANALYTICNAME, 'СЕНТ-ЛЮСИЯ' SHORTNAME, 'LC' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 666 ANALYTICCODE, 'СЕН-ПЬЕР И МИКЕЛОН' ANALYTICNAME, 'СЕН-ПЬЕР И МИКЕЛОН' SHORTNAME, 'PM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 670 ANALYTICCODE, 'СЕНТ-ВИНСЕНТ И ГРЕНАДИНЫ' ANALYTICNAME, 'СЕНТ-ВИНСЕНТ И ГРЕНАДИНЫ' SHORTNAME, 'VC' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 674 ANALYTICCODE, 'САН-МАРИНО' ANALYTICNAME, 'САН-МАРИНО' SHORTNAME, 'SM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 678 ANALYTICCODE, 'САН-ТОМЕ И ПРИНСИПИ' ANALYTICNAME, 'САН-ТОМЕ И ПРИНСИПИ' SHORTNAME, 'ST' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 682 ANALYTICCODE, 'САУДОВСКАЯ АРАВИЯ' ANALYTICNAME, 'САУДОВСКАЯ АРАВИЯ' SHORTNAME, 'SA' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 686 ANALYTICCODE, 'СЕНЕГАЛ' ANALYTICNAME, 'СЕНЕГАЛ' SHORTNAME, 'SN' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 688 ANALYTICCODE, 'СЕРБИЯ' ANALYTICNAME, 'СЕРБИЯ' SHORTNAME, 'RS' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 690 ANALYTICCODE, 'СЕЙШЕЛЫ' ANALYTICNAME, 'СЕЙШЕЛЫ' SHORTNAME, 'SC' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 694 ANALYTICCODE, 'СЬЕРРА-ЛЕОНЕ' ANALYTICNAME, 'СЬЕРРА-ЛЕОНЕ' SHORTNAME, 'SL' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 702 ANALYTICCODE, 'СИНГАПУР' ANALYTICNAME, 'СИНГАПУР' SHORTNAME, 'SG' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 703 ANALYTICCODE, 'СЛОВАКИЯ' ANALYTICNAME, 'СЛОВАКИЯ' SHORTNAME, 'SK' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 704 ANALYTICCODE, 'ВЬЕТНАМ' ANALYTICNAME, 'ВЬЕТНАМ' SHORTNAME, 'VN' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 705 ANALYTICCODE, 'СЛОВЕНИЯ' ANALYTICNAME, 'СЛОВЕНИЯ' SHORTNAME, 'SI' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 706 ANALYTICCODE, 'СОМАЛИ' ANALYTICNAME, 'СОМАЛИ' SHORTNAME, 'SO' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 710 ANALYTICCODE, 'ЮЖНАЯ АФРИКА' ANALYTICNAME, 'ЮЖНАЯ АФРИКА' SHORTNAME, 'ZA' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 716 ANALYTICCODE, 'ЗИМБАБВЕ' ANALYTICNAME, 'ЗИМБАБВЕ' SHORTNAME, 'ZW' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 724 ANALYTICCODE, 'ИСПАНИЯ' ANALYTICNAME, 'ИСПАНИЯ' SHORTNAME, 'ES' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 732 ANALYTICCODE, 'ЗАПАДНАЯ САХАРА' ANALYTICNAME, 'ЗАПАДНАЯ САХАРА' SHORTNAME, 'EH' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 736 ANALYTICCODE, 'СУДАН' ANALYTICNAME, 'СУДАН' SHORTNAME, 'SD' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 740 ANALYTICCODE, 'СУРИНАМ' ANALYTICNAME, 'СУРИНАМ' SHORTNAME, 'SR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 744 ANALYTICCODE, 'ШПИЦБЕРГЕН И ЯН МАЙЕН' ANALYTICNAME, 'ШПИЦБЕРГЕН И ЯН МАЙЕН' SHORTNAME, 'SJ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 748 ANALYTICCODE, 'СВАЗИЛЕНД' ANALYTICNAME, 'СВАЗИЛЕНД' SHORTNAME, 'SZ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 752 ANALYTICCODE, 'ШВЕЦИЯ' ANALYTICNAME, 'ШВЕЦИЯ' SHORTNAME, 'SE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 756 ANALYTICCODE, 'ШВЕЙЦАРИЯ' ANALYTICNAME, 'ШВЕЙЦАРИЯ' SHORTNAME, 'CH' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 760 ANALYTICCODE, 'СИРИЙСКАЯ АРАБСКАЯ РЕСПУБЛИКА' ANALYTICNAME, 'СИРИЙСКАЯ АРАБСКАЯ РЕСПУБЛИКА' SHORTNAME, 'SY' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 762 ANALYTICCODE, 'ТАДЖИКИСТАН' ANALYTICNAME, 'ТАДЖИКИСТАН' SHORTNAME, 'TJ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 764 ANALYTICCODE, 'ТАИЛАНД' ANALYTICNAME, 'ТАИЛАНД' SHORTNAME, 'TH' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 768 ANALYTICCODE, 'ТОГО' ANALYTICNAME, 'ТОГО' SHORTNAME, 'TG' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 772 ANALYTICCODE, 'ТОКЕЛАУ' ANALYTICNAME, 'ТОКЕЛАУ' SHORTNAME, 'TK' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 776 ANALYTICCODE, 'ТОНГА' ANALYTICNAME, 'ТОНГА' SHORTNAME, 'TO' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 780 ANALYTICCODE, 'ТРИНИДАД И ТОБАГО' ANALYTICNAME, 'ТРИНИДАД И ТОБАГО' SHORTNAME, 'TT' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 784 ANALYTICCODE, 'ОБЪЕДИНЕННЫЕ АРАБСКИЕ ЭМИРАТЫ' ANALYTICNAME, 'ОБЪЕДИНЕННЫЕ АРАБСКИЕ ЭМИРАТЫ' SHORTNAME, 'AE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 788 ANALYTICCODE, 'ТУНИС' ANALYTICNAME, 'ТУНИС' SHORTNAME, 'TN' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 792 ANALYTICCODE, 'ТУРЦИЯ' ANALYTICNAME, 'ТУРЦИЯ' SHORTNAME, 'TR' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 795 ANALYTICCODE, 'ТУРКМЕНИЯ' ANALYTICNAME, 'ТУРКМЕНИЯ' SHORTNAME, 'TM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 796 ANALYTICCODE, 'ОСТРОВА ТЕРКС И КАЙКОС' ANALYTICNAME, 'ОСТРОВА ТЕРКС И КАЙКОС' SHORTNAME, 'TC' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 798 ANALYTICCODE, 'ТУВАЛУ' ANALYTICNAME, 'ТУВАЛУ' SHORTNAME, 'TV' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 800 ANALYTICCODE, 'УГАНДА' ANALYTICNAME, 'УГАНДА' SHORTNAME, 'UG' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 804 ANALYTICCODE, 'УКРАИНА' ANALYTICNAME, 'УКРАИНА' SHORTNAME, 'UA' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 807 ANALYTICCODE, 'РЕСПУБЛИКА МАКЕДОНИЯ' ANALYTICNAME, 'РЕСПУБЛИКА МАКЕДОНИЯ' SHORTNAME, 'MK' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 818 ANALYTICCODE, 'ЕГИПЕТ' ANALYTICNAME, 'ЕГИПЕТ' SHORTNAME, 'EG' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 826 ANALYTICCODE, 'СОЕДИНЕННОЕ КОРОЛЕВСТВО' ANALYTICNAME, 'СОЕДИНЕННОЕ КОРОЛЕВСТВО' SHORTNAME, 'GB' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 831 ANALYTICCODE, 'ГЕРНСИ' ANALYTICNAME, 'ГЕРНСИ' SHORTNAME, 'GG' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 832 ANALYTICCODE, 'ДЖЕРСИ' ANALYTICNAME, 'ДЖЕРСИ' SHORTNAME, 'JE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 833 ANALYTICCODE, 'ОСТРОВ МЭН' ANALYTICNAME, 'ОСТРОВ МЭН' SHORTNAME, 'IM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 834 ANALYTICCODE, 'ТАНЗАНИЯ, ОБЪЕДИНЕННАЯ РЕСПУБЛИКА' ANALYTICNAME, 'ТАНЗАНИЯ, ОБЪЕДИНЕННАЯ РЕСПУБЛИКА' SHORTNAME, 'TZ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 840 ANALYTICCODE, 'СОЕДИНЕННЫЕ ШТАТЫ' ANALYTICNAME, 'СОЕДИНЕННЫЕ ШТАТЫ' SHORTNAME, 'US' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 850 ANALYTICCODE, 'ВИРГИНСКИЕ ОСТРОВА, США' ANALYTICNAME, 'ВИРГИНСКИЕ ОСТРОВА, США' SHORTNAME, 'VI' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 854 ANALYTICCODE, 'БУРКИНА-ФАСО' ANALYTICNAME, 'БУРКИНА-ФАСО' SHORTNAME, 'BF' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 858 ANALYTICCODE, 'УРУГВАЙ' ANALYTICNAME, 'УРУГВАЙ' SHORTNAME, 'UY' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 860 ANALYTICCODE, 'УЗБЕКИСТАН' ANALYTICNAME, 'УЗБЕКИСТАН' SHORTNAME, 'UZ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 862 ANALYTICCODE, 'ВЕНЕСУЭЛА, БОЛИВАРИАНСКАЯ РЕСПУБЛИКА' ANALYTICNAME, 'ВЕНЕСУЭЛА, БОЛИВАРИАНСКАЯ РЕСПУБЛИКА' SHORTNAME, 'VE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 876 ANALYTICCODE, 'УОЛЛИС И ФУТУНА' ANALYTICNAME, 'УОЛЛИС И ФУТУНА' SHORTNAME, 'WF' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 882 ANALYTICCODE, 'САМОА' ANALYTICNAME, 'САМОА' SHORTNAME, 'WS' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 887 ANALYTICCODE, 'ЙЕМЕН' ANALYTICNAME, 'ЙЕМЕН' SHORTNAME, 'YE' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 894 ANALYTICCODE, 'ЗАМБИЯ' ANALYTICNAME, 'ЗАМБИЯ' SHORTNAME, 'ZM' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 895 ANALYTICCODE, 'БОНЭЙР, СИНТ-ЭСТАТИУС И САБА' ANALYTICNAME, 'БОНЭЙР, СИНТ-ЭСТАТИУС И САБА' SHORTNAME, 'BQ' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 896 ANALYTICCODE, 'СЕН-МАРТЕН' ANALYTICNAME, 'СЕН-МАРТЕН' SHORTNAME, 'MF' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 897 ANALYTICCODE, 'СЕН-МАРТЕН (нидерландская часть)' ANALYTICNAME, 'СЕН-МАРТЕН (нидерландская часть)' SHORTNAME, 'SX' OUTER_CODE FROM DUAL
union select 41019 ANALYTICTYPE, 898 ANALYTICCODE, 'СВЯТАЯ ЕЛЕНА' ANALYTICNAME, 'СВЯТАЯ ЕЛЕНА' SHORTNAME, 'SH' OUTER_CODE FROM DUAL
) select * from ddd;

commit;
