建立虚拟字典视图，并为其增加主键

CREATE OR REPLACE VIEW V_DIC AS 
SELECT 200 Id, 0 Version, 'link' Type, '01' Code, '搜狐' Name, 'http://www.sohu.com' Url, 1 Flag, '' Memo FROM DUAL
UNION
SELECT 201 Id, 0 Version, 'link' Type, '02' Code, '汽车之家' Name, '' Url, 1 Flag, '' Memo FROM DUAL
UNION
SELECT 202 Id, 0 Version, 'link' Type, '03' Code, 'JavaEye' Name, 'http://www.iteye.com' Url, 1 Flag, '' Memo FROM DUAL
/
ALTER VIEW V_DIC ADD CONSTRAINT Pk_V_Test_Mz PRIMARY KEY (Id) DISABLE NOVALIDATE
/

附上“民族、国别、证件类型、客户机类型、性别、血型”等字典建立语句：

CREATE OR REPLACE VIEW V_DIC AS 
-- 民族
SELECT 1 Id, 0 Version, 'MZ' Type, '01' Code, '汉族' Name, 'HZ' Short_Name, 1 Flag, '汉族' Memo FROM DUAL UNION 
SELECT 2 Id, 0 Version, 'MZ' Type, '02' Code, '蒙古族' Name, 'MGZ' Short_Name, 1 Flag, '蒙古族' Memo FROM DUAL UNION 
SELECT 3 Id, 0 Version, 'MZ' Type, '03' Code, '回族' Name, 'HZ' Short_Name, 1 Flag, '回族' Memo FROM DUAL UNION 
SELECT 4 Id, 0 Version, 'MZ' Type, '04' Code, '藏族' Name, 'ZZ' Short_Name, 1 Flag, '藏族' Memo FROM DUAL UNION 
SELECT 5 Id, 0 Version, 'MZ' Type, '05' Code, '维吾尔族' Name, 'WWEZ' Short_Name, 1 Flag, '维吾尔族' Memo FROM DUAL UNION 
SELECT 6 Id, 0 Version, 'MZ' Type, '06' Code, '苗族' Name, 'MZ' Short_Name, 1 Flag, '苗族' Memo FROM DUAL UNION 
SELECT 7 Id, 0 Version, 'MZ' Type, '07' Code, '彝族' Name, 'YZ' Short_Name, 1 Flag, '彝族' Memo FROM DUAL UNION 
SELECT 8 Id, 0 Version, 'MZ' Type, '08' Code, '壮族' Name, 'ZZ' Short_Name, 1 Flag, '壮族' Memo FROM DUAL UNION 
SELECT 9 Id, 0 Version, 'MZ' Type, '09' Code, '布依族' Name, 'BYZ' Short_Name, 1 Flag, '布依族' Memo FROM DUAL UNION 
SELECT 10 Id, 0 Version, 'MZ' Type, '10' Code, '朝鲜族' Name, 'CXZ' Short_Name, 1 Flag, '朝鲜族' Memo FROM DUAL UNION 
SELECT 11 Id, 0 Version, 'MZ' Type, '11' Code, '满族' Name, 'MZ' Short_Name, 1 Flag, '满族' Memo FROM DUAL UNION 
SELECT 12 Id, 0 Version, 'MZ' Type, '12' Code, '侗族' Name, 'DZ' Short_Name, 1 Flag, '侗族' Memo FROM DUAL UNION 
SELECT 13 Id, 0 Version, 'MZ' Type, '13' Code, '瑶族' Name, 'YZ' Short_Name, 1 Flag, '瑶族' Memo FROM DUAL UNION 
SELECT 14 Id, 0 Version, 'MZ' Type, '14' Code, '白族' Name, 'BZ' Short_Name, 1 Flag, '白族' Memo FROM DUAL UNION 
SELECT 15 Id, 0 Version, 'MZ' Type, '15' Code, '土家族' Name, 'TJZ' Short_Name, 1 Flag, '土家族' Memo FROM DUAL UNION 
SELECT 16 Id, 0 Version, 'MZ' Type, '16' Code, '哈尼族' Name, 'HNZ' Short_Name, 1 Flag, '哈尼族' Memo FROM DUAL UNION 
SELECT 17 Id, 0 Version, 'MZ' Type, '17' Code, '哈萨克族' Name, 'HSKZ' Short_Name, 1 Flag, '哈萨克族' Memo FROM DUAL UNION 
SELECT 18 Id, 0 Version, 'MZ' Type, '18' Code, '傣族' Name, 'DZ' Short_Name, 1 Flag, '傣族' Memo FROM DUAL UNION 
SELECT 19 Id, 0 Version, 'MZ' Type, '19' Code, '黎族' Name, 'LZ' Short_Name, 1 Flag, '黎族' Memo FROM DUAL UNION 
SELECT 20 Id, 0 Version, 'MZ' Type, '20' Code, '傈僳族' Name, 'LSZ' Short_Name, 1 Flag, '傈僳族' Memo FROM DUAL UNION 
SELECT 21 Id, 0 Version, 'MZ' Type, '21' Code, '佤族' Name, 'WZ' Short_Name, 1 Flag, '佤族' Memo FROM DUAL UNION 
SELECT 22 Id, 0 Version, 'MZ' Type, '22' Code, '畲族' Name, 'SZ' Short_Name, 1 Flag, '畲族' Memo FROM DUAL UNION 
SELECT 23 Id, 0 Version, 'MZ' Type, '23' Code, '高山族' Name, 'GSZ' Short_Name, 1 Flag, '高山族' Memo FROM DUAL UNION 
SELECT 24 Id, 0 Version, 'MZ' Type, '24' Code, '拉祜族' Name, 'LHZ' Short_Name, 1 Flag, '拉祜族' Memo FROM DUAL UNION 
SELECT 25 Id, 0 Version, 'MZ' Type, '25' Code, '水族' Name, 'SZ' Short_Name, 1 Flag, '水族' Memo FROM DUAL UNION 
SELECT 26 Id, 0 Version, 'MZ' Type, '26' Code, '东乡族' Name, 'DXZ' Short_Name, 1 Flag, '东乡族' Memo FROM DUAL UNION 
SELECT 27 Id, 0 Version, 'MZ' Type, '27' Code, '纳西族' Name, 'NXZ' Short_Name, 1 Flag, '纳西族' Memo FROM DUAL UNION 
SELECT 28 Id, 0 Version, 'MZ' Type, '28' Code, '景颇族' Name, 'JPZ' Short_Name, 1 Flag, '景颇族' Memo FROM DUAL UNION 
SELECT 29 Id, 0 Version, 'MZ' Type, '29' Code, '柯尔克孜族' Name, 'KEKZZ' Short_Name, 1 Flag, '柯尔克孜族' Memo FROM DUAL UNION 
SELECT 30 Id, 0 Version, 'MZ' Type, '30' Code, '土族' Name, 'TZ' Short_Name, 1 Flag, '土族' Memo FROM DUAL UNION 
SELECT 31 Id, 0 Version, 'MZ' Type, '31' Code, '达斡尔族' Name, 'DWEZ' Short_Name, 1 Flag, '达斡尔族' Memo FROM DUAL UNION 
SELECT 32 Id, 0 Version, 'MZ' Type, '32' Code, '仫佬族' Name, 'MLZ' Short_Name, 1 Flag, '仫佬族' Memo FROM DUAL UNION 
SELECT 33 Id, 0 Version, 'MZ' Type, '33' Code, '羌族' Name, 'QZ' Short_Name, 1 Flag, '羌族' Memo FROM DUAL UNION 
SELECT 34 Id, 0 Version, 'MZ' Type, '34' Code, '布朗族' Name, 'BLZ' Short_Name, 1 Flag, '布朗族' Memo FROM DUAL UNION 
SELECT 35 Id, 0 Version, 'MZ' Type, '35' Code, '撒拉族' Name, 'SLZ' Short_Name, 1 Flag, '撒拉族' Memo FROM DUAL UNION 
SELECT 36 Id, 0 Version, 'MZ' Type, '36' Code, '毛难族' Name, 'MNZ' Short_Name, 1 Flag, '毛难族' Memo FROM DUAL UNION 
SELECT 37 Id, 0 Version, 'MZ' Type, '37' Code, '仡佬族' Name, 'YLZ' Short_Name, 1 Flag, '仡佬族' Memo FROM DUAL UNION 
SELECT 38 Id, 0 Version, 'MZ' Type, '38' Code, '锡伯族' Name, 'XBZ' Short_Name, 1 Flag, '锡伯族' Memo FROM DUAL UNION 
SELECT 39 Id, 0 Version, 'MZ' Type, '39' Code, '阿昌族' Name, 'ACZ' Short_Name, 1 Flag, '阿昌族' Memo FROM DUAL UNION 
SELECT 40 Id, 0 Version, 'MZ' Type, '40' Code, '普米族' Name, 'PMZ' Short_Name, 1 Flag, '普米族' Memo FROM DUAL UNION 
SELECT 41 Id, 0 Version, 'MZ' Type, '41' Code, '塔吉克族' Name, 'TJKZ' Short_Name, 1 Flag, '塔吉克族' Memo FROM DUAL UNION 
SELECT 42 Id, 0 Version, 'MZ' Type, '42' Code, '怒族' Name, 'NZ' Short_Name, 1 Flag, '怒族' Memo FROM DUAL UNION 
SELECT 43 Id, 0 Version, 'MZ' Type, '43' Code, '乌孜别克族' Name, 'WZBKZ' Short_Name, 1 Flag, '乌孜别克族' Memo FROM DUAL UNION 
SELECT 44 Id, 0 Version, 'MZ' Type, '44' Code, '俄罗斯族' Name, 'ELSZ' Short_Name, 1 Flag, '俄罗斯族' Memo FROM DUAL UNION 
SELECT 45 Id, 0 Version, 'MZ' Type, '45' Code, '鄂温克族' Name, 'EWKZ' Short_Name, 1 Flag, '鄂温克族' Memo FROM DUAL UNION 
SELECT 46 Id, 0 Version, 'MZ' Type, '46' Code, '德昂族' Name, 'DAZ' Short_Name, 1 Flag, '德昂族' Memo FROM DUAL UNION 
SELECT 47 Id, 0 Version, 'MZ' Type, '47' Code, '保安族' Name, 'BAZ' Short_Name, 1 Flag, '保安族' Memo FROM DUAL UNION 
SELECT 48 Id, 0 Version, 'MZ' Type, '48' Code, '裕固族' Name, 'YGZ' Short_Name, 1 Flag, '裕固族' Memo FROM DUAL UNION 
SELECT 49 Id, 0 Version, 'MZ' Type, '49' Code, '京族' Name, 'JZ' Short_Name, 1 Flag, '京族' Memo FROM DUAL UNION 
SELECT 50 Id, 0 Version, 'MZ' Type, '50' Code, '塔塔尔族' Name, 'TTEZ' Short_Name, 1 Flag, '塔塔尔族' Memo FROM DUAL UNION 
SELECT 51 Id, 0 Version, 'MZ' Type, '51' Code, '独龙族' Name, 'DLZ' Short_Name, 1 Flag, '独龙族' Memo FROM DUAL UNION 
SELECT 52 Id, 0 Version, 'MZ' Type, '52' Code, '鄂伦春族' Name, 'ELCZ' Short_Name, 1 Flag, '鄂伦春族' Memo FROM DUAL UNION 
SELECT 53 Id, 0 Version, 'MZ' Type, '53' Code, '赫哲族' Name, 'HZZ' Short_Name, 1 Flag, '赫哲族' Memo FROM DUAL UNION 
SELECT 54 Id, 0 Version, 'MZ' Type, '54' Code, '门巴族' Name, 'MBZ' Short_Name, 1 Flag, '门巴族' Memo FROM DUAL UNION 
SELECT 55 Id, 0 Version, 'MZ' Type, '55' Code, '珞巴族' Name, 'LBZ' Short_Name, 1 Flag, '珞巴族' Memo FROM DUAL UNION 
SELECT 56 Id, 0 Version, 'MZ' Type, '56' Code, '基诺族' Name, 'JNZ' Short_Name, 1 Flag, '基诺族' Memo FROM DUAL
UNION	-- 国别
SELECT 57 Id, 0 Version, 'GB' Type, 'ad' Code, '安道尔' Name, 'ad' Short_Name, 1 Flag, '安道尔' Memo FROM DUAL UNION 
SELECT 58 Id, 0 Version, 'GB' Type, 'ae' Code, '阿联酋' Name, 'ae' Short_Name, 1 Flag, '阿联酋' Memo FROM DUAL UNION 
SELECT 59 Id, 0 Version, 'GB' Type, 'af' Code, '阿富汗' Name, 'af' Short_Name, 1 Flag, '阿富汗' Memo FROM DUAL UNION 
SELECT 60 Id, 0 Version, 'GB' Type, 'ag' Code, '安提瓜和巴布达' Name, 'ag' Short_Name, 1 Flag, '安提瓜和巴布达' Memo FROM DUAL UNION 
SELECT 61 Id, 0 Version, 'GB' Type, 'ai' Code, '安格拉' Name, 'ai' Short_Name, 1 Flag, '安格拉' Memo FROM DUAL UNION 
SELECT 62 Id, 0 Version, 'GB' Type, 'al' Code, '阿尔巴尼亚' Name, 'al' Short_Name, 1 Flag, '阿尔巴尼亚' Memo FROM DUAL UNION 
SELECT 63 Id, 0 Version, 'GB' Type, 'am' Code, '亚美尼亚' Name, 'am' Short_Name, 1 Flag, '亚美尼亚' Memo FROM DUAL UNION 
SELECT 64 Id, 0 Version, 'GB' Type, 'an' Code, '荷兰属地' Name, 'an' Short_Name, 1 Flag, '荷兰属地' Memo FROM DUAL UNION 
SELECT 65 Id, 0 Version, 'GB' Type, 'ao' Code, '安哥拉' Name, 'ao' Short_Name, 1 Flag, '安哥拉' Memo FROM DUAL UNION 
SELECT 66 Id, 0 Version, 'GB' Type, 'aq' Code, '南极洲' Name, 'aq' Short_Name, 1 Flag, '南极洲' Memo FROM DUAL UNION 
SELECT 67 Id, 0 Version, 'GB' Type, 'ar' Code, '阿根廷' Name, 'ar' Short_Name, 1 Flag, '阿根廷' Memo FROM DUAL UNION 
SELECT 68 Id, 0 Version, 'GB' Type, 'as' Code, '东萨摩亚' Name, 'as' Short_Name, 1 Flag, '东萨摩亚' Memo FROM DUAL UNION 
SELECT 69 Id, 0 Version, 'GB' Type, 'at' Code, '奥地利' Name, 'at' Short_Name, 1 Flag, '奥地利' Memo FROM DUAL UNION 
SELECT 70 Id, 0 Version, 'GB' Type, 'au' Code, '澳大利亚' Name, 'au' Short_Name, 1 Flag, '澳大利亚' Memo FROM DUAL UNION 
SELECT 71 Id, 0 Version, 'GB' Type, 'aw' Code, '阿鲁巴' Name, 'aw' Short_Name, 1 Flag, '阿鲁巴' Memo FROM DUAL UNION 
SELECT 72 Id, 0 Version, 'GB' Type, 'az' Code, '阿塞拜疆' Name, 'az' Short_Name, 1 Flag, '阿塞拜疆' Memo FROM DUAL UNION 
SELECT 73 Id, 0 Version, 'GB' Type, 'ba' Code, '波黑' Name, 'ba' Short_Name, 1 Flag, '波黑' Memo FROM DUAL UNION 
SELECT 74 Id, 0 Version, 'GB' Type, 'bb' Code, '巴巴多斯' Name, 'bb' Short_Name, 1 Flag, '巴巴多斯' Memo FROM DUAL UNION 
SELECT 75 Id, 0 Version, 'GB' Type, 'bd' Code, '孟加拉国' Name, 'bd' Short_Name, 1 Flag, '孟加拉国' Memo FROM DUAL UNION 
SELECT 76 Id, 0 Version, 'GB' Type, 'be' Code, '比利时' Name, 'be' Short_Name, 1 Flag, '比利时' Memo FROM DUAL UNION 
SELECT 77 Id, 0 Version, 'GB' Type, 'bf' Code, '布基纳法索' Name, 'bf' Short_Name, 1 Flag, '布基纳法索' Memo FROM DUAL UNION 
SELECT 78 Id, 0 Version, 'GB' Type, 'bg' Code, '保加利亚' Name, 'bg' Short_Name, 1 Flag, '保加利亚' Memo FROM DUAL UNION 
SELECT 79 Id, 0 Version, 'GB' Type, 'bh' Code, '巴林' Name, 'bh' Short_Name, 1 Flag, '巴林' Memo FROM DUAL UNION 
SELECT 80 Id, 0 Version, 'GB' Type, 'bi' Code, '布隆迪' Name, 'bi' Short_Name, 1 Flag, '布隆迪' Memo FROM DUAL UNION 
SELECT 81 Id, 0 Version, 'GB' Type, 'bj' Code, '贝宁' Name, 'bj' Short_Name, 1 Flag, '贝宁' Memo FROM DUAL UNION 
SELECT 82 Id, 0 Version, 'GB' Type, 'bm' Code, '百慕大' Name, 'bm' Short_Name, 1 Flag, '百慕大' Memo FROM DUAL UNION 
SELECT 83 Id, 0 Version, 'GB' Type, 'bn' Code, '文莱达鲁萨兰国' Name, 'bn' Short_Name, 1 Flag, '文莱达鲁萨兰国' Memo FROM DUAL UNION 
SELECT 84 Id, 0 Version, 'GB' Type, 'bo' Code, '玻利维亚' Name, 'bo' Short_Name, 1 Flag, '玻利维亚' Memo FROM DUAL UNION 
SELECT 85 Id, 0 Version, 'GB' Type, 'br' Code, '巴西' Name, 'br' Short_Name, 1 Flag, '巴西' Memo FROM DUAL UNION 
SELECT 86 Id, 0 Version, 'GB' Type, 'bs' Code, '巴哈马' Name, 'bs' Short_Name, 1 Flag, '巴哈马' Memo FROM DUAL UNION 
SELECT 87 Id, 0 Version, 'GB' Type, 'bt' Code, '不丹' Name, 'bt' Short_Name, 1 Flag, '不丹' Memo FROM DUAL UNION 
SELECT 88 Id, 0 Version, 'GB' Type, 'bv' Code, '布韦群岛' Name, 'bv' Short_Name, 1 Flag, '布韦群岛' Memo FROM DUAL UNION 
SELECT 89 Id, 0 Version, 'GB' Type, 'bw' Code, '伯兹瓦纳' Name, 'bw' Short_Name, 1 Flag, '伯兹瓦纳' Memo FROM DUAL UNION 
SELECT 90 Id, 0 Version, 'GB' Type, 'by' Code, '白俄罗斯' Name, 'by' Short_Name, 1 Flag, '白俄罗斯' Memo FROM DUAL UNION 
SELECT 91 Id, 0 Version, 'GB' Type, 'bz' Code, '伯利兹' Name, 'bz' Short_Name, 1 Flag, '伯利兹' Memo FROM DUAL UNION 
SELECT 92 Id, 0 Version, 'GB' Type, 'ca' Code, '加拿大' Name, 'ca' Short_Name, 1 Flag, '加拿大' Memo FROM DUAL UNION 
SELECT 93 Id, 0 Version, 'GB' Type, 'cc' Code, '科科斯群岛' Name, 'cc' Short_Name, 1 Flag, '科科斯群岛' Memo FROM DUAL UNION 
SELECT 94 Id, 0 Version, 'GB' Type, 'cf' Code, '中非共和国' Name, 'cf' Short_Name, 1 Flag, '中非共和国' Memo FROM DUAL UNION 
SELECT 95 Id, 0 Version, 'GB' Type, 'cg' Code, '刚果' Name, 'cg' Short_Name, 1 Flag, '刚果' Memo FROM DUAL UNION 
SELECT 96 Id, 0 Version, 'GB' Type, 'ch' Code, '瑞士' Name, 'ch' Short_Name, 1 Flag, '瑞士' Memo FROM DUAL UNION 
SELECT 97 Id, 0 Version, 'GB' Type, 'ci' Code, '象牙海岸' Name, 'ci' Short_Name, 1 Flag, '象牙海岸' Memo FROM DUAL UNION 
SELECT 98 Id, 0 Version, 'GB' Type, 'ck' Code, '库克群岛' Name, 'ck' Short_Name, 1 Flag, '库克群岛' Memo FROM DUAL UNION 
SELECT 99 Id, 0 Version, 'GB' Type, 'cl' Code, '智利' Name, 'cl' Short_Name, 1 Flag, '智利' Memo FROM DUAL UNION 
SELECT 100 Id, 0 Version, 'GB' Type, 'cm' Code, '喀麦隆' Name, 'cm' Short_Name, 1 Flag, '喀麦隆' Memo FROM DUAL UNION 
SELECT 101 Id, 0 Version, 'GB' Type, 'cn' Code, '中国' Name, 'cn' Short_Name, 1 Flag, '中国' Memo FROM DUAL UNION 
SELECT 102 Id, 0 Version, 'GB' Type, 'co' Code, '哥伦比亚' Name, 'co' Short_Name, 1 Flag, '哥伦比亚' Memo FROM DUAL UNION 
SELECT 103 Id, 0 Version, 'GB' Type, 'cq' Code, '赤道几内亚' Name, 'cq' Short_Name, 1 Flag, '赤道几内亚' Memo FROM DUAL UNION 
SELECT 104 Id, 0 Version, 'GB' Type, 'cr' Code, '哥斯达黎加' Name, 'cr' Short_Name, 1 Flag, '哥斯达黎加' Memo FROM DUAL UNION 
SELECT 105 Id, 0 Version, 'GB' Type, 'cu' Code, '古巴' Name, 'cu' Short_Name, 1 Flag, '古巴' Memo FROM DUAL UNION 
SELECT 106 Id, 0 Version, 'GB' Type, 'cv' Code, '佛得角' Name, 'cv' Short_Name, 1 Flag, '佛得角' Memo FROM DUAL UNION 
SELECT 107 Id, 0 Version, 'GB' Type, 'cx' Code, '圣诞岛（英属）' Name, 'cx' Short_Name, 1 Flag, '圣诞岛（英属）' Memo FROM DUAL UNION 
SELECT 108 Id, 0 Version, 'GB' Type, 'cy' Code, '塞浦路斯' Name, 'cy' Short_Name, 1 Flag, '塞浦路斯' Memo FROM DUAL UNION 
SELECT 109 Id, 0 Version, 'GB' Type, 'cz' Code, '捷克共和国' Name, 'cz' Short_Name, 1 Flag, '捷克共和国' Memo FROM DUAL UNION 
SELECT 110 Id, 0 Version, 'GB' Type, 'de' Code, '德国' Name, 'de' Short_Name, 1 Flag, '德国' Memo FROM DUAL UNION 
SELECT 111 Id, 0 Version, 'GB' Type, 'dj' Code, '吉布提' Name, 'dj' Short_Name, 1 Flag, '吉布提' Memo FROM DUAL UNION 
SELECT 112 Id, 0 Version, 'GB' Type, 'dk' Code, '丹麦' Name, 'dk' Short_Name, 1 Flag, '丹麦' Memo FROM DUAL UNION 
SELECT 113 Id, 0 Version, 'GB' Type, 'dm' Code, '多米尼加联邦' Name, 'dm' Short_Name, 1 Flag, '多米尼加联邦' Memo FROM DUAL UNION 
SELECT 114 Id, 0 Version, 'GB' Type, 'do' Code, '多米尼加共和国' Name, 'do' Short_Name, 1 Flag, '多米尼加共和国' Memo FROM DUAL UNION 
SELECT 115 Id, 0 Version, 'GB' Type, 'dz' Code, '阿尔及利亚' Name, 'dz' Short_Name, 1 Flag, '阿尔及利亚' Memo FROM DUAL UNION 
SELECT 116 Id, 0 Version, 'GB' Type, 'ec' Code, '厄瓜多尔' Name, 'ec' Short_Name, 1 Flag, '厄瓜多尔' Memo FROM DUAL UNION 
SELECT 117 Id, 0 Version, 'GB' Type, 'ee' Code, '爱沙尼亚' Name, 'ee' Short_Name, 1 Flag, '爱沙尼亚' Memo FROM DUAL UNION 
SELECT 118 Id, 0 Version, 'GB' Type, 'eg' Code, '埃及' Name, 'eg' Short_Name, 1 Flag, '埃及' Memo FROM DUAL UNION 
SELECT 119 Id, 0 Version, 'GB' Type, 'eh' Code, '西萨摩亚' Name, 'eh' Short_Name, 1 Flag, '西萨摩亚' Memo FROM DUAL UNION 
SELECT 120 Id, 0 Version, 'GB' Type, 'es' Code, '西班牙' Name, 'es' Short_Name, 1 Flag, '西班牙' Memo FROM DUAL UNION 
SELECT 121 Id, 0 Version, 'GB' Type, 'et' Code, '埃塞俄比亚' Name, 'et' Short_Name, 1 Flag, '埃塞俄比亚' Memo FROM DUAL UNION 
SELECT 122 Id, 0 Version, 'GB' Type, 'ev' Code, '萨尔瓦多' Name, 'ev' Short_Name, 1 Flag, '萨尔瓦多' Memo FROM DUAL UNION 
SELECT 123 Id, 0 Version, 'GB' Type, 'fi' Code, '芬兰' Name, 'fi' Short_Name, 1 Flag, '芬兰' Memo FROM DUAL UNION 
SELECT 124 Id, 0 Version, 'GB' Type, 'fj' Code, '斐济' Name, 'fj' Short_Name, 1 Flag, '斐济' Memo FROM DUAL UNION 
SELECT 125 Id, 0 Version, 'GB' Type, 'fk' Code, '福克兰群岛' Name, 'fk' Short_Name, 1 Flag, '福克兰群岛' Memo FROM DUAL UNION 
SELECT 126 Id, 0 Version, 'GB' Type, 'fm' Code, '密克罗尼西亚' Name, 'fm' Short_Name, 1 Flag, '密克罗尼西亚' Memo FROM DUAL UNION 
SELECT 127 Id, 0 Version, 'GB' Type, 'fo' Code, '法罗群岛' Name, 'fo' Short_Name, 1 Flag, '法罗群岛' Memo FROM DUAL UNION 
SELECT 128 Id, 0 Version, 'GB' Type, 'fr' Code, '法国' Name, 'fr' Short_Name, 1 Flag, '法国' Memo FROM DUAL UNION 
SELECT 129 Id, 0 Version, 'GB' Type, 'ga' Code, '加蓬' Name, 'ga' Short_Name, 1 Flag, '加蓬' Memo FROM DUAL UNION 
SELECT 130 Id, 0 Version, 'GB' Type, 'gb' Code, '大不列颠联合王国' Name, 'gb' Short_Name, 1 Flag, '大不列颠联合王国' Memo FROM DUAL UNION 
SELECT 131 Id, 0 Version, 'GB' Type, 'gd' Code, '格林纳达' Name, 'gd' Short_Name, 1 Flag, '格林纳达' Memo FROM DUAL UNION 
SELECT 132 Id, 0 Version, 'GB' Type, 'ge' Code, '格鲁吉亚' Name, 'ge' Short_Name, 1 Flag, '格鲁吉亚' Memo FROM DUAL UNION 
SELECT 133 Id, 0 Version, 'GB' Type, 'gf' Code, '法属圭亚那' Name, 'gf' Short_Name, 1 Flag, '法属圭亚那' Memo FROM DUAL UNION 
SELECT 134 Id, 0 Version, 'GB' Type, 'gh' Code, '加纳' Name, 'gh' Short_Name, 1 Flag, '加纳' Memo FROM DUAL UNION 
SELECT 135 Id, 0 Version, 'GB' Type, 'gi' Code, '直布罗陀' Name, 'gi' Short_Name, 1 Flag, '直布罗陀' Memo FROM DUAL UNION 
SELECT 136 Id, 0 Version, 'GB' Type, 'gl' Code, '格陵兰群岛' Name, 'gl' Short_Name, 1 Flag, '格陵兰群岛' Memo FROM DUAL UNION 
SELECT 137 Id, 0 Version, 'GB' Type, 'gm' Code, '冈比亚' Name, 'gm' Short_Name, 1 Flag, '冈比亚' Memo FROM DUAL UNION 
SELECT 138 Id, 0 Version, 'GB' Type, 'gn' Code, '几内亚' Name, 'gn' Short_Name, 1 Flag, '几内亚' Memo FROM DUAL UNION 
SELECT 139 Id, 0 Version, 'GB' Type, 'gp' Code, '瓜德罗普岛（法属）' Name, 'gp' Short_Name, 1 Flag, '瓜德罗普岛（法属）' Memo FROM DUAL UNION 
SELECT 140 Id, 0 Version, 'GB' Type, 'gr' Code, '希腊' Name, 'XL' Short_Name, 1 Flag, '希腊' Memo FROM DUAL UNION 
SELECT 141 Id, 0 Version, 'GB' Type, 'gt' Code, '危地马拉' Name, 'gt' Short_Name, 1 Flag, '危地马拉' Memo FROM DUAL UNION 
SELECT 142 Id, 0 Version, 'GB' Type, 'gu' Code, '关岛' Name, 'gu' Short_Name, 1 Flag, '关岛' Memo FROM DUAL UNION 
SELECT 143 Id, 0 Version, 'GB' Type, 'gw' Code, '几内亚比绍' Name, 'gw' Short_Name, 1 Flag, '几内亚比绍' Memo FROM DUAL UNION 
SELECT 144 Id, 0 Version, 'GB' Type, 'gy' Code, '圭亚那' Name, 'gy' Short_Name, 1 Flag, '圭亚那' Memo FROM DUAL UNION 
SELECT 145 Id, 0 Version, 'GB' Type, 'hk' Code, '香港' Name, 'hk' Short_Name, 1 Flag, '香港' Memo FROM DUAL UNION 
SELECT 146 Id, 0 Version, 'GB' Type, 'hm' Code, 'Heard' Name, 'hm' Short_Name, 1 Flag, 'Heard' Memo FROM DUAL UNION 
SELECT 147 Id, 0 Version, 'GB' Type, 'hn' Code, '洪都拉斯' Name, 'hn' Short_Name, 1 Flag, '洪都拉斯' Memo FROM DUAL UNION 
SELECT 148 Id, 0 Version, 'GB' Type, 'hr' Code, '克罗蒂亚' Name, 'hr' Short_Name, 1 Flag, '克罗蒂亚' Memo FROM DUAL UNION 
SELECT 149 Id, 0 Version, 'GB' Type, 'ht' Code, '海地' Name, 'ht' Short_Name, 1 Flag, '海地' Memo FROM DUAL UNION 
SELECT 150 Id, 0 Version, 'GB' Type, 'hu' Code, '匈牙利' Name, 'hu' Short_Name, 1 Flag, '匈牙利' Memo FROM DUAL UNION 
SELECT 151 Id, 0 Version, 'GB' Type, 'id' Code, '印度尼西亚' Name, 'id' Short_Name, 1 Flag, '印度尼西亚' Memo FROM DUAL UNION 
SELECT 152 Id, 0 Version, 'GB' Type, 'ie' Code, '爱尔兰共和国' Name, 'ie' Short_Name, 1 Flag, '爱尔兰共和国' Memo FROM DUAL UNION 
SELECT 153 Id, 0 Version, 'GB' Type, 'il' Code, '以色列' Name, 'il' Short_Name, 1 Flag, '以色列' Memo FROM DUAL UNION 
SELECT 154 Id, 0 Version, 'GB' Type, 'in' Code, '印度' Name, 'in' Short_Name, 1 Flag, '印度' Memo FROM DUAL UNION 
SELECT 155 Id, 0 Version, 'GB' Type, 'io' Code, '英属印度洋领地' Name, 'io' Short_Name, 1 Flag, '英属印度洋领地' Memo FROM DUAL UNION 
SELECT 156 Id, 0 Version, 'GB' Type, 'iq' Code, '伊拉克' Name, 'iq' Short_Name, 1 Flag, '伊拉克' Memo FROM DUAL UNION 
SELECT 157 Id, 0 Version, 'GB' Type, 'ir' Code, '伊朗' Name, 'ir' Short_Name, 1 Flag, '伊朗' Memo FROM DUAL UNION 
SELECT 158 Id, 0 Version, 'GB' Type, 'is' Code, '冰岛' Name, 'is' Short_Name, 1 Flag, '冰岛' Memo FROM DUAL UNION 
SELECT 159 Id, 0 Version, 'GB' Type, 'it' Code, '意大利' Name, 'it' Short_Name, 1 Flag, '意大利' Memo FROM DUAL UNION 
SELECT 160 Id, 0 Version, 'GB' Type, 'jm' Code, '牙买加' Name, 'jm' Short_Name, 1 Flag, '牙买加' Memo FROM DUAL UNION 
SELECT 161 Id, 0 Version, 'GB' Type, 'jo' Code, '约旦' Name, 'jo' Short_Name, 1 Flag, '约旦' Memo FROM DUAL UNION 
SELECT 162 Id, 0 Version, 'GB' Type, 'jp' Code, '日本' Name, 'jp' Short_Name, 1 Flag, '日本' Memo FROM DUAL UNION 
SELECT 163 Id, 0 Version, 'GB' Type, 'ke' Code, '肯尼亚' Name, 'ke' Short_Name, 1 Flag, '肯尼亚' Memo FROM DUAL UNION 
SELECT 164 Id, 0 Version, 'GB' Type, 'kg' Code, '吉尔吉斯斯坦' Name, 'kg' Short_Name, 1 Flag, '吉尔吉斯斯坦' Memo FROM DUAL UNION 
SELECT 165 Id, 0 Version, 'GB' Type, 'kh' Code, '柬埔塞' Name, 'kh' Short_Name, 1 Flag, '柬埔塞' Memo FROM DUAL UNION 
SELECT 166 Id, 0 Version, 'GB' Type, 'ki' Code, '基里巴斯' Name, 'ki' Short_Name, 1 Flag, '基里巴斯' Memo FROM DUAL UNION 
SELECT 167 Id, 0 Version, 'GB' Type, 'km' Code, '科摩罗' Name, 'km' Short_Name, 1 Flag, '科摩罗' Memo FROM DUAL UNION 
SELECT 168 Id, 0 Version, 'GB' Type, 'kn' Code, 'St. Kitts' Name, 'kn' Short_Name, 1 Flag, 'St. Kitts' Memo FROM DUAL UNION 
SELECT 169 Id, 0 Version, 'GB' Type, 'kp' Code, '北朝鲜' Name, 'kp' Short_Name, 1 Flag, '北朝鲜' Memo FROM DUAL UNION 
SELECT 170 Id, 0 Version, 'GB' Type, 'kr' Code, '南朝鲜' Name, 'kr' Short_Name, 1 Flag, '南朝鲜' Memo FROM DUAL UNION 
SELECT 171 Id, 0 Version, 'GB' Type, 'kw' Code, '科威特' Name, 'kw' Short_Name, 1 Flag, '科威特' Memo FROM DUAL UNION 
SELECT 172 Id, 0 Version, 'GB' Type, 'ky' Code, '开曼群岛（英属）' Name, 'ky' Short_Name, 1 Flag, '开曼群岛（英属）' Memo FROM DUAL UNION 
SELECT 173 Id, 0 Version, 'GB' Type, 'kz' Code, '哈萨克斯坦' Name, 'kz' Short_Name, 1 Flag, '哈萨克斯坦' Memo FROM DUAL UNION 
SELECT 174 Id, 0 Version, 'GB' Type, 'la' Code, '老挝人民共和国' Name, 'la' Short_Name, 1 Flag, '老挝人民共和国' Memo FROM DUAL UNION 
SELECT 175 Id, 0 Version, 'GB' Type, 'lb' Code, '黎巴嫩' Name, 'lb' Short_Name, 1 Flag, '黎巴嫩' Memo FROM DUAL UNION 
SELECT 176 Id, 0 Version, 'GB' Type, 'lc' Code, '圣露西亚岛' Name, 'lc' Short_Name, 1 Flag, '圣露西亚岛' Memo FROM DUAL UNION 
SELECT 177 Id, 0 Version, 'GB' Type, 'li' Code, '列支敦士登' Name, 'li' Short_Name, 1 Flag, '列支敦士登' Memo FROM DUAL UNION 
SELECT 178 Id, 0 Version, 'GB' Type, 'lk' Code, '斯里兰卡' Name, 'lk' Short_Name, 1 Flag, '斯里兰卡' Memo FROM DUAL UNION 
SELECT 179 Id, 0 Version, 'GB' Type, 'lr' Code, '利比里亚' Name, 'lr' Short_Name, 1 Flag, '利比里亚' Memo FROM DUAL UNION 
SELECT 180 Id, 0 Version, 'GB' Type, 'ls' Code, '莱索托' Name, 'ls' Short_Name, 1 Flag, '莱索托' Memo FROM DUAL UNION 
SELECT 181 Id, 0 Version, 'GB' Type, 'lt' Code, '立陶宛' Name, 'lt' Short_Name, 1 Flag, '立陶宛' Memo FROM DUAL UNION 
SELECT 182 Id, 0 Version, 'GB' Type, 'lu' Code, '卢森堡' Name, 'lu' Short_Name, 1 Flag, '卢森堡' Memo FROM DUAL UNION 
SELECT 183 Id, 0 Version, 'GB' Type, 'lv' Code, '拉脱维亚' Name, 'lv' Short_Name, 1 Flag, '拉脱维亚' Memo FROM DUAL UNION 
SELECT 184 Id, 0 Version, 'GB' Type, 'ly' Code, '利比亚' Name, 'ly' Short_Name, 1 Flag, '利比亚' Memo FROM DUAL UNION 
SELECT 185 Id, 0 Version, 'GB' Type, 'ma' Code, '摩洛哥' Name, 'ma' Short_Name, 1 Flag, '摩洛哥' Memo FROM DUAL UNION 
SELECT 186 Id, 0 Version, 'GB' Type, 'mc' Code, '摩纳哥' Name, 'mc' Short_Name, 1 Flag, '摩纳哥' Memo FROM DUAL UNION 
SELECT 187 Id, 0 Version, 'GB' Type, 'md' Code, '摩尔多瓦' Name, 'md' Short_Name, 1 Flag, '摩尔多瓦' Memo FROM DUAL UNION 
SELECT 188 Id, 0 Version, 'GB' Type, 'mg' Code, '马达加斯加' Name, 'mg' Short_Name, 1 Flag, '马达加斯加' Memo FROM DUAL UNION 
SELECT 189 Id, 0 Version, 'GB' Type, 'mh' Code, '马绍尔群岛' Name, 'mh' Short_Name, 1 Flag, '马绍尔群岛' Memo FROM DUAL UNION 
SELECT 190 Id, 0 Version, 'GB' Type, 'ml' Code, '马里' Name, 'ml' Short_Name, 1 Flag, '马里' Memo FROM DUAL UNION 
SELECT 191 Id, 0 Version, 'GB' Type, 'mm' Code, '缅甸' Name, 'mm' Short_Name, 1 Flag, '缅甸' Memo FROM DUAL UNION 
SELECT 192 Id, 0 Version, 'GB' Type, 'mn' Code, '蒙古' Name, 'mn' Short_Name, 1 Flag, '蒙古' Memo FROM DUAL UNION 
SELECT 193 Id, 0 Version, 'GB' Type, 'mo' Code, '澳门' Name, 'mo' Short_Name, 1 Flag, '澳门' Memo FROM DUAL UNION 
SELECT 194 Id, 0 Version, 'GB' Type, 'mp' Code, '北马里亚纳群岛' Name, 'mp' Short_Name, 1 Flag, '北马里亚纳群岛' Memo FROM DUAL UNION 
SELECT 195 Id, 0 Version, 'GB' Type, 'mq' Code, '马提尼克岛（法属）' Name, 'mq' Short_Name, 1 Flag, '马提尼克岛（法属）' Memo FROM DUAL UNION 
SELECT 196 Id, 0 Version, 'GB' Type, 'mr' Code, '毛里塔尼亚' Name, 'mr' Short_Name, 1 Flag, '毛里塔尼亚' Memo FROM DUAL UNION 
SELECT 197 Id, 0 Version, 'GB' Type, 'ms' Code, '蒙塞拉特岛' Name, 'ms' Short_Name, 1 Flag, '蒙塞拉特岛' Memo FROM DUAL UNION 
SELECT 198 Id, 0 Version, 'GB' Type, 'mt' Code, '马尔他' Name, 'mt' Short_Name, 1 Flag, '马尔他' Memo FROM DUAL UNION 
SELECT 199 Id, 0 Version, 'GB' Type, 'mv' Code, '马尔代夫' Name, 'mv' Short_Name, 1 Flag, '马尔代夫' Memo FROM DUAL UNION 
SELECT 200 Id, 0 Version, 'GB' Type, 'mw' Code, '马拉维' Name, 'mw' Short_Name, 1 Flag, '马拉维' Memo FROM DUAL UNION 
SELECT 201 Id, 0 Version, 'GB' Type, 'mx' Code, '墨西哥' Name, 'mx' Short_Name, 1 Flag, '墨西哥' Memo FROM DUAL UNION 
SELECT 202 Id, 0 Version, 'GB' Type, 'my' Code, '马来西亚' Name, 'my' Short_Name, 1 Flag, '马来西亚' Memo FROM DUAL UNION 
SELECT 203 Id, 0 Version, 'GB' Type, 'mz' Code, '莫桑比克' Name, 'mz' Short_Name, 1 Flag, '莫桑比克' Memo FROM DUAL UNION 
SELECT 204 Id, 0 Version, 'GB' Type, 'na' Code, '纳米比亚' Name, 'na' Short_Name, 1 Flag, '纳米比亚' Memo FROM DUAL UNION 
SELECT 205 Id, 0 Version, 'GB' Type, 'nc' Code, '新喀里多尼亚' Name, 'nc' Short_Name, 1 Flag, '新喀里多尼亚' Memo FROM DUAL UNION 
SELECT 206 Id, 0 Version, 'GB' Type, 'ne' Code, '尼日尔' Name, 'ne' Short_Name, 1 Flag, '尼日尔' Memo FROM DUAL UNION 
SELECT 207 Id, 0 Version, 'GB' Type, 'nf' Code, '诺福克岛' Name, 'nf' Short_Name, 1 Flag, '诺福克岛' Memo FROM DUAL UNION 
SELECT 208 Id, 0 Version, 'GB' Type, 'ng' Code, '尼日利亚' Name, 'ng' Short_Name, 1 Flag, '尼日利亚' Memo FROM DUAL UNION 
SELECT 209 Id, 0 Version, 'GB' Type, 'ni' Code, '尼加拉瓜' Name, 'ni' Short_Name, 1 Flag, '尼加拉瓜' Memo FROM DUAL UNION 
SELECT 210 Id, 0 Version, 'GB' Type, 'nl' Code, '荷兰' Name, 'nl' Short_Name, 1 Flag, '荷兰' Memo FROM DUAL UNION 
SELECT 211 Id, 0 Version, 'GB' Type, 'no' Code, '挪威' Name, 'no' Short_Name, 1 Flag, '挪威' Memo FROM DUAL UNION 
SELECT 212 Id, 0 Version, 'GB' Type, 'np' Code, '尼泊尔' Name, 'np' Short_Name, 1 Flag, '尼泊尔' Memo FROM DUAL UNION 
SELECT 213 Id, 0 Version, 'GB' Type, 'nr' Code, '瑙鲁' Name, 'nr' Short_Name, 1 Flag, '瑙鲁' Memo FROM DUAL UNION 
SELECT 214 Id, 0 Version, 'GB' Type, 'nt' Code, '中立区' Name, 'nt' Short_Name, 1 Flag, '中立区' Memo FROM DUAL UNION 
SELECT 215 Id, 0 Version, 'GB' Type, 'nu' Code, '纽埃' Name, 'nu' Short_Name, 1 Flag, '纽埃' Memo FROM DUAL UNION 
SELECT 216 Id, 0 Version, 'GB' Type, 'nz' Code, '新西兰' Name, 'nz' Short_Name, 1 Flag, '新西兰' Memo FROM DUAL UNION 
SELECT 217 Id, 0 Version, 'GB' Type, 'om' Code, '阿曼' Name, 'om' Short_Name, 1 Flag, '阿曼' Memo FROM DUAL UNION 
SELECT 218 Id, 0 Version, 'GB' Type, 'pa' Code, '巴拿马' Name, 'pa' Short_Name, 1 Flag, '巴拿马' Memo FROM DUAL UNION 
SELECT 219 Id, 0 Version, 'GB' Type, 'pe' Code, '秘鲁' Name, 'pe' Short_Name, 1 Flag, '秘鲁' Memo FROM DUAL UNION 
SELECT 220 Id, 0 Version, 'GB' Type, 'pf' Code, '法属玻利尼西亚' Name, 'pf' Short_Name, 1 Flag, '法属玻利尼西亚' Memo FROM DUAL UNION 
SELECT 221 Id, 0 Version, 'GB' Type, 'pg' Code, '巴布亚新几内亚' Name, 'pg' Short_Name, 1 Flag, '巴布亚新几内亚' Memo FROM DUAL UNION 
SELECT 222 Id, 0 Version, 'GB' Type, 'ph' Code, '菲律宾' Name, 'ph' Short_Name, 1 Flag, '菲律宾' Memo FROM DUAL UNION 
SELECT 223 Id, 0 Version, 'GB' Type, 'pk' Code, '巴基斯坦' Name, 'pk' Short_Name, 1 Flag, '巴基斯坦' Memo FROM DUAL UNION 
SELECT 224 Id, 0 Version, 'GB' Type, 'pl' Code, '波兰' Name, 'pl' Short_Name, 1 Flag, '波兰' Memo FROM DUAL UNION 
SELECT 225 Id, 0 Version, 'GB' Type, 'pm' Code, 'St. Pierre' Name, 'pm' Short_Name, 1 Flag, 'St. Pierre' Memo FROM DUAL UNION 
SELECT 226 Id, 0 Version, 'GB' Type, 'pn' Code, '皮特克恩岛' Name, 'pn' Short_Name, 1 Flag, '皮特克恩岛' Memo FROM DUAL UNION 
SELECT 227 Id, 0 Version, 'GB' Type, 'pr' Code, '波多黎各' Name, 'pr' Short_Name, 1 Flag, '波多黎各' Memo FROM DUAL UNION 
SELECT 228 Id, 0 Version, 'GB' Type, 'pt' Code, '葡萄牙' Name, 'pt' Short_Name, 1 Flag, '葡萄牙' Memo FROM DUAL UNION 
SELECT 229 Id, 0 Version, 'GB' Type, 'pw' Code, '帕劳' Name, 'pw' Short_Name, 1 Flag, '帕劳' Memo FROM DUAL UNION 
SELECT 230 Id, 0 Version, 'GB' Type, 'py' Code, '巴拉圭' Name, 'py' Short_Name, 1 Flag, '巴拉圭' Memo FROM DUAL UNION 
SELECT 231 Id, 0 Version, 'GB' Type, 'qa' Code, '卡塔尔' Name, 'qa' Short_Name, 1 Flag, '卡塔尔' Memo FROM DUAL UNION 
SELECT 232 Id, 0 Version, 'GB' Type, 're' Code, '留尼汪岛（法属）' Name, 're' Short_Name, 1 Flag, '留尼汪岛（法属）' Memo FROM DUAL UNION 
SELECT 233 Id, 0 Version, 'GB' Type, 'ro' Code, '罗马尼亚' Name, 'ro' Short_Name, 1 Flag, '罗马尼亚' Memo FROM DUAL UNION 
SELECT 234 Id, 0 Version, 'GB' Type, 'ru' Code, '俄罗斯联邦' Name, 'ru' Short_Name, 1 Flag, '俄罗斯联邦' Memo FROM DUAL UNION 
SELECT 235 Id, 0 Version, 'GB' Type, 'rw' Code, '卢旺达' Name, 'rw' Short_Name, 1 Flag, '卢旺达' Memo FROM DUAL UNION 
SELECT 236 Id, 0 Version, 'GB' Type, 'sa' Code, '沙特阿拉伯' Name, 'sa' Short_Name, 1 Flag, '沙特阿拉伯' Memo FROM DUAL UNION 
SELECT 237 Id, 0 Version, 'GB' Type, 'sb' Code, '所罗门群岛' Name, 'sb' Short_Name, 1 Flag, '所罗门群岛' Memo FROM DUAL UNION 
SELECT 238 Id, 0 Version, 'GB' Type, 'sc' Code, '塞舌尔' Name, 'sc' Short_Name, 1 Flag, '塞舌尔' Memo FROM DUAL UNION 
SELECT 239 Id, 0 Version, 'GB' Type, 'sd' Code, '苏旦' Name, 'sd' Short_Name, 1 Flag, '苏旦' Memo FROM DUAL UNION 
SELECT 240 Id, 0 Version, 'GB' Type, 'se' Code, '瑞典' Name, 'se' Short_Name, 1 Flag, '瑞典' Memo FROM DUAL UNION 
SELECT 241 Id, 0 Version, 'GB' Type, 'sg' Code, '新加坡' Name, 'sg' Short_Name, 1 Flag, '新加坡' Memo FROM DUAL UNION 
SELECT 242 Id, 0 Version, 'GB' Type, 'sh' Code, '海伦娜' Name, 'sh' Short_Name, 1 Flag, '海伦娜' Memo FROM DUAL UNION 
SELECT 243 Id, 0 Version, 'GB' Type, 'si' Code, '斯洛文尼亚' Name, 'si' Short_Name, 1 Flag, '斯洛文尼亚' Memo FROM DUAL UNION 
SELECT 244 Id, 0 Version, 'GB' Type, 'sj' Code, 'Svalbard' Name, 'sj' Short_Name, 1 Flag, 'Svalbard' Memo FROM DUAL UNION 
SELECT 245 Id, 0 Version, 'GB' Type, 'sk' Code, '斯洛伐克' Name, 'sk' Short_Name, 1 Flag, '斯洛伐克' Memo FROM DUAL UNION 
SELECT 246 Id, 0 Version, 'GB' Type, 'sl' Code, '塞拉利昂' Name, 'sl' Short_Name, 1 Flag, '塞拉利昂' Memo FROM DUAL UNION 
SELECT 247 Id, 0 Version, 'GB' Type, 'sm' Code, '圣马力诺' Name, 'sm' Short_Name, 1 Flag, '圣马力诺' Memo FROM DUAL UNION 
SELECT 248 Id, 0 Version, 'GB' Type, 'sn' Code, '塞内加尔' Name, 'sn' Short_Name, 1 Flag, '塞内加尔' Memo FROM DUAL UNION 
SELECT 249 Id, 0 Version, 'GB' Type, 'so' Code, '索马里' Name, 'so' Short_Name, 1 Flag, '索马里' Memo FROM DUAL UNION 
SELECT 250 Id, 0 Version, 'GB' Type, 'sr' Code, '苏里南' Name, 'sr' Short_Name, 1 Flag, '苏里南' Memo FROM DUAL UNION 
SELECT 251 Id, 0 Version, 'GB' Type, 'st' Code, 'Sao Tome' Name, 'st' Short_Name, 1 Flag, 'Sao Tome' Memo FROM DUAL UNION 
SELECT 252 Id, 0 Version, 'GB' Type, 'su' Code, '苏联' Name, 'su' Short_Name, 1 Flag, '苏联' Memo FROM DUAL UNION 
SELECT 253 Id, 0 Version, 'GB' Type, 'sy' Code, '叙利亚' Name, 'sy' Short_Name, 1 Flag, '叙利亚' Memo FROM DUAL UNION 
SELECT 254 Id, 0 Version, 'GB' Type, 'sz' Code, '斯威士兰' Name, 'sz' Short_Name, 1 Flag, '斯威士兰' Memo FROM DUAL UNION 
SELECT 255 Id, 0 Version, 'GB' Type, 'tc' Code, 'Turks' Name, 'tc' Short_Name, 1 Flag, 'Turks' Memo FROM DUAL UNION 
SELECT 256 Id, 0 Version, 'GB' Type, 'td' Code, '乍得' Name, 'td' Short_Name, 1 Flag, '乍得' Memo FROM DUAL UNION 
SELECT 257 Id, 0 Version, 'GB' Type, 'tf' Code, '法属南半球领地' Name, 'tf' Short_Name, 1 Flag, '法属南半球领地' Memo FROM DUAL UNION 
SELECT 258 Id, 0 Version, 'GB' Type, 'tg' Code, '多哥' Name, 'tg' Short_Name, 1 Flag, '多哥' Memo FROM DUAL UNION 
SELECT 259 Id, 0 Version, 'GB' Type, 'th' Code, '泰国' Name, 'th' Short_Name, 1 Flag, '泰国' Memo FROM DUAL UNION 
SELECT 260 Id, 0 Version, 'GB' Type, 'tj' Code, '塔吉克斯坦' Name, 'tj' Short_Name, 1 Flag, '塔吉克斯坦' Memo FROM DUAL UNION 
SELECT 261 Id, 0 Version, 'GB' Type, 'tk' Code, '托克劳群岛' Name, 'tk' Short_Name, 1 Flag, '托克劳群岛' Memo FROM DUAL UNION 
SELECT 262 Id, 0 Version, 'GB' Type, 'tm' Code, '土库曼斯坦' Name, 'tm' Short_Name, 1 Flag, '土库曼斯坦' Memo FROM DUAL UNION 
SELECT 263 Id, 0 Version, 'GB' Type, 'tn' Code, '突尼斯' Name, 'tn' Short_Name, 1 Flag, '突尼斯' Memo FROM DUAL UNION 
SELECT 264 Id, 0 Version, 'GB' Type, 'to' Code, '汤加' Name, 'to' Short_Name, 1 Flag, '汤加' Memo FROM DUAL UNION 
SELECT 265 Id, 0 Version, 'GB' Type, 'tp' Code, '东帝汶' Name, 'tp' Short_Name, 1 Flag, '东帝汶' Memo FROM DUAL UNION 
SELECT 266 Id, 0 Version, 'GB' Type, 'tr' Code, '土耳其' Name, 'tr' Short_Name, 1 Flag, '土耳其' Memo FROM DUAL UNION 
SELECT 267 Id, 0 Version, 'GB' Type, 'tt' Code, 'Trinidad' Name, 'tt' Short_Name, 1 Flag, 'Trinidad' Memo FROM DUAL UNION 
SELECT 268 Id, 0 Version, 'GB' Type, 'tv' Code, '图瓦鲁' Name, 'tv' Short_Name, 1 Flag, '图瓦鲁' Memo FROM DUAL UNION 
SELECT 269 Id, 0 Version, 'GB' Type, 'tw' Code, '中国台湾' Name, 'tw' Short_Name, 1 Flag, '中国台湾' Memo FROM DUAL UNION 
SELECT 270 Id, 0 Version, 'GB' Type, 'tz' Code, '坦桑尼亚' Name, 'tz' Short_Name, 1 Flag, '坦桑尼亚' Memo FROM DUAL UNION 
SELECT 271 Id, 0 Version, 'GB' Type, 'ua' Code, '乌克兰' Name, 'ua' Short_Name, 1 Flag, '乌克兰' Memo FROM DUAL UNION 
SELECT 272 Id, 0 Version, 'GB' Type, 'ug' Code, '乌干达' Name, 'ug' Short_Name, 1 Flag, '乌干达' Memo FROM DUAL UNION 
SELECT 273 Id, 0 Version, 'GB' Type, 'uk' Code, '英国' Name, 'uk' Short_Name, 1 Flag, '英国' Memo FROM DUAL UNION 
SELECT 274 Id, 0 Version, 'GB' Type, 'us' Code, '美国' Name, 'us' Short_Name, 1 Flag, '美国' Memo FROM DUAL UNION 
SELECT 275 Id, 0 Version, 'GB' Type, 'uy' Code, '乌拉圭' Name, 'uy' Short_Name, 1 Flag, '乌拉圭' Memo FROM DUAL UNION 
SELECT 276 Id, 0 Version, 'GB' Type, 'va' Code, '梵地冈' Name, 'va' Short_Name, 1 Flag, '梵地冈' Memo FROM DUAL UNION 
SELECT 277 Id, 0 Version, 'GB' Type, 'vc' Code, 'St. Vincent' Name, 'vc' Short_Name, 1 Flag, 'St. Vincent' Memo FROM DUAL UNION 
SELECT 278 Id, 0 Version, 'GB' Type, 've' Code, '委内瑞拉' Name, 've' Short_Name, 1 Flag, '委内瑞拉' Memo FROM DUAL UNION 
SELECT 279 Id, 0 Version, 'GB' Type, 'vg' Code, '维京群岛' Name, 'vg' Short_Name, 1 Flag, '维京群岛' Memo FROM DUAL UNION 
SELECT 280 Id, 0 Version, 'GB' Type, 'vn' Code, '越南' Name, 'vn' Short_Name, 1 Flag, '越南' Memo FROM DUAL UNION 
SELECT 281 Id, 0 Version, 'GB' Type, 'vu' Code, '瓦努阿图' Name, 'vu' Short_Name, 1 Flag, '瓦努阿图' Memo FROM DUAL UNION 
SELECT 282 Id, 0 Version, 'GB' Type, 'wf' Code, 'Wallis' Name, 'wf' Short_Name, 1 Flag, 'Wallis' Memo FROM DUAL UNION 
SELECT 283 Id, 0 Version, 'GB' Type, 'ws' Code, '东萨摩亚' Name, 'ws' Short_Name, 1 Flag, '东萨摩亚' Memo FROM DUAL UNION 
SELECT 284 Id, 0 Version, 'GB' Type, 'ye' Code, '也门' Name, 'ye' Short_Name, 1 Flag, '也门' Memo FROM DUAL UNION 
SELECT 285 Id, 0 Version, 'GB' Type, 'yu' Code, '南斯拉夫' Name, 'yu' Short_Name, 1 Flag, '南斯拉夫' Memo FROM DUAL UNION 
SELECT 286 Id, 0 Version, 'GB' Type, 'za' Code, '南非' Name, 'za' Short_Name, 1 Flag, '南非' Memo FROM DUAL UNION 
SELECT 287 Id, 0 Version, 'GB' Type, 'zm' Code, '赞比亚' Name, 'zm' Short_Name, 1 Flag, '赞比亚' Memo FROM DUAL UNION 
SELECT 288 Id, 0 Version, 'GB' Type, 'zr' Code, '扎伊尔' Name, 'zr' Short_Name, 1 Flag, '扎伊尔' Memo FROM DUAL UNION 
SELECT 289 Id, 0 Version, 'GB' Type, 'zw' Code, '津巴布韦' Name, 'zw' Short_Name, 1 Flag, '津巴布韦' Memo FROM DUAL
UNION	-- 证件类型
SELECT 290 Id, 0 Version, 'ZJLX' Type, '01' Code, '中华人民共和国居民身份证' Name, '身份证' Short_Name, 1 Flag, '中华人民共和国居民身份证' Memo FROM DUAL UNION
SELECT 291 Id, 0 Version, 'ZJLX' Type, '02' Code, '军人证件' Name, '军官证' Short_Name, 1 Flag, '军人证件' Memo FROM DUAL UNION
SELECT 292 Id, 0 Version, 'ZJLX' Type, '03' Code, '港澳台身份证件' Name, '港澳台身份证件' Short_Name, 1 Flag, '港澳台身份证件' Memo FROM DUAL UNION
SELECT 293 Id, 0 Version, 'ZJLX' Type, '04' Code, '华侨身份证' Name, '华侨身份证' Short_Name, 1 Flag, '华侨身份证' Memo FROM DUAL UNION
SELECT 294 Id, 0 Version, 'ZJLX' Type, '05' Code, '外籍护照' Name, '外籍护照' Short_Name, 1 Flag, '外籍护照' Memo FROM DUAL
UNION	-- 客户机类型
SELECT 295 Id, 0 Version, 'KHJLX' Type, '0001' Code, '工作站' Name, '工作站' Short_Name, 1 Flag, '工作站' Memo FROM DUAL UNION
SELECT 296 Id, 0 Version, 'KHJLX' Type, '0002' Code, 'IVR' Name, 'IVR' Short_Name, 1 Flag, 'IVR' Memo FROM DUAL UNION
SELECT 297 Id, 0 Version, 'KHJLX' Type, '0003' Code, '自助圈存机' Name, '自助圈存机' Short_Name, 1 Flag, '自助圈存机' Memo FROM DUAL UNION
SELECT 298 Id, 0 Version, 'KHJLX' Type, '0004' Code, 'BS' Name, 'BS' Short_Name, 1 Flag, 'BS' Memo FROM DUAL UNION
SELECT 299 Id, 0 Version, 'KHJLX' Type, '0005' Code, '校园前置机' Name, '校园前置机' Short_Name, 1 Flag, '校园前置机' Memo FROM DUAL UNION
SELECT 300 Id, 0 Version, 'KHJLX' Type, '0006' Code, '银行前置机' Name, '银行前置机' Short_Name, 1 Flag, '银行前置机' Memo FROM DUAL UNION
SELECT 301 Id, 0 Version, 'KHJLX' Type, '0007' Code, '子系统前置机' Name, '子系统前置机' Short_Name, 1 Flag, '子系统前置机' Memo FROM DUAL
UNION	-- 性别
SELECT 302 Id, 0 Version, 'XB' Type, '1' Code, '男' Name, '男' Short_Name, 1 Flag, '' Memo FROM DUAL UNION
SELECT 303 Id, 0 Version, 'XB' Type, '2' Code, '女' Name, '女' Short_Name, 1 Flag, '' Memo FROM DUAL UNION
SELECT 304 Id, 0 Version, 'XB' Type, '9' Code, '未知' Name, '未知' Short_Name, 1 Flag, '' Memo FROM DUAL
UNION	-- 血型
SELECT 305 Id, 0 Version, 'XX' Type, '0' Code, '未知' Name, '未知' Short_Name, 1 Flag, '' Memo FROM DUAL UNION
SELECT 306 Id, 0 Version, 'XX' Type, '1' Code, 'A型' Name, 'A型' Short_Name, 1 Flag, '' Memo FROM DUAL UNION
SELECT 307 Id, 0 Version, 'XX' Type, '2' Code, 'B型' Name, 'B型' Short_Name, 1 Flag, '' Memo FROM DUAL UNION
SELECT 308 Id, 0 Version, 'XX' Type, '3' Code, 'AB型' Name, 'AB型' Short_Name, 1 Flag, '' Memo FROM DUAL UNION
SELECT 309 Id, 0 Version, 'XX' Type, '4' Code, 'O型' Name, 'O型' Short_Name, 1 Flag, '' Memo FROM DUAL UNION
SELECT 310 Id, 0 Version, 'XX' Type, '9' Code, '未定血型' Name, '未定血型' Short_Name, 1 Flag, '' Memo FROM DUAL
/
ALTER VIEW V_DIC ADD CONSTRAINT Pk_V_Test_Mz PRIMARY KEY (Id) DISABLE NOVALIDATE
/